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
6
votes
1 answer

Making XMLA/DAX requests to ISS/SSAS

I have a tabular database in SSAS 2019, where the data source is SQL Server 2019. I need to retrieve data through XMLA, so I followed these instructions to connect IIS to SSAS. When I send a SOAP request to SSAS through ISS with a POST method (HTTP…
ps0604
  • 1,227
  • 23
  • 133
  • 330
6
votes
1 answer

Missing analysis service when creating new project

I have installed SSAS and created a project. After two months working with seas, now when creating a new project, the analysis service is not available. but I can open old SSAS projects. How I can create another new SSAS project.
Zahra
  • 317
  • 4
  • 16
6
votes
1 answer

MDX Get Min Max Date From Slicer Element

I am using PowerBI Desktop/Service as a Front-End and Analysis Services Multidimensional as Back-End. I want to create a complex calculated member but I have a problem in some part of the member. For example, I need to have the MIN/MAX DATE of the…
Stavros Koureas
  • 1,126
  • 12
  • 34
6
votes
1 answer

Efficient way to process a multidimensional cube

I am building a multidimensional cube using SSAS, I created the partitions based on a date column, and defined a partition for each day. Source data size is bigger than 2 TB. While deploying and processing the the cube, if an error occurred all…
Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
6
votes
1 answer

Linked dimension performance issue

I am working with 2 star schema data warehouses, each data warehouse contains a fact table and the dimensions tables are located in separate databases (one database used by both data warehouses). I created a multidimensional analysis project for…
Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
6
votes
2 answers

ADOMD nuget package for asp.net core

I am looking at ADOMD nuget package. It seems it does not support ASP.NET Core framework. How can I Get this nuget package for ASP.NET core. If not this package, do we have any other alternative to connect to cube ?
OpenStack
  • 5,048
  • 9
  • 34
  • 69
6
votes
0 answers

MDX and SSAS - Subtotal on Filtering in Power BI

I have a sales cube deployed in SSAS that need to be displayed using Power BI. Assume that I have arrange a layout – simulated with Excel - like the following, a dimension (Product - with 5 members) and two Measures (Measures 1 and Measures 2).…
Dino
  • 781
  • 3
  • 14
  • 32
6
votes
2 answers

MDX Doesn't show last version of data

i need a little help to figure out a problem i have in MDX. I want to show the last version per period of a measure even if the value is NULL. But my code show me the last non empty version. Example : Here is my code : (the visible measure in the…
Reda Maachi
  • 853
  • 6
  • 15
6
votes
2 answers

SSAS MDX query as Azure Data Factory source in Linked Service

This question might not be well researched but I need to find out proper way to implement this solution before starting design. Question is, Can we consume SSAS MDX query as datasource in Azure Data Factory Linked Service source?
arpan desai
  • 889
  • 2
  • 13
  • 23
6
votes
5 answers

Why is datekey in fact tables always INT?

I'm looking at the datekey column from the fact tables in AdventureWorksDW and they're all of type int. Is there a reason for this and not of type date? I understand that creating a clustered index composed of an INT would optimize query speed. But…
fdkgfosfskjdlsjdlkfsf
  • 3,165
  • 2
  • 43
  • 110
6
votes
1 answer

ssas partition error when build project - The item already exists in the collection

I have created a new cube using SSAS 2013. When trying to build\rebuild the project, I'm getting this error - 'xxx.partitions' cannot be loaded: The item already exists in the collection. Does anyone knows what that's mean? Deploy and process the…
Dror T
  • 221
  • 2
  • 9
6
votes
1 answer

Reading SQL Analysis Services Metadata

I have a number of objects in my SSAS cube, many of which were created to be invisible. For example: CREATE MEMBER CURRENTCUBE.[Measures].[Latency Backcolor] AS CASE WHEN [Average Latency] > [Web Alert] THEN 6384849 WHEN [Average Latency] > [Web…
BillP3rd
  • 1,009
  • 1
  • 9
  • 21
6
votes
3 answers

Msmdpump.dll OLAP data pump is throwing a 500 error

How do I resolve this issue with requests to msmdpump.dll for connections to SQL Server Analysis Services? I am receiving a 500 Error from the IsapiModule. On a Windows Server 2012 R2 machine, with IIS 8.5, I have setup the OLAP data pump…
Seibar
  • 68,705
  • 38
  • 88
  • 99
6
votes
1 answer

Sort by key in Excel connected to SSAS OLAP cube

I searched the Internet and StackOverflow and was not able to find an answer to this issue. I created an OLAP cube via SSAS with a date dimension. One of the attributes of the dimension is Activity Calendar Month. The NameColumn value is…
Shayne Ephraim
  • 541
  • 4
  • 13
6
votes
1 answer

How to design a shrunken dimension table for dates in dimensional warehouse and use in SSAS?

I'm working in a situation where we're moving from having a bunch of transactional fact tables to a more complicated picture with aggregates, snapshots, etc. In the past, there were a few cases where data needed to be aggregated by month, but…
Jo Douglass
  • 2,055
  • 1
  • 19
  • 30
1 2 3
…
99 100