Ragged Hierarchies

Analysis Services Programming

Analysis Services Programming

Ragged Hierarchies

A ragged hierarchy is one in which one or more levels are skipped in the members of the hierarchical structure. For example, a Geography dimension might have the following structure.

For countries that have states or provinces, such as Canada or Mexico, this dimension works well. Consider the case of Washington, D.C.: The parent of this member of the City level is USA, which is not a member of the State level. However, other siblings of Washington D.C., such as Los Angeles and New York, have parents that are members of the State level. This is an example of a ragged hierarchy.

See Also

Ragged Hierarchies