Show TOC

Analyzing and Repairing BWA IndexesLocate this document in the navigation structure

Use

The Analysis and Repair of BW Objects screen (transaction RSRV) allows you to carry out various checks for:

  • Testing for inconsistencies between the data in the InfoCube on the database and the data in the BW accelerator index (tests in the BW Accelerator Consistency Checks area)

  • Testing whether a SAP BW Accelerator index is running with optimized performance (tests under BW Accelerator Performance Checks)

  • Completely or partially building or rebuilding all BW accelerator indexes or a specific BW accelerator index (tests under BW Accelerator Repair Programs)

The exactness and duration of each of these checks vary.

Note

You can find out more about building and using the analysis and repair environment under Analysis and Repair Environment. You can find out more about the tests for BWA indexes under Tests for BWA Indexes in Transaction RSRV.

Prerequisites

The SAP BW Accelerator index you want to check has been activated and filled with data.

Some tests work with statistical data (see Propose Delta Index for Indexes, Compare Size of Fact Tables with Fact Index).

The statistics must have been activated for the relevant InfoProviders. You make this setting on the statistics properties maintenance screen (choose Start of the navigation path Tools Next navigation step Settings for BW Statistics End of the navigation path on the Data Warehousing Workbench screen). More information: Statistics for Maintenance Processes in SAP BW Accelerator Indexes.

Procedure

Run Tests

  1. You are on the Analysis and Repair of BW Objects screen (transaction RSRV).

    1. If you want to run an elementary test, navigate to Start of the navigation path Tests in Transaction RSRV Next navigation step All Elementary Tests Next navigation step BW Accelerator End of the navigation path.

    2. If you want to run a combined test, navigate to Start of the navigation path Tests in Transaction RSRV Next navigation step All Combined Tests Next navigation step BW Accelerator End of the navigation path.

      You can select the following tests here:

      Consistency check (detailed)

      Consistency check (quick)

      Performance tests

  2. For some tests, you need to enter parameters. Define the required parameters if necessary.

  3. Choose Execute. The log display appears.

  4. Choose Correct Error. The system performs repair tasks in repair mode. (Repair tasks are not available for all tests).

Run Tests Regularly

In SAP BW Accelerator Monitor (transaction RSDDBIAMON2) you can specify that the system runs a small number of tests on a daily basis. To do this, choose Start of the navigation path BW Accelerator Next navigation step Execute/Display Index Checks End of the navigation path. More information: Monitoring BWA Indexes.