Chapter 3. Designing More Complex Dimensions
At this point in the cube design process we should now have a simple cube deployed and processed, and our users will be telling us what they like and don't like. Once we've taken their feedback on board, it's time to move on to tackle some of the more complex problems. In this chapter, we'll take a look at some specific issues related to dimension design:
Grouping and Banding
Handling the different types of Slowly Changing Dimension
Junk dimensions
Modeling ragged hierarchies with parent/child hierarchies and the
HideMemberIfproperty
