Displaying members without children (leaves)

Parent-child hierarchies, also known as unbalanced or recursive hierarchies, are hierarchies with a variable number of levels. Unlike regular user hierarchies, the depth in a parent-child hierarchy is not determined in advance. It is a direct consequence of recursive relation inside the dimension table. Members, regardless of the level they are at, are not required to have descendants. The Adventure Works database has several such dimensions: the Employee dimension, the Account dimension, and the Organization dimension.

Ragged hierarchies are another type of unbalanced hierarchies. Their depth is fixed, known in advance, but the logical parent member of at least one member is not in the level immediately above the member. In other words, one or more levels are skipped in the members of the hierarchical structure. You can configure hierarchies to hide the logically missing members.

Unbalanced hierarchies can present very interesting challenges in...