OBIEE - Configure Level Number of Elements in Dimensional Hierarchies

Bi Server Architecture With Client


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 defining strategy for picking optimal aggregate physical source for a query. The numbers in the setup will help determine which physical table is most appropriate for a better performance query return (another critical element in that decision being also the dimensional granularity of each table).

This number does not have to be exact. The ratio from one level to the next is more important than the absolute number.

These numbers only affect which aggregate source is used (optimization, not correctness of queries).

These values should be changed to ratio values based on Actual data in the implementation. To prevent problems with aggregate navigation, make sure these numbers illustrate reality, mainly in the way the compare to each other.

Fact sources will be selected on a combination of:

  • the fields selected as well as
  • the levels in the dimensions to which they link.

For example, when aggregate navigation is used, multiple fact sources exist at different grains. The Oracle BI Server multiplies the number of elements at each level for each qualified source as a way to estimate the total number of rows for that source.

Then, the Oracle BI Server compares the result for each source and selects the source with the lowest number of total elements to answer the query. The source with the lowest number of total elements is assumed to be the fastest.

By adjusting these values, you can alter the fact source selected by Oracle Business Intelligence in some cases.

For the Grand Total level, leave this field blank. The system will set to a value of 1 by default.

Steps to populate them automatically

These Level Counts can be automatically populated for one or more dimension hierarchies using Estimate Levels. To populated logical level counts automatically:

  1. In the Administration Tool, open a repository in online mode.
  2. Right-click one or more business models and dimension objects, and choose Estimate Levels.
  3. In the Check Out Objects dialog box, click Yes to check out the objects that appear in the list.

Estimate Level

Documentation / Reference

Discover More
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 - Fact table (of logical fact table)

Dimension tables are expected to store columns that cannot be aggregated whereas fact tables are expected to store measure columns that can be aggregated. As a general rule: don’t include...
Bi Server Architecture
OBIEE - Query Compiler

The query compiler is responsible of the compilation of a logical sql in the query processing process of BI Server. The query compilation is composed of the following five phases: parsing, , navigation,...
Bi Server Architecture With Client
OBIEE - Repository Design

... .. A consideration to take when designing a subject area is to pay attention at the final user. Do you design for a user:OBIEE Analytics/Reporting...
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:...

Share this page:
Follow us:
Task Runner