Unbalanced Hierarchies

Unbalanced Hierarchies

An unbalanced hierarchy is one in which the children of a member may or may not have children themselves, depending on the value of that child. PivotTable® Service supports parent-child structures to contain unbalanced hierarchies. Consider the case of an organizational chart in a company. Executive assistants may report directly to the CEO, a director, or a manager. Technicians may report to a lead technician, a manager, or a technical sales person. In these hierarchies, the level of the individual is less important than the individual's relationship to the superior. Relationships of this type are often referred to as parent-child relationships and are often defined in relational databases using self-referential joins.

See Also

Balanced and Unbalanced Hierarchies