Dimension hierarchy design guidelines
You should consider the following things 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.