In the analysis and repair environment, you can perform consistency checks on the data and metadata stored in a BI system. This predominantly tests theforeign key relationships between the individual tables of the enhanced star schema of the BI system.
You can call the analysis and repair environment in the following ways:
Choose Analyze from the initial screen.
Or:
Choose Maintain. You get to the maintenance screen. Choose Edit → Analyze InfoObject.
You get to the Analysis and Repair of BW Objects screen.
If you are using the analysis and repair environment for the first time you will see the message "values have not been found for all setting parameters". This warns that no settings have yet been saved for your user
The screen Analysis and Repair of BI Objects comprises two separate screen areas:
In the left-hand screen area you see a hierarchy with the list of available tests.
You can select elementary or compound tests:
An elementary test is a test that cannot be subdivided into smaller tests and therefore can only be executed as a whole. Elementary tests relate to master data and transaction data, DataStore objects, hierarchies, a database (indexes, parameters, statistics), aggregates, PSA tables, and documents.
A combined test determines which elementary tests are to be performed according to the parameters entered.
You can display a short description of a test by choosing Description from the context menu of a test.
2. The right-hand screen area is empty to begin with. The tests you select are recorded here.
A selection of tests is referred to as a test package.
Compiling and Executing a Test Package
by double-clicking on the required test or folder in the left-hand side of the screen
with drag and drop, by transferring the required test or folder from the test list to the right-hand screen area
Each selected test is displayed in the right-hand side of the screen as a closed folder.
An exception to this is elementary tests without parameters. These do not appear as folders.
By double-clicking a test (a test package)
By expanding the folder for the test
You do not need to provide parameters for tests that do not have them. Take note of the appropriate message after selecting the test.
The Parameter Input dialog box appears. Enter the required parameters. Input help is available in many cases.
After parameters have been entered, a folder with the name Parameter is inserted under the test in question. This contains the values of the parameter. In some circumstances the name of the test is also changed so that you can see, at a glance, the parameter values for which the test is to be performed. This is particularly helpful if you have selected the same test several times and want to provide different parameters for it.
If you have provided parameters for a combined test an additional Elementary Tests folder is inserted along with the Parameter folder. This folder contains the elementary tests from which the combined test is built.
You can delete individual elementary tests from the test package by using drag and drop to move this back to the list of tests. You can reduce the runtime of the test in this way.
To if no errors occurred for the test,
To if warnings only were output,
To if the test produced errors.
To delete all elementary tests from the current test package that did not output errors or warnings, choose Deselect Tests Without Errors. If you want to delete the whole test package currently selected, choose Delete.
Test Output
The output of the test is written to the application log and stored in the database. This means they are available for comparison with subsequent test runs.
Settings can also be made for the system so that the log is automatically displayed after a test run (see under "Settings"). Otherwise, choose the Display function from the Analysis and Repair of BI Objects screen. The Log screen appears.
The left-hand area of the screen contains an overview of the most recently performed test runs. By double-clicking on a folder, the system displays all messages hanging under this node as a flat list in the right-hand screen area.
As long as it is available, you can display further information using the following functions:
Detail Information
Long Text for Message
Technical Information
Repairs
Some tests can repair any errors and inconsistencies that are discovered. However, automatic corrections are not generally possible.
If, for example, entries are missing in the SID table for a characteristic but the lost SIDs are still being used in a dimension table of an InfoCube (and the corresponding dimension key in the fact table), this can only be corrected by loading the transaction data for the InfoCube again.
You must also remember that the execution of repairs depends on you executing the repairs in the right order.
We recommend that you always read the test documentation first and obtain a clear idea of where the errors lie, before you execute repairs.
To perform repairs, return to the Analysis and Repair of BI Objects screen. If you want to start a repair, choose Remove Error. As the dataset may have changed between running the analysis and the repair, the necessary tests are executed again before the actual repair. The test output can be found in the application log.
Additional Functions on the Analysis and Repair of BI Objects Screen
Test Package Menu
When you leave the analysis and repair environment, you lose the test package you see in the display. However, you can save this: Choose Edit → Test Package → Save (see under "Menu Application Log").
You can select further functions under Edit → Test Package:
Jobs menu
If you have scheduled a test package and want to monitor its status, choose Jobs → Job Overview.
Application log menu
This option allows you to display old logs, both from previous test runs and from scheduled test runs. You also have the option to delete test logs here.
Settings menu
You can make user-specific settings and save these settings using Settings → Change Settings.
Setting |
Selection |
---|---|
Display Result After Test Run |
Always / With Errors / Never |
Screen Size |
Adjust the screen areas: Control the size of the right and left-hand areas |
Application Log |
Modify the layout, specify an expiry date and a delete condition |
The settings are read automatically when you start the test environment.
If no values are available for the settings options, the user will be notified with a message.
Executing Test Packages in Process Chains
You insert ABAP program RSRV_JOB_RUNNER to your process chain in process chain maintenance (transaction code RSPC). (To do this, use drag and drop to select the process type "ABAP Program" under "General Services" in the process type view.) To edit process variants, you have to specify the program name and the name of a program variant. Enter RSRV_JOB_RUNNER as the program name and choose a program variant name. Choose Change. On the following screen you can either change or display variants that already exist, or create a new variant. When creating a new variant you have to specify the following:
The log for the RSRV process in the process chain consists of the following parts:
If you have chosen the value 3 for the level of detail, only messages up to level 3 are included in the log of process chain processes. Messages that have been output at a lower level of a test in the test package are not displayed in this log.
Note that (unlike the application log) in the processes log errors are not propagated from levels of detail to lower levels of detail. If, for example, a single error was output on level 4, it would be recorded in the summary that the corresponding test had delivered an error, but this error would not be recorded in the second part of the log.
A complete log is always written, independently of the RSRV processes log in the process chain. You can display this with Application Log → Display Log → From Background Processing.
Note that there is no transport object for test packages. Therefore they cannot be transported. Process chains that execute RSRV test packages therefore have to be reworked manually after a transport to another system. The corresponding test packages have to be created.