5,650 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
66
views
Error occured while running DAX in Power BI which is connected to SSAS using live connect mode
I have connected my SSAS with MS Excel and all the dax which i am running is working fine .
Image of DAX result in MS Excel
But when i am connecting the SSAS with Power BI it is not running as ...
0
votes
2
answers
69
views
SSAS Tabular grand total wrong with hierarchy filter
I am using SSAS Tabular 2022 and has model as below:
The total amount is calculated as
Total Amount:= sum(Amount[Amount])
When I view in Excel and filter the model by the Year-Month-Date, the first ...
0
votes
0
answers
20
views
Response of msmdpump.dll has not xml formttedd inside
I have .net 8 program docker base and in that I cant call SSAS , based on microsoft document I run IIs and host msmdpump.dll and from my app call it but problem is in that response , that is not ...
0
votes
1
answer
50
views
DAX calculation
What DAX calculation to calculate the Sales $ Fulfilled where Is Originating Online Sales Store = "Y" and match the Fulfilling Location to Originating Location
Meaning, any sales that were ...
1
vote
1
answer
101
views
What is a more efficient way to take results of a query in a tabular model and use that to query additional models?
I need to filter two separate tabular models and return a table of summarized results from each, using values retrieved from a third semantic model for calculate context. The process creates a data-...
1
vote
1
answer
42
views
SSAS tabular aggregate dimension attributes in the same folder
I have a SSAS tabular cube and the end user ask me to put attributes from 3 different dimensions inside the same folder.
Basically what they want is for a specific group of attributes that are in 3 ...
0
votes
1
answer
72
views
SSAS Cube Transition to Snowflake
I'm trying to find a solution for migrating from an Azure environment to Snowflake. We have several SSAS cubes that need to be replicated in Snowflake, but since Snowflake doesn't natively support ...
0
votes
1
answer
55
views
Mismatch Between SSAS Tabular Model Measures and Data Warehouse Values in Power BI (Direct Query)
I am building a SSAS Tabular model on Visual studio, i created some measures in the Tabular model (like SUM, YTD, etc.) and then deployed the model to SQL Server Analysis Services, and then connected ...
0
votes
0
answers
65
views
Retrieve data from olap cube and store it like a table in a dataframe with python
I am trying to retrieve data from an OLAP cube using an MDX query and store the results in a Pandas DataFrame, all with Python.
I am able to connect to the OLAP cube using requests without any issues ...
0
votes
0
answers
50
views
Masking data in Multidimensional CUBE SSAS
Working with a multidimensional cube SSAS , and I have a requirement to make certain values null based on a user role; ie if the confidential value = 2 , the user sees only a null value. I have ...
0
votes
1
answer
61
views
SSAS Tabular 1600 - Partition Processing Issue - Random Empty partitions durring Full parallel processing
SSAS Tabular 1600 - Partition Processing Issue - Random Empty Partitions During Full Parallel Processing
Details:
We have a fact table with 800 million rows, split into 25 partitions by Month Index (...
0
votes
1
answer
44
views
Filtering data in SSAS based on "AND", not "OR"
In SSAS I have this simple scheme with a list of partners with their tags and the directory of tags. With this scheme, filtering by tags works on the principle "OR" - one of the tags ...
0
votes
1
answer
78
views
Evaluate the memory usage of a View being used to populate an AAS table
I need help evaluating the actual execution plan of an SQL Server View:
https://www.brentozar.com/pastetheplan/?id=zAFOrTkUxr
Context
The above View is being called by Azure Data Factory to populate a ...
0
votes
0
answers
121
views
Get a list of all attributes/hierarchies (both enabled and disabled) of all dimensions of a cube
I need a way to obtain a list of all attributes / hierarchies of all dimensions of a given cube. In the Internet I have found that following SSAS DMV for doing a similar job:
SELECT [CATALOG_NAME] as [...
0
votes
0
answers
39
views
How can I convert Many-to-Many relations in a Multidimensional Database to Tabular Model In SSAS
I'm converting a multidimensional cube to tabular. As it happens, I have several many-to-many relationships between my dimensions and measures group, as you can see in the image below.
I've searched ...