SSAS Articles Design SSAS: Reference materialized dimension might produce incorrect results
SSAS: Reference materialized dimension might produce incorrect results
User Rating: / 0
PoorBest 
Written by Alberto Ferrari   
Friday, 27 February 2009 01:03

Reference dimensions let you create a relationship between a measure group and a dimension using an intermediate dimension to act as a bridge between them. In the Adventure Works demo, for example, they are used to link reseller sales and orders to the geography dimension.

Now, something that is less evident is how this specific kind of relationship is handled by SSAS. Let us look further in the definition of the relationship:

Read more...

 

Quick Poll - Please vote

What is the most important feature for you in the BIDS Helper utility?