Dimensional Model


PowerPivot and Parent/Child hierarchies

Does PowerPivot handle Parent/Child hierarchies? The common answer is “no”, since it does not handle them natively. During last PowerPivot course in London, I have been asked the same question once more and had an interesting discussion about this severe


SSAS: Reference materialized dimension might produce incorrect results

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


Dimensional modeling with Ranged Dimensions

A ranged dimension is a dimension that is used to have a discrete view of a continuous measure. A good example of this is the analysis of amount sold per order. In AdventureWorks we have, for each line of an order, the amount and quantity sold. We would