In Pyramid reports, hierarchies are used for drill functionality and expand and collapse functionality, which is used to display multiple hierarchy levels simultaneously.
Hierarchies are constructed from the Hierarchy panel, by adding the required columns from a table. The panel displays visible table in the model; each table can be expanded to view its columns.
A hierarchy is built by adding several columns from a single table, in the logical hierarchical order.
- Click here to learn more about the mechanics of the hierarchy panel, and how to build hierarchies.
- Click here to learn more about setting hierarchy metadata.
Pyramid enables the creation of 2 kinds of hierarchies: Regular, and Drill Path. Each hierarchy type enables drill and expand and collapse functionality, with a few subtle differences.
Pyramid also enables ragged hierarchies, where cousin members of a level belong to parents residing in different levels. For instance, a geo-location hierarchy containing a level called "City" may contain members whose parent level is "State" and others whose parent level is "Country".