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
1
vote
1 answer

DAX: How to implement CREATE MEMBER MDX function in SSAS Tabular Model

I have a task to convert existing MDX measures (from multidimensional model) into DAX (tabular model). During this task I found that in DAX there is no functionality to use "CREATE MEMBER" option as it was in MDX. But I have some members created…
user1523087
  • 149
  • 2
  • 10
1
vote
1 answer

How to use UNION in MDX

I want to UNION the below MDX query. For these two queries measures and dimensions are different for the same date range. Please help me to get out of this. SELECT NON EMPTY { [Measures].[Number of es2] } ON COLUMNS, NON EMPTY {…
Suraj Patil
  • 33
  • 1
  • 7
1
vote
1 answer

Can you find Measures in OLAPQueryLog?

Is it possible to find what Measures are used by looking at the OLAPQueryLog? It's easy enough to get the attributes and dimensions from the DataSet column. However, I can't see any information about the measures (and calculated measures) that are…
James
  • 21
  • 2
1
vote
2 answers

Data modelling design

I'm reading Kimball's data-warehouse book at the moment and at the same time, I'm looking at designing a data warehouse for the following example: 1: Client can buy products which would generate an invoice which then would generate a inventory row.…
user172839
  • 1,035
  • 1
  • 10
  • 19
1
vote
0 answers

Cannot reopen an Analysis Services Tabular Project the second time– error database already exists in the detached state

Using SQL Server Analysis Services 2019 running in Tabular mode, I get this error every time I open an existing Tabular Project solution in Visual Studio 2017 (version 15.9.3, though I don't think the version is the issue). Even creating a new…
paulH
  • 1,102
  • 16
  • 43
1
vote
0 answers

Is it possible to isolate browsing data to a specific SSAS partition

Is it possible to check which partition data resides in on a multidimensional Analysis Services cube? I'd like to make sure that data is contained in a particular partition, but I'm not sure how I could query for this.
Andy
  • 425
  • 1
  • 5
  • 16
1
vote
0 answers

Filtering on Cube in Excel - Does not work correctly

I have a cube.. the product as a dimension. The product dimension is made by using the product code as the key. As a display name I have used Product Name. In the data, I have 2 product codes with the same name: Code: 6 Name: Wine Code: 2100 Name:…
Akshay Mehta
  • 11
  • 1
1
vote
2 answers

Data factory SAP BW

I'm trying to use the Data Factory in Azure to export data from a SAP BW. The connection is working, and I'm able to get data. The problem is how I'm getting the data. The picture describes the issue pretty well. Has anyone encountered something…
Spoe
  • 21
  • 2
1
vote
0 answers

In a MS SSAS Project, creating a Data Source View over Npgsql (PostgreSQL) Data Source produces 42601: syntax error at or near '['

I'm trying to create Data Source View in a Multidimensional SSAS project using MS Visual Studio 2017 with SSDT installed. In the Data Source View Wizard, I select my Npgsql (v. 11.00) based datasource connecting my PostgreSQL 10.5 I created before.…
Jan Lender
  • 48
  • 8
1
vote
1 answer

MDX: filtering zero values out

I have a dataset that has a lot of 0 values for the measure so I would like to filter them out in my query. However I don't seem to be able to do it. It either doesn't work or I crash the query. I have tried using Having and also Filter but neither…
Daniel Aguilar
  • 11
  • 3
1
vote
1 answer

What does the DIMENSION TYPE do in SSAS?

I am more experienced with SSAS Tabular, but in my role at work I must support SSAS Multidimensional cubes. Earlier today I tried to add a time intelligence calculation (Parallel Period) to SSASMD connection in Excel pivot table. But the…
SherlockSpreadsheets
  • 2,062
  • 3
  • 27
  • 47
1
vote
1 answer

Different complexity of data extraction from cube(SSAS 2015) via excel 2013

When user connect to SSAS cubes 2015(cube size is approx 15-16 GB) from excel 2013. they browse the cube data by selecting the different combination of dimensions attributes and facts measures. This combination in excel to fetch the cube data can be…
ScriptSoft
  • 163
  • 1
  • 2
  • 11
1
vote
0 answers

Excel Cube Formulas

I apologize in advance for the length of this post: I have created an Excel user form and which has an has a connection to a SQL server database by way of Analysis Services. The data connection is feeding customer information to the form based on…
M Church
  • 11
  • 2
1
vote
0 answers

Cube not running the update from DTSX

I create a DTSX package to update data in a database and then to run the DIMENSIONS and CUBE. If I run the cube directly in Visual Studio or if I process manually the dimensions and the cube, everything works correctly. The problem is when I create…
Guido Caffa
  • 1,201
  • 1
  • 12
  • 22
1
vote
0 answers

SSAS/SSRS - Dimensionsecurity and Subscription

we have a few of SSAS-Cube-based reports that are displayed via SSRS-Webportal. We used dimension security, windowsauthorization and it works fine. (MS SQL Server 2016) My question: Now we need additionally subscriptions for these reports. What is…
AndreaAtWork
  • 11
  • 3
1 2 3
…
99
100