Balanced Hierarchies

Balanced Hierarchies

A balanced hierarchy is one in which the presence of children for any given member does not depend on its value. Instead, it depends on the level of that member in the hierarchy. For example, a dimension based on time might have the following structure.

This structure applies in most situations. Some natural variations may occur; for example, an application may use a Julian calendar instead of a traditional one. In this case, you could use the Julian hierarchy exclusively or define multiple hierarchies for the dimension containing time information.

See Also

Balanced and Unbalanced Hierarchies