From the SAP NetWeaver BW Accelerator Monitor (transaction code RSDDBIAMON2 ), choose to display the BW Accelerator Data Consistency Check Center screen. On this screen, you can check the data on the BW Accelerator server, schedule these checks, and view logs for checks that have already run. You can group certain checks to form check sets.
Creating a New Check Set
Give the check set a description .
Specify the InfoCubes of the BWA index for which the check set is to be executed. Input help is available. Multiple selections are possible.
Specify the maximum degree of parallelization if necessary. The degree of parallelization is only applicable for background processing. The system starts one process (dialog) for each InfoCube; a maximum of n processes are executed simultaneously (n = parameter value).
If necessary, set the If errors occur deactivate BWA index for queries flag. When you set this indicator, the BWA index is set to 'inactive' (cannot be used for queries) as soon as the check set displays incorrect data in the BWA index. This prevents incorrect data from being used for reporting in the BWA. Note, however, that a check can display incorrect data even though the data is correct, for example, because a load process (master data or transaction data) has changed the data at the same time.
If you want an e-mail to be sent when incorrect data is displayed, enter the address of the recipient in the relevant field.
If the check set is to be executed after the rollup of new requests to the relevant InfoCubes, set the relevant flag. The check set is then still part of the process (this is relevant for integration into a process chain), but the lock on the process is no longer valid, so that other processes are not interrupted. The check set is not executed for all InfoCubes, but only for the InfoCubes that the data was rolled up for.
If the check set is to be executed after the change run , set the relevant flag. As before, the check set is still part of the process, but the lock on the process is no longer valid. The check set is only executed for the InfoCubes whose BWA index was adjusted in the change run.
Each tab page contains a test. You can find the description of the test under Details of Check . Select the checks relevant for your check set by setting the corresponding indicator for Execute Test . Select the check-specific options.
Tab Page |
Test Description |
---|---|
Data Compar. |
For more information, see Tests for BWA Indexes in Transaction RSRV : |
Totals in BWA |
For more information, see Tests for BWA Indexes in the Transaction RSRV : |
BWA and DB Totals |
For more information, see Tests for BWA Indexes in the Transaction RSRV : |
Random Queries |
Specify the number of random queries and the start time for the random number generator. The system creates random queries without persisting them. These random queries are only used for this test: The system reads the data once from the database and once from the BW accelerator. It then compares the results. If the results differ, the system displays an error message. Note
You can verify the results by executing program RSDRT_INFOPROV_RANDOM_QUERIES with the following parameters:
You can leave all other values unchanged. The program can also be executed in the background and the results viewed in the spool list. If you use the same starting value, the same random queries are generated. |
Index Existence |
For more information, see Tests for BWA Indexes in the Transaction RSRV : |
Save the check set. The system assigns and displays a check set ID.
Displaying and Changing an Existing Check Set
To display an existing check set, place the cursor in the Check Set ID field and select the required check set from the input help.
Change the parameter values of the selected check set and save it again. The system does not assign a new check set ID.
Executing a Check Set
Select an existing check set or define a new one.
When you choose Execute , the checks for the check set are executed in the dialog (and not in parallel). The check set does not have to be saved beforehand. When the check is complete, the system automatically displays the results in the application log.
Choose to open the Start Time dialog box.Here you can schedule the check set to run once or periodically in the background. The check set must be saved beforehand. The name of the scheduled job is BW_TR_RSDDTREX_INDEX_CHECK.
You can also execute a check set by using program RSDDTREX_INDEX_CHECK. To do this, you need the check set ID, or you can select the check set from the input help. You can also use this program to add a check set to process chains. To call the logs, choose Logs .
Deleting a Check Set
Select an existing check set, choose Delete , and answer 'Yes' to the confirmation prompt.