Forum Discussion
Restricting dimensions to used values
Hi, I am using Power BI over an SSAS Tabular model. We have several generic dimensions, like Nationality, which usually come from standardised data sets and have many entries. Any particular fact ...
Here is a solution I found.
To SSAS The tables setup in Visual Studio are actually views of objects dimensions in the data database
so I changed the views to include an addition to the where clause
AND dds_code_sk in (select distinct Nationality_sk from [Data].FACT_FT
ie where the key is actually in use on the Fact.
Now only used values appear in the dimensions of the cube
Its not efficient I am sure but it works!
JC