In Pyramid, there are several different types of hierarchy, depending on the datasource and/ or the way in which the hierarchies were constructed in Pyramid. Each hierarchy type is associate with specific features and functions.
Attribute hierarchies are "flat" hierarchies existing in the original data source, and containing member elements; each attribute hierarchy corresponds to a single column imported from the data source. The member elements contained within the attribute hierarchy correspond to the objects within the column imported from the datasource.
Regular hierarchies contain multiple attribute hierarchies, organized into levels, thereby enabling drill functionality. They also display expand and collapse buttons in grid visualizations, and display the drill path in the Elements panel.
Drill Path Hierarchies
While drill path hierarchies are structurally the same as regular hierarchies, unlike regular hierarchies, they do not display expand and collapse icons in grid visualizations. Instead, the expand and collapse functions are accessed via the context menu, and the expanded levels are displays in a new column.
Drill path hierarchies also reflect the current hierarchy level in the drop zones and Elements panel, rather than displaying the drill path.
Geospatial Hierarchies are hierarchies containing geographical locations (like latitude, longitude, countries, states, cities, or zip codes) that have been assigned to a geospatial type. Geospatial hierarchies can be used to create map visualizations, in order to display your data set across a geographic location.
Date-Time Hierarchies are hierarchies containing date-time member elements and have been assigned as a date-time type. They can be added to the query, or used to create classic date-time groupings (like year, month, week, etc), or to construct complex date-time calculations that can be saved and added to the query. They can also be used to create calendar slicers, where you can filter the query by date-time groupings or formulations that don't exist in the date model.
In MS OLAP, Tabular, and SAP models, the hierarchical structures configured in the cube are reflected in Pyramid. Parent-Child Hierarchies in MS OLAP and BW datasources are reflected in Pyramid; these hierarchies can be easily navigated, and can be used to create custom lists and formulas.