List Hierarchy Type

A list hierarchy is a flat hierarchy i.e. with only one level. In a list hierarchy, all the nodes are displayed unlike the large hierarchy. You can create hierarchy based on business terms like, Customer, Product, Geography, and so on. The information for this hierarchy is generated from the metadata framework, which encapsulates these business terms. This enables the user to generate a report in OBIEE reporting server based on these business terms.

The advantage of defining a list hierarchy is that you need not know technical terminology or have technical knowledge. It also allows the user to specify a range of values. You can also define a summary or group total and perform a sort on the list hierarchy based on the hierarchy member value or attribute value; these two features are available only for the fact-less view.

Ensure that when you save a BI enabled hierarchy, the defined hierarchy structure is formed (in the back-end process) and stored in an xml format (as Hierarchycode.xml) in the application server. However, when you save a BI-enabled List hierarchy, the hierarchy structure is not formed and hence there will be no BIHIER.XML formed. Whenever this hierarchy is queried, the data is fetched from the atomic database.