Parent-Child Hierarchies

Parent-child hierarchies in MS OLAP and SAP BW hierarchies are reflected in the hierarchy tree in Pyramid. They are designated by a pyramid icon, as opposed to the flat 6-pack icon.

Expand the hierarchy to expose its members; the parent appears at the top, designated by a single ellipse. The child levels appear beneath the parent, with each level displaying the number of ellipses that corresponds to its level in the hierarchy (the third level displays three ellipses, the fourth level displays four, and so on).

You can add any level of the hierarchy to the query, or right click on any level to view its elements.


From the Elements panel, you can navigate each level of the hierarchy:


Right click on any of the upper levels to select the required level or descendants and add them to the query.

Hierarchical Functions

Right click on a level or element to access hierarchical formula or list functions. This allows you to create a logical formulation based on a given hierarchy level, and add the formulation to the query.


Create a context calculation that calculates, for the given element or level, the percentage of the total value, or the percentage of its parent's value, for which it accounts.


Create a quick list comprised of member elements belonging to the selected hierarchy relationship type for the given hierarchy level. For example, create a list of ascendents for the member element "French Herb".

In the Query

When parent-child hierarchies are added to the query, the expand and collapse functions are exposed, enabling you to expand specified levels of the hierarchy in the visualization. The Elements panel will reflect the expanded selections in the visual: