Designing dimension hierarchies
You should consider the following when designing dimension hierarchies:
How dimensions relate to each other (for example, Age/Geography/ Timespan).
Level of detail for each dimension and cube.
Dimensions are not limited to a single cube; they can be used in many cubes.
Dimensions must roll up cleanly across boundaries, so elements must be mutually exclusive and not overlap.
Copyright IBM Corporation 2015. All Rights Reserved.