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 dimensions
- Junk dimensions
- Modeling ragged hierarchies with parent/child hierarchies and the
HideMemberIfproperty
Grouping and banding
Often, we'll need to create groups of some kind on a dimension either to group long lists of members up into more user-friendly groups, or to group numeric ...
Get Expert Cube Development with SSAS Multidimensional Models now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
