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.
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 Data Warehousing Workbench screen). More information: Statistics for Maintenance Processes in SAP BW Accelerator Indexes.on the
You are on the Analysis and Repair of BW Objects screen (transaction RSRV).
If you want to run an elementary test, navigate to.
If you want to run a combined test, navigate to.
You can select the following tests here:
Consistency check (detailed)
Consistency check (quick)
For some tests, you need to enter parameters. Define the required parameters if necessary.
Choose Execute. The log display appears.
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 . More information: Monitoring BWA Indexes.