OBIEE 10G/11G - Dimension Hierarchy (logical dimensions)


(Dimension hierarchies|Logical Dimensions|Hierarchy) introduce formal hierarchies into a business model. They are created in the Business Model and Mapping layer.

Before 11g, end users can't see them in the end user tools but with the advent of the presentation hierarchy column, it's now possible to have an overview.

There are two types of logical dimensions:

  • dimensions with level-based hierarchies (structure hierarchies)
  • and dimensions with parent-child hierarchies (value hierarchies) <note important>Only for 11g</note>.

Only for 11g

You can expose logical dimensions to Oracle BI Answers users by creating presentation hierarchy objects that are based on particular logical dimensions. Creating hierarchies in the Presentation layer enables users to create hierarchy-based queries.

You can also transmit the hierarchy metadata from OBIEE to the underline database with the help of the sametaexport utility.

From 11g


Type of hierarchy


Consists of an ordered set of two or more levels. For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level-based hierarchies can also contain parent-child relationships.

Level-based Dimension hierarchy levels allow :

Special type of level-based dimension are supported:

  • Unbalanced (or ragged) and Skip-level hierarchy <note important>only 11g</note>
  • time dimension to provides special functionality for modeling time series data.


value-based hierarchy — Consists of values that define the hierarchy in a parent-child relationship and does not contain named levels. For example, an Employee hierarchy might have no levels, but instead have names of employees who are managed by other employees. Employees can have titles, such as Vice President. Vice Presidents might report to other Vice Presidents and different Vice Presidents can be at different depths in the hierarchy.


In addition

In addition to being level-based or parent-child, hierarchy can be one of the following.


A hierarchy in which all the lowest-level members do not have the same depth. For example, a Time hierarchy might have data for the current month at the day level, the previous month's data at the month level, and the previous 5 years' data at the quarter level. This type of hierarchy is also known as an unbalanced hierarchy.


A hierarchy in which certain members do not have values for certain higher levels. For example, in the United States, the city of Washington in the District of Columbia does not belong to a state. The expectation is that users can still navigate from the country level (United States) to Washington and below without the need for a state.


38073 - Dimension ‘@1%ls‘ has multiple leaf levels which are not identical

This error occur when the Leaf levels in a dimension have to be identical.

But also when you have metadata problem. You get them by using “Create a parent level” from a leaf level. Try to use “Create a child level” from the Grand Total level.

Documentation / Reference

Powered by ComboStrap