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.