Questions tagged [ssas]

SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0

Filter by
Sorted by
Tagged with
4
votes
1answer
603 views

SSAS - Which way to order an attribute?

Our SSAS cube has a date dimension, which for the DayName string member displays alphabetically instead chronologically. I added a DayOfWeek integer 1-7 to use for ordering. I have two options to ...
2
votes
1answer
2k views

SSAS Cube - Create measure based on the a dimension attribute

We have an analysis service cube contains: 1 Measure = All_Calls_Count 2 dimensions = Month & Call Status The All_Calls_Count reflects the count of rows on the fact table as shown : Is it ...
0
votes
1answer
434 views

How to truncate an SSAS Tabular partition

I have a tabular cube with a large partitioned table. I'd like to truncate some of the partitions (freeing the memory space), but retain the metadata, so that I can quickly rebuild them if required ...
1
vote
1answer
146 views

How to emulate performant date dimension for SSAS model in tabular mode / direct query

I have an indexed datetime column - lets call it "CreatedDateUTC" in table "Entity" in MSSQL db. Column contains UTC datetime. User connecting to db has known timezone offset. I have another table - ...
1
vote
0answers
67 views

Incorrect hierarchy relationship while joining with parent-child tables

I have two tables with 1:M relation in my DB: GROUP (GroupId, GroupName, AccountId) USER (UserId, UserName, GroupId, AccountId) and ACCOUNT (AccountId, AccountName). I added all needed links from ...
1
vote
0answers
294 views

Unable to establish linked server connection to SSAS 2008 R2 server

I'm interested in gathering some DMV data from our SSAS cubes and store it on our management box. When I create the linked server for this effort I run into an error establishing the connection. ...
1
vote
0answers
906 views

SSAS 2012 role fails to start in a Win 2012 cluster

I started a thread in MSDN SSAS Forum. Please see this and help me understand the problem. I have never seen this sort of issue before. I'll try to explain the issue here as well. I got SQL Server ...
1
vote
0answers
353 views

Move SSAS database to another server without detach-attach

We take drive level snapshots of our source server every day, so we have copies of the folder OLAP\DATA. We are trying to restore a database from 10th March and 11th March to a destination server ...
5
votes
1answer
15k views

SSAS Tabular: ImpersonationMode that is not supported for processing operations

I have a SQL 2016 SP1 SSAS Tabular Instance. I've deployed a model with the following properties When I try to process the database or a table I get an error "The datasource contains an ...
1
vote
1answer
263 views

Can't modify FormatString on cube ( SSAS )

I'm trying to create a cube, to know a little more about SSAS and as a DBA, be prepared for anything ( almost ). When I'm changing SalesAmmount's FormatString to Currency, it doesn't change the ...
1
vote
1answer
81 views

Verify SSAS Backup returning arguments instead of expected output

Following the link http://geekswithblogs.net/darrengosbell/archive/2008/09/13/ssas-verifying-backups.aspx I tried to verify ssas backup and executed below mentioned command in specified path as in ...
0
votes
2answers
421 views

Newdatabase option is not available in sql server management studio 2014

I connect to analysis server using windows authentication. But I can't create the new database.
0
votes
1answer
316 views

STRTOMEMBER function throws error about finding a dimension [closed]

I'm really stumped here...trying to create some year-to-date measures for a Cube, with NOW() specifying the current month and day (minus a two-day lag), with year being specified by the current member ...
3
votes
1answer
1k views

Stop, Start, or Restart a SSAS Tabular service instance in PowerShell with Invoke-Command and $variables

I'm working on some PowerShell commands / scripts to stop, or start, or restart a SSAS Tabular service instance using Invoke-Command and some $variables. The end goal is to eventually put this code ...
2
votes
1answer
256 views

SSAS Multidimentional Drillthrough with Many-to-Many Relationships

I was browsing through the AdventureWorks DW 2012 sample, along with the accompanying SSAS cube sample, and noticed some interesting behavior related to drillthrough when a many-to-many relationship ...
1
vote
0answers
1k views

Improve SSAS Tabular query performance

I'be build a Tabular Cube with FactTable and four dimensions. Fact table has about 2.500.000 of rows (and about 20 calculated measures on the cube level) and dimension tables from 5k-50k of rows. When ...
2
votes
1answer
520 views

How to change the SSAS Multidimensional Cube partition location on disk?

I have a SSAS Multidimensional Cube. There is a measure group with multiple partitions (based on year). I need to move old partitions to a different physical (slower) disk. When I create the partition ...
3
votes
1answer
373 views

OLAP linked server fails connection test

I am trying to create a new linked server to an Analysis Services database and I would like to use this linked server to import data into a SQL Server table. example: SELECT * into raw.example FROM ...
-1
votes
1answer
236 views

SQL Server connection, session, command handling

I am trying to build an etl tool that tracks DMV data from SSAS Instance. To do that and in advance to record sql queries that users are request, i must know how the sql server handles the connection, ...
0
votes
1answer
55 views

DMV CONNECTION_HOST_APPLICATION field is NULL

I am trying to monitor cubes and expressions of Analysis Services using DMV queries that are stored on Server's RAM. I found many useful information about connections on connection's table of SSMS's ...
0
votes
1answer
70 views

SSAS Deployment Wizard - Issue with multiple connection strings

I've observed an issue with the SSAS Deployment Wizard. I have two environments DEV and PROD. A few weeks ago when I deployed anything on PROD I had one connection string only there to PROD (similar ...
2
votes
1answer
554 views

SSAS Cache Levels

I am using SSAS for reporting statistics on a big amount of data. Recently I began learning best practices for tuning and I am interesting in how SSAS caches the data. I have done my research and I'...
1
vote
1answer
202 views

Data Warehouse indexing approach - to verify

Could you take a look at my approach to the Data Warehouse indexing (SQL Server 2014 SP1 Ent) below and tell me is it correct or should I change it ? (our Data Warehouse most of the time is used for ...
2
votes
3answers
1k views

SSAS How to calculate Standard Deviation

I'm trying to calculate a variety of statistical calculation across a range of data such as Standard Deviation and Average. The data comes from many different "Data sources". These are are held in a ...
2
votes
2answers
4k views

SSAS Calculated measure with SCOPE.

I'm building an SSAS OLAP cube on Meteorological data. Some of this data can be totaled (eg rainfall) and some can't (like wind direction). I want totals, but only on data sources where it makes ...
2
votes
2answers
977 views

Using SSIS to extract query data and present it through a cube

The problem: I have a client who is running their application on SQL Server. They use SQL Server Analysis Services for additional reporting based on the cube that's been provided. It turns out, there ...
1
vote
0answers
140 views

SQL Server installation error: other instance on drive has filepath over 260 characters

I'm a first-time poster here so apologies for any etiquette lapses, but here is my question... I am attempting to install SQL Server 2012 Enterprise Edition Database Engine onto a SAN drive called E: ...
1
vote
1answer
53 views

SSAS 2016 tabular : Discrepancy on countrows between measures visual studio vs Excel

Is anyone aware of a SSAS (tabular) 2016 in which the number of records in a table are not fully shown in Excel? Say that when working in Visual Studio, a table has a rowcount of 740,000 records. We ...
1
vote
1answer
980 views

Error when only deploying a dimension on SSDT

I'm trying to follow a tutorial on SQL Server Analysis Services (SSAS) but I'm having trouble on deployment. Summarized, what I'm doing is: Open SQL Server Data Tools (SSDT) Creating a new ...
1
vote
0answers
120 views

SSAS 2014, Relation OLAP - Poor performance, high resource usage, what did I do wrong?

Let me start with the background, I was working on a project that needed a back end that was scalable and fast. Having worked quite a bit with SSAS, I thought I'd try SSAS's in memory solution, ...
0
votes
1answer
1k views

How to sum measure value for all records between two dimension values

I have a cube, called metric_cube, with a measure of Metric and a dimension Week with the given output on SSAS from SQL Server 2014. Current Output: Week Metric ---- ------ 1 6 2 5 3 ...
1
vote
0answers
135 views

users have access to ssas tabular instance without giving them a role

I have created a ssas tabular model. Testing the row level security base on a user I found out that it didn't work. I tested it on an user which is not known in the SQL database and analysis ...
2
votes
0answers
643 views

MDX calculation of an Average Over Time with delta update on the fact table

I am having a problem creating this MDX calculation : Average Price of products over time knowing that my fact table gets price updates incrementally; In order to calculate the average price of ...
0
votes
1answer
88 views

Analysis services access through MS Excel- permissions issues

I have an instance of Analysis Services set up with my cube and am attempting to access it through MS Excel. This works for one of my accounts but not for another. My goal is to get the second ...
2
votes
1answer
2k views

How can I get the actual SSAS error when processing a cube from a SQL Agent job?

I have a SASS cube on one server and a SSIS package on another server that triggers processing the cube. The SSIS package is executed via a scheduled SQL Agent job. I have enabled error reporting for ...
1
vote
1answer
789 views

How to move SSAS tabular instance databases?

We have a SQL Server 2012 SSAS tabular instance in our environment that is sitting in domain1. We need to move these SSAS databases in a different SQL server 2012 that is on domain2 which has no trust ...
2
votes
2answers
687 views

Clustering SSAS

We are using both SQL Server 2012 and 2014 always on. Here is my issue: we have an application that I have set up to use Availability groups(2014), however the issue I am having is that it uses ...
2
votes
2answers
2k views

SSAS where are olap cubes stored

Getting started on creating data cubes with SSAS. I understand the various types of OLAP options ROLAP, HOLAP and MOLAP. However, when creating a data cube using SSAS (at least for 2008 version) I do ...
2
votes
1answer
1k views

Remove Data From Memory when Using SSAS Tabular In-Memory Mode

I use SSAS Tabular in In-Memory mode. I also use partitions to divide my data. So I will have one partition per month. AFAIK, when using In-Memory mode, server keeps processed data in memory forever....
1
vote
1answer
437 views

SSAS - Applying Conversion Rates for Units of Measure

So I've been playing with this for the last day or so, and haven't been able to get an closer. I have a SSAS cube that has a measure group which displays total execution times for events in seconds. ...
3
votes
1answer
3k views

The following system error occurred: No mapping between account names and security IDs was done

While trying to Process a cube i go this error "Error 133 The following system error occurred: No mapping between account names and security IDs was done. 0 0" i know its some user which ...
2
votes
1answer
399 views

Adding Partitions to cube In SSAS via VS 2013

I am trying to add a new partition to my cube via SSDT 2013. I am using the Wizard and doing all stages that needed. After I click "Finish" nothing happens and I cannot see that a new partition has ...
1
vote
2answers
6k views

How to find the size, name and other details of Analysis server database?

How to find the size, name and other details of an Analysis Services database ? I have a Analysis Services server and I can see one database inside that. I want to know the size and other basic ...
2
votes
1answer
4k views

How do I tell which Edition and Version my SSAS Instance is running?

In SQL Server on the database engine, you can run a SQL query like this to get the server's version info like Edition and Version, and Update Level, etc. SELECT @@VERSION What is the MDX equivalent ...
3
votes
1answer
647 views

After processing complete, SSAS DB slowly consumes all available space on disk, w. high memory use also

This problem is with an SSAS 2012 SP3 (11.0.6020.0) multi-dimensional server, hosting a single cube database, containing 1 cube and 16 dimensions. Aggregations have been designed using SQL Management ...
1
vote
0answers
428 views

How to backup SSIS packages and CUBE Projects from Visual Studio 2013.5?

I'm using VisualStudio 2013.5 to develop SSIS, SSDT and SSAS Cubes (multidimensional and tabular model). I would like to ask you is there a possible to backup SSIS packages and SSAS cubes from ...
2
votes
1answer
662 views

Monitor number of records returned in a long-running SELECT statement during SSAS processing

On a SQL Server 2014, I have an SSAS tabular model which is querying a relational clustered columnstore table (with 800 mio. records), when the model is being processed. The query is just a simple ...
1
vote
1answer
2k views

SSAS Hierachies duplicates when browsing

The dimensions in the cube are giving us duplicates, there is no error while processing the cube, but when the cube is browsed we could see duplicates. There is a hierarchy in our dimension, the ...
2
votes
3answers
1k views

Cannot create SSRS subscription for a report using SSAS as datasource

My questions is : how should I config SSRS subscription a report, which consumes SSAS datasource. I already googled and lookup stackoverflow a lot and still couldn't make it work. Problems: I ...
0
votes
1answer
798 views

Problem with Processing Dimensions with Multiple Facts

I have a cube built in SSAS that uses 3 facts and 8 dimensions. Some of the dimensions are shared across 3 facts. When I process one of the dimension, it tries to process the underlying measure ...

1 2
3
4 5
7