Analysis Services Ignore Unrelated Dimensions property in Dimensions Usage Tab

Hi Friends,

Look at this scenario:

When I try to slice Reseller Sales measure group by Geography dimension, I get the following output:

1_SQL_Server_Analysis_Services_IgnoreUnrelatedDimensions

Rightly so, because the Geography dimension is not related to the Reseller Measure group, it just shows the grand total for all the members. This can be confirmed from the Dimensions Usage tab.

2_SQL_Server_Analysis_Services_IgnoreUnrelatedDimensions

But don’t you think that the output could show null or blank instead of showing incorrect or inaccurate results?

No worries; there is a property called Analysis Services Ignore Urelated Dimensions which is set to TRUE. You need to set that to FALSE. Go to Dimensions Usage tab, click on the measure group, press F4 and change the property value to False.

3_SQL_Server_Analysis_Services_IgnoreUnrelatedDimensions

Process the cube and browse and observe the output now 🙂

4_SQL_Server_Analysis_Services_IgnoreUnrelatedDimensions

 

 

Amit Bansal

About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: http://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

View all posts by Amit Bansal →

Leave a Reply

Your email address will not be published. Required fields are marked *