ssascube
Excess values of dimension are displayed in a browser
I have a cube with the next structure:
The problem is: When I'm browsing the cube using any attribute from the DimRetailStore dimension the browser displays values which don't belong to the FactStore measure. Excess values of the dimension disappear when I'm adding a metric from the FactStore. If I delete the FactRegion measure all data are displayed properly.
Is it possible to display only that data belong to the FactStore Measure?
Solution
The solution: it was enough to move FactRegion under FactStore in the measures list.
- SSAS Tabular Model - Partition Refresh and Schedule
- OLEDE Error: Login failed for user 'DOMAIN\ComputerName$'.;28000
- Why are multidimensional models not supported in Azure Analysis Services?
- DAX script for measure based on date dimention
- Exclude attribute value by default in SQL Server Analysis Services Tabular Model
- Can't add members to SSAS role through Visual Studio
- Power BI calculate Measure for previous working day
- User doesn't have permission to call the Discover method
- SSIS Cube process fail
- Cannot find SQL Server Analysis Services in SQL Server 2012 Management Studio
- "string was not recognized as a valid datetime" when building schema with wizard
- Measure DAX formula with SWITCH
- Is it possible to use the value from a table column as the text of a DAX formula for measure?
- MS SSAS MDX Ensure UI (E.g. Excel) shows the latest member of a dimension on refresh
- Visual Studio tabular cube: an M partition uses a data function which results in access to a data source different from those defined in the model
- C# amo get roles complete
- MDX function to find if a Member IsMemberOf a set
- Power BI - Find the % matching What-if analysis before and after
- Connect an on-prem SQL Server Analysis Server Tabular Model with Azure Data Factory
- My SQL Server Analysis services won't switch from tabular to multidimensional
- Aggregating Members calculated with IIF / CurrentMember conditions
- How to calculate a YTD based on the Month short
- MDX for concatenated dimension level based on result of another calculated member in cube design
- Refresh SSAS post ETL Process job
- Write MDX / DAX on azure analysis services and copy data to azure data warehous using ADF
- How to create Analysis Services Multidimensional Project template in Visual Studio 2019?
- SSAS/Power BI Row Level Security
- PowerShell script to refresh tabular cube on Azure
- DAX FILTER function with multiple criteria
- How to take MDX Query from SSAS Multidimensional Cube and Use To Build Power BI Report?