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.