Dimensional Hierarchies in SSAS 2008 and Granularity

I was working on a dimension hierarchy lately and hit at this interesting setupĀ  which I thought of sharing with you guys. It was all about creating a proper conformed dimensional hierarchy and setting up granularity for facts at different grains. It seemed quite simple though, but I felt its THE hurdle one has to certainly pass through during cube design. Continue reading