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
2 answers

Calculate Cumulative Month Value in MDX

I wanna calculate the cumulative values by month/year My dimensions period as follow: Period Dimension I ve tried any ways to perform this operation, but unsucessfull with member [Measures].[Valor Acumulado] as…
Tonny Alves
  • 23
  • 3
1
vote
1 answer

Analysis service connection closed by remote host (Azure SQL Database)

While trying to load the FACT table (~15M Rows) in Analysis Service from a Azure SQL Database, I always get this error after one hour: Failed to save modifications to the server. Error returned: 'A transport-level error has occurred when receiving…
Souf
  • 369
  • 2
  • 16
1
vote
1 answer

How Do I Set Analysis Services' AllowedBrowsingFolders Property to Include Subdirectories?

The folder browser in SSAS is limited to folders that are explicitly listed in the server's AllowedBrowsingFolders property. For example, when I use the Restore Database dialog box, I can only see the folders I've listed in the property setting, not…
DataWriter
  • 1,010
  • 1
  • 10
  • 25
1
vote
1 answer

Get names all currently available members

I have Action URL which will open web site from excel. I need to pass names of all employee which are currently listed in excel to that web site. This list is coming from cube and could be filter by user using many different measures. But after…
Remek
  • 11
  • 2
1
vote
1 answer

Aggregate Facts bases on selected Dimension members

How to add a Total Column like in below image. the Query Structure is as below WITH MEMBER [Measure].[Total Responses] AS [Measures].[Responses] MEMBER [Measure].[Option 1] as CoalesceEmpty([Measures].[Option1],0) MEMBER…
Kritul Rathod
  • 75
  • 1
  • 11
1
vote
0 answers

VS SSRS 2017 automated DAX bringing no results but fetching results in query designer

Today I had to upgrade my developer edition of SQL Server, going from 2014 to 2017. With this I also had to upgrade our reports using SSDT 2017. Our old report datasets where in MDX format, and it had no measures defined, which 2017 really kicked…
C. Brindle
  • 43
  • 6
1
vote
1 answer

SSAS - No of Working Days as Named Calculation

I am new to SSAS. I have a requirement, I need to calculate no of working days between user selected date range (either in Excel or SSRS or PowerBI). I found the MDX query, I need assistance with create a named calculation with MDX expression. Date…
Rathish Kumar B
  • 1,271
  • 10
  • 21
1
vote
2 answers

forcing SSAS respecting relationships between dimensions

with regard to the following question and the given response I have the following question: I am facing the same issue, but creating a bridge table like mentioned above is no option in my case as I still need the separate dimensions for other…
peno
  • 11
  • 2
1
vote
1 answer

Finding which function cause the error message while processing a table

by processing (Process Full,Process Data) a table (every table) in my cube, I get the following error: Failed to save modifications to the server. Error returned: 'A function 'MAX' has been used in a True/False expression that is used as a table…
Kaja
  • 2,962
  • 18
  • 63
  • 99
1
vote
1 answer

How To Have Running Total Based on Filtered Date in MDX?

I need to have calculated member to calculate running total base on Dim Date that should work with all dates that filtered in reports. most of solutions calculates from first date in Dim Date or Null to Current Member, but I need to calculate from…
sepideh.sp
  • 61
  • 6
1
vote
1 answer

SSAS MDX Calculated Measure - COUNT of [ITEMS].[Item] grouped [Items].[Item Group]

In Excel connected to SSAS, I am trying to build a pivot table and add a custom Measure Calculation using "OLAP Tools" and/or "OLAP Pivot Table Exensions". I am trying to add a calculation that is really simple in my mind, but I cannot get it to…
SherlockSpreadsheets
  • 2,062
  • 3
  • 27
  • 47
1
vote
1 answer

AdventureWorks date dimension shows different results depending on selected hierarchy

Here are two simple queries which shows data on month level filtered by dates. In the first query I am using Month level of "Date.Calendar" user hierarchy. SELECT NON EMPTY { [Measures].[Internet Sales Amount] } ON 0, NON EMPTY {…
Upeslacis
  • 23
  • 3
1
vote
1 answer

SSAS Tabular Model: change cases of string value doesn't work

Just wondering if there is a way that the tabular model can reflect cases changes after I update back-end data. At the moment if I update JOHN SMITH to John Smith in the database, the tabular model doesn't reflect the change even after I do a…
cqi
  • 539
  • 3
  • 13
1
vote
1 answer

Find the Average of the Sums grouped by dimensions not included in Filter Context

The following is a simplified example of a real-world problem I'm facing: Let's say I have a Sales fact table with the Measure Count, with the dimensions Vendors, Customers, and Parts. I want to get the Min, Max, and Avg for the Sum of Sales Count…
Daniel Gimenez
  • 18,530
  • 3
  • 50
  • 70
1
vote
2 answers

Calculate measure using [field1] - [field2] > x as filter

I have a fact table containing columns OriginalPrice and PaidPrice for customer transactions. I would like to know how many transactions befenit from a discount OriginalPrice - PaidPrice between 10 and 20 dollars. I already have a measure #Customer…
Dranes
  • 156
  • 10
1 2 3
…
99
100