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

Bi Server Architecture With Client


(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) Only for 11g


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:

Obiee Multiple Dimension Hierarchie


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.

Obiee Logical Level Child Levels

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

Discover More
Obiee Aggregate Lts
OBIEE - Aggregate Navigation with level-based fragmentation

OBI Server features have the ability to retrieve queries from an aggregate table defined through level of the hierarchy instead of the fact table. This ability is a part of the aggregate navigation feature....
Obiee Logical Level
OBIEE - Configure Level Number of Elements in Dimensional Hierarchies

[OBIEE Logical Level of a dimension] Each logical level of each dimensional hierarchy contains a setup named “Number of Elements at this Level”. This setup number is used by the Oracle BI Server when...
Obiee User Group Permission Filter
OBIEE - Data security (visibility of data)

This article is data security or authorization in OBIEE. Data-level security controls the visibility of data (content rendered in subject areas, dashboards, Oracle BI Answers, and so on) based on the...
Bi Server Architecture With Client
OBIEE - Dimension (Logical Table)

A dimension logical table is typically joined to a fact logical table that will contain measures. Every logical dimension table should have a dimensional hierarchy associated with it. This rule holds...
Obiee 10g Logical Level Key
OBIEE - Logical level

The Logical level or level are the key level of the hierarchy and defines the grain of each table (logical table) (Fact as Dim) when set in the content tab. The level key: defines the unique...
Logical Business Model
OBIEE - The Business Model and Mapping (BMM)

The Business Model and Mapping layer (known also as Business Model): is the layer in the middle of the logical business model. permit to model logical dimensional models which are a reorganization...
Obiee Dimension Drill Down Report
OBIEE 10G/11G - Drilling (Down and Through)

Drilling is the action to discover the data along an hierarchy (ie through the different levels). In OBIEE, drilling is one way to navigate or interact within the data. OBIEE allows two types of drilling:...
Obiee Logical Column Level Region
OBIEE 10G/11G - Level-Based Measure Calculations

A level-based measure is a column whose values are always calculated to aspecific level of aggregation. The calculation of this measure is independent of the query grain and used always the aggregation...
Obiee Dimension Drill Down Parameters
OBIEE 10G/11G - Level-based Hierarchy

Level-based hierarchy is the first type of hierarchy in OBIEE. Dimension hierarchy levels allow : to perform aggregate navigation, to configure level-based measure calculations, users from Dashboard...
Obiee11g Presentation Hiearchy Roll Up Info Answers
OBIEE 11G - (Presentation Hierarchy|Hierarchical Column)

With presentation hierarchies, roll-up information is displayed in the Oracle BI Answers navigation pane, providing users with important contextual information. Holds data values that are organized...

Share this page:
Follow us:
Task Runner