Database Reference
In-Depth Information
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
HideMemberIf
property
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 attributes
such as
Age
or measure values into bands or ranges. Analysis Services offers some
functionality to help us do this. But as usual, we'll get much more flexibility if we
design these groups into the dimension ourselves.
Search WWH ::
Custom Search