Show TOC

Checking the Consistency of BWA Indexes (Check Center)Locate this document in the navigation structure

Use

From the SAP NetWeaver BW Accelerator Monitor (transaction RSDDBIAMON2), choose Start of the navigation path Goto Next navigation step Consistency Checks End of the navigation path 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.

Procedure

Creating a New Check Set

  1. Give the check set a description.

  2. Specify the InfoCubes of the BWA index for which the check set is to be executed. You can use input help for this. Multiple selections are possible.

  3. 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).

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

  5. If you want an e-mail to be sent when incorrect data is displayed, enter the address of the recipient in the relevant field.

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

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

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

    Test Description

    Data Compar.

    For more information, see Tests for BWA Indexes in Transaction RSRV: Start of the navigation path BW Accelerator Consistency Checks Next navigation step Compare Data in BW Tables and BWA Indexes (Check Table Index Content) End of the navigation path

    Totals in BWA

    For more information, see Tests for BWA Indexes in Transaction RSRV: Start of the navigation path BW Accelerator Consistency Checks Next navigation step Check Totals of Key Figures of BWA Queries (Check Key Figure Totals Internally) End of the navigation path

    BWA and DB Totals

    For more information, see Tests for BWA Indexes in Transaction RSRV: Start of the navigation path BW Accelerator Consistency Checks Next navigation step  Check Totals of Key Figures of BWA Queries with Database (Check Table Index of Key Figure Totals) End of the navigation path

    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 and 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:

    • InfoProvider: Name of the InfoCube

    • Number of queries: 10 10

    • Starting value of random generator

    • Trace comparison: X

    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 Transaction RSRV: Start of the navigation path BW Accelerator Consistency Checks Next navigation step Check Existence of Indexes for Database Tables (Table-Index Relation) End of the navigation path

  9. 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 Schedule 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 running program RSDDTREX_INDEX_CHECK ausführen. 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.