Stack Overflow
Stack Overflow

Questions tagged [ssas]

SQL Server Analysis Services (SSAS) is part of Microsoft's SQL Server system. It provides Online Analytical Processing (OLAP) and Data Mining functionality. Not to be confused with Syntactically Awesome Style Sheets (SASS).

SQL Server Analysis Services (SSAS) is part of Microsoft's SQL Server system. It provides Online Analytical Processing (OLAP) and Data Mining functionality.

Initially released as part of SQL Server 7 it was further refined in SQL Server 2000. There were major changes from SQL 2000 to 2005 but since then (SQL2008 & SQL2008 R2) there have been incremental improvements. In SQL Server 2012, a new Tabular Model has been introduced.

You can find more information here: Wikipedia Analysis Services and here: Microsoft Analysis Services

5658 questions
9
votes
4 answers

How to determine which SSAS Cube is processing now?

There is a problem when several users can process the same cube simultaniously and as a result processing of cube fails. So I need to check if certain cube is processing at current moment.
Alekzander
  • 866
  • 3
  • 12
  • 12
8
votes
1 answer

Slow Excel pivot table MDX?

I am having an extremely hard time with Excel being very slow whenever interacting with a pivot table. Adding/removing a field, changing a filter or slicer, all take several minutes of Excel being frozen before responding. It appears that the MDX…
AaronLS
  • 37,329
  • 20
  • 143
  • 202
8
votes
2 answers

Implementing roleplaying dimension with friendly attribute names in SSAS?

I have a fact table that references my date dimension as both a Form Date and Finances Date. Hence the date dimension is roleplaying two different roles. This works fine, except that I can't roleplay the names of the Year or Month column. I would…
AaronLS
  • 37,329
  • 20
  • 143
  • 202
8
votes
2 answers

Update compatibility level - Azure SSAS

I need to update the compatibility level of the Azure SSAS Model to 1400. It's currently in 1200. When I click on Model.bim and go to Properties. (Inside Visual Studio 2017) There is no option to select from under the property "Compatibility…
Etienne
  • 7,141
  • 42
  • 108
  • 160
8
votes
1 answer

.dwproj cannot be opened because its project type (.dwproj) is not supported by this version of the application

When i try to open the SSAS project file, visual studio 2015 throw the following exception: 'projectfile.dwproj` cannot be opened because its project type (.dwproj) is not supported by this version of the application. To open it, please use a…
HasanHajjar
  • 149
  • 2
  • 14
8
votes
1 answer

MDX Query returns value in report but not in Visual Basic code

This is for an application which dynamically sets data for and renders reports. I have an MDX query for a report which relies on a parameter. The query is: SELECT NULL ON COLUMNS, strtomember(@DateYear) ON ROWS FROM [MYDATACUBE] When running this…
Caleb Johnson
  • 376
  • 3
  • 21
8
votes
1 answer

setting a measure value to NULL if a particular dimension is used in excel

I have an SSAS-2014 cube. I want to set a particular measure to NULL if a particular dimension is being used in either axis or the filter pane of a pivot table in excel. Now, the most intuitive solution, is to scope this measure to not work with the…
BICube
  • 4,451
  • 1
  • 23
  • 44
8
votes
3 answers

Is it possible to modify the content of HttpRequest POST in an IIS HttpModule?

I need to modify the content of certain HttpRequests (SSAS connection strings) in IIS. Basically, I need to add an element to the SOAP contained in the request. My approach so far has been to add a Filter to the HttpRequest, and perform the change…
Adam
  • 605
  • 1
  • 6
  • 7
8
votes
1 answer

Connecting to a SSAS cube using R

Is it possible to query a SQL Server Analysis Services cube using R? I have this cube on a different external Server and i am working from my machine but i have admin privileges on the Server with my domain account. To put it simply, i want to…
Johannes Wentu
  • 931
  • 1
  • 14
  • 28
8
votes
2 answers

Can OLAP CUBE be done in HBase?

Is there any way to create CUBE DIMENSIONS in HBase or OLAP with it? I want to create CUBE DIMENSIONS kind of application with my HBASE or HIVE and connect that with SSAS for reporting purpose, is that possible? If soo please guide me with some…
sudheer
  • 338
  • 1
  • 6
  • 17
8
votes
4 answers

How to fix 'error in the metadata manager dimension id of missing ' error in SSAS?

I have this error that keeps popping up from time to time, the error is along the lines of the following: Error -1055653635 : Errors in the metadata manager. The dimension with ID of <>, Name of <> referenced by the <> cube, does not exist. Error…
Rowan
  • 463
  • 3
  • 8
  • 20
8
votes
2 answers

SSAS 2012 cube browser- how can I create columns from dimensions?

I am new to SSAS, and have created a cube in SSAS 2012. When I browse the cube, I can easily at my dimensions as rows, but how do I add them as columns? In previous versions (I have access to a Cube created in 2008), when you browse the cube, you…
Lock
  • 5,422
  • 14
  • 66
  • 113
7
votes
4 answers

Handling nulls in Datawarehouse

I'd like to ask your input on what the best practice is for handling null or empty data values when it pertains to data warehousing and SSIS/SSAS. I have several fact and dimension tables that contain null values in different rows. Specifics: 1)…
rrydman
  • 501
  • 3
  • 9
  • 15
7
votes
2 answers

SSAS -> How do you hide an attribute that is used in a hierarchy? (without using perspectives)

I have some attributes that I am using to build hierarchies....(go figure).....after these attributes have been included in the hierarchy due to the change that I have made in their key columns they are no longer of use to an end user. If that…
Bill Blankenship
  • 3,316
  • 6
  • 43
  • 73
7
votes
3 answers

Creating SSAS 2008 cube partitions using Powershell?

How can we create SSAS 2008 cube partitions using Powershell?
Puneet Tripathi
  • 71
  • 2
1 2 3
…
99 100