Recursive Hierarchies

A recursive hierarchy is a special type of derived hierarchy. In a typical derived hierarchy, the members in an entity are grouped by a domain-based attribute. In a recursive hierarchy, the members are still grouped by a domain-based attribute; however, this domain-based attribute is based on the entity itself. For example, each employee in an organization has a manager. And the manager can be any one of the employees. The following procedures show how to use this employee-manager relationship to create a recursive hierarchy that shows Main Street Clothing Company’s organizational structure.

Procedure: How to Create a Recursive Hierarchy

To create a recursive hierarchy, you are going to use the Finance model, which, if you deployed it from the web site, includes a full list of sample employees. To create a recursive hierarchy, you are going to complete the following tasks: