Show TOC

Procedure documentationAnalyzing and Repairing BWA Indexes Locate this document in the navigation structure

 

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 NetWeaver 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 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.

End of the note.

Prerequisites

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

Some tests work with statistics data (see tests: 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   Tools   Settings for BW Statistics   on the Data Warehousing Workbench screen). More information: Statistics for Maintenance Processes in SAP NetWeaver 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   Tests in Transaction RSRV   All Elementary Tests   BW Accelerator  .

    2. If you want to run a combined test, navigate to   Tests in Transaction RSRV   All Combined Tests   BW Accelerator  .

      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. In repair mode, the system performs certain repair tasks. (Repair tasks are not available for all tests).

Run Tests Regularly

In SAP NetWeaver 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   BW Accelerator   Execute/Display Index Checks  . More information: Monitoring BWA Indexes.