Checking the Data in a HPA Index (SAP Library

Checking the Data in a HPA Index

Use

You can run different checks to test for inconsistencies between the data in the InfoCube on the database and the data in the HPA index. These checks differ in terms of their accuracy and runtimes.

Integration

You can also execute and schedule all checks on the Analysis and Repair of BW Objects screen (transaction RSRV).

Prerequisites

The HPA index you want to check has been activated and filled with data.

Features

In HPA index maintenance, choose Check Data to display the Check Mode Selection for HPA Indexdialog box. The following check and execution modes are available:

Check Modes

Check Mode	Description
Table Index Relation	An index is created for almost every table of the BI InfoCube enhanced star schema: Fact (F) tables, dimension (D) tables, SID (S) and attribute tables (X and Y); the only exception is SID tables with numeric characteristic values. This checks whether the indexes that are named have been created on the HPA server. Runtime: very fast
Check Key Figure Totals Internally	First the system executes a query on the HPA index, which is aggregated using all key figures. Next, all the characteristics and navigation attributes that exist in the InfoCube are included in the drilldown individually and the totals are calculated. The system compares the result with the result of the first query. This checks the completeness of the JOIN path from the SID table, through the dimension table, to the fact table. Runtime depends on the number of characteristics and navigation attributes and on the number of records in the fact table.
Check Key Fig. Total Table Index	As with the Check Key Figure Totals Internally mode, the system executes highly-aggregated queries and compares the results of the InfoCube on the database with those of the HPA index. The runtime for large InfoCubes may already be considerable because queries to the database take longer.
Check Table Index Statistics	The system creates statistics for the individual columns of each table and compares the information for the InfoCube on the database with the HPA index. The runtime primarily depends on the quantity of data on the database.
Check Table Index Content (not always possible)	The system compares the content of each individual table with the content or the corresponding index on a record-by-record basis. This check is only possible for tables/indexes that do contain a large volume of data. This includes dimension tables and some SID, X and Y tables. Fact tables are not normally included. As a rule, the system does not check tables that have more than 10,000 records.

Execution Modes

Execution Mode	Description
Execute	The check you have chosen is executed in the dialog. The system displays the results of the check on the right-hand side of the screen.
Schedule	The dialog box for determining start date values appears. Specify time(s) for the execution. You can view the results of the check in the logs in the application log.

Evaluating Logs

...

1. In the Selection of Check Mode for HPA Index dialog box, choose the Display Logs option. The Evaluate Application Log screen appears for object RSDDTREX, subobject TAGGRCHECK.

2. Enter the required data to restrict the number of logs.

3. Choose This graphic is explained in the accompanying text Execute. The system displays the corresponding results of the check.

Activities

You determine the check mode and the execute mode. You can view the results of the check in the logs in the application log.

...