OBIEE - Logical level

Bi Server Architecture With Client


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.


Obiee 10g Logical Level Key

The level key:

  • defines the unique elements in each logical level
  • and must be present on each level except the topmost level defined as a Grand Total level

Primary Key

The primary Key is a key and must:


Rule: Each logical level Description
Should have a display key Each logical level should have one level key that will be displayed when an Answers or Intelligence Dashboard user clicks to drill down. This may or may not be the primary key of the level.
Must be unique Be careful using level keys such as Month whose domain includes values January, February, and so on—values that are not unique to a particular month, repeating every year. To define Month as a level key, you also need to include an attribute from a higher level into the key, for example, Year.

Dimension table logical key

The dimension logical table key has to be associated with the lowest level of a dimension and has to be the level key for that level.

Obiee 10g Logical Table Logical Key


nQSError: 15031 - The dimension table source has a non-interpretable aggregate content

[nQSError: 15001] Could not load navigation space for subject area Test.
[nQSError: 15031] The dimension table source  has a non-interpretable aggregate content specification, 
possibly caused by missing columns or keys.

Be sure that the level you defined for the logical table source has a key defined.

Documentation / Reference

Discover More
Bi Server Architecture With Client
OBIEE - (Fragment|ation) (Partitioning)

The fragmentation (known also as partitioning) is the most powerful feature of OBIEE. You can fragment (or partition) any logical table (fact table as dimension table) in more than one logical table source...
Obiee Fragmentation Content One Column
OBIEE - Aggregate (Navigation|Table|Content)

The aggregate navigation capability of the Oracle BI Server allows queries to use the information stored in aggregate tables automatically. When users request information at a high “grain” of aggregation,...
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 Fragmentation Content One Column
OBIEE - Fragmentation Content, value-based, horizontal partitioning

This capabilities of OBIEE is also known as : Content Fragmentation Value-Based fragmentation Fact Horizontal Partitioning The term Fragmentation is more an OBIEE term whereas the term partitioning...
Obiee Logical Table Source No Fragmentation Content Warning
OBIEE - Logical Table

A logical table source is a table where all its logical table sources have the same dimension combinations (domain) by logical level. The check box “This source should be combined with other sources...
Obiee11g Lts
OBIEE - Logical Table Source (LTS) (Physical and Logical Column Mappings)

Logical table sources definethe mappings from a single logical table to one or more physical tables. A logical table contains one or more logical table source. The mapping between physical columns and...
Obiee Multiple Dimension Hierarchie
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...

Share this page:
Follow us:
Task Runner