Oracle^® Business Intelligence Server Administration Guide > Oracle BI Administration Tool Basics >

Populating Logical Level Counts Automatically

Estimate Levels allows the Oracle BI Administrator to automatically populate level counts for one or more dimension hierarchies. Level counts are utilized by the query engine to determine the most optimal query plan and optimizes overall system performance.

The repository needs to be opened in online mode and the business model must be available for query. Then, in the Business Model and Mapping layer, the Oracle BI Administrator can select any of the following logical layer elements, and then execute the Estimate Levels command:

• Business model. Must be available for query. If you select this object, the Administration Tool will attempt to check out all objects in the business model.
• Dimension. The Oracle BI Administrator should run a consistency check on dimensions to make sure that the dimension is logically sound.
• A combination of business models and dimensions. The Oracle BI Administrator can select multiple dimensions and multiple business models individually.

When run, the Estimate Levels command also launches a consistency check on the level counts as described in the following list:

• Checks that a level key is valid. Columns in levels have referential integrity.
• Checks the parent-child relationship. If the parent level count is greater that the child level count, an error is returned.
• Generates a run report that lists all the counts that were estimated and any errors or consistency warnings.
• The queries and errors are logged to NQQuery.log on the Oracle BI Server.

  NOTE:  Set the log level at 4 or higher to write this info to the log file. For more information, see the topic about setting the logging level in Administering the Query Log.

To populate 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.

   NOTE:  If you click No, the action terminates because you must check out items to run Estimate Levels.

   In the Oracle BI Administration Tool dialog box, a list of the dimension level counts and any errors or warning messages appear.

When you check in the objects, you can check the global consistency of your repository.