IgnoreUnrelatedDimensions and Calculated Measures

I am always surprised to discover how many people have been building cubes in SSAS for a while but are unaware of the IgnoreUnrelatedDimensions property. (If you're one of them, watch the SSAS 110 video.) However, someone recently asked me how setting IgnoreUnrelatedDimensions would affect a calculated measure that used measures from more than one measure group. I decided to find out.

First, I created a simple calculated measure that adds two measures from different measure groups. In Adventure Works, I created MyTotalSales like this:

Read more...