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.