Performing Checks for Aggregates 
Use
You can perform aggregate checks to check the correctness of the data records in an aggregate. You can define as many aggregate checks as necessary for each InfoCube. You can check the required aggregates in different check modes at any time.
For example, you can use check aggregates or strict characteristic restrictions to run quick aggregate checks on a daily basis after roll up and, in addition, schedule a complete check of critical aggregates at the weekend. Or you can run checks on a weekly basis after weekly attribute/hierarchy change runs.
You can view the results of the check in the logs in the application log. If the system finds incorrect records, it saves these incorrect records in a new database table (/BI0/01xxxxxx). You can see the name and size of the table in the log messages.
Aggregate checks cannot be transported because the number, type and size of the aggregates in the test and productive systems are normally different. For this reason, you need to create individual aggregate checks in each relevant system. You can create analogous checks with identical check IDs in the different systems.
Procedure
You access the aggregate check maintenance either from aggregate maintenance (TA TSDDV) in the Maintaining Aggregates screen (choose Extras ® Automatic Check (On/Off/Change)), or from transaction RSDDAGGRCHECK. The Maintain Aggregate Check: Select InfoCube screen appears.
Select Check
Each check is specified by the InfoCube name and an ID.
...
1. Enter the name of the InfoCube.
2. Enter a valid check ID:
If you want to display, exit, execute or delete a check that already exists, enter the corresponding check ID. Input help is available for both the InfoCube name and the check ID.
If you want to create a new check, provide an (unused) check ID. If you leave the field empty, the system automatically generates a new check ID.
Editing Checks
You can create and change, execute, execute ad-hoc or delete aggregate checks for an InfoCube.
You have the following editing options:
Editing Function |
Description |
|
The Display of Check Time for the Aggregate screen appears. The system displays the aggregate tree of selected aggregates with the check modes and check times. If characteristic restrictions have been defined for the check for one or more aggregates, these are displayed subsequently in a dialog box. Choose confirm to close the display. |
|
The Check-Time Selection for Individual Aggregate screen appears. The system displays the description of the check with the check mode settings, check time, and characteristic relationships and you can change them. If you save the check, the previous settings are overwritten. |
|
The Check-Time Selection for Individual Aggregate screen appears. The system displays the aggregate tree with all the aggregates in the InfoCube. ... 1. Select the aggregates that you want to check. 2. Determine the check time by setting the corresponding indicator. 3. In the context menu of the aggregates to be checked, choose the check mode. The system displays the selected check mode in the corresponding column. If you choose the Selection Options check mode, the Characteristic Restrictions When Checking Aggregates screen appears. Enter the restrictions and choose Continue. 4. Choose Continue. The system checks whether new aggregates have to be created or check aggregates exist that are no longer needed because the aggregates have been deleted. The Confirmation of Aggregate Check screen appears. The corresponding information is displayed in the Check Overview area. 5. Enter the following general check parameters: Description/texts (short description, long description) for the check Block size for check: This value is not the block size that is observed when building aggregates, but the mechanism behaves in the same way: It ensures that the system can also check large aggregates, without this causing problems regarding temporary table space. 6. Save the check. If check aggregates need to be created for this check, the corresponding aggregates and tables are created and activated first. The dialog box for filling check aggregates appears (see Activating and Filling Aggregates). Schedule a job for filling the aggregate. If you have Schedule as the check time in the check aggregate, the dialog box for scheduling in background processing appears. Here you can enter the time(s) or choose Cancel if you have only created the check for ad-hoc purposes.
Note that the system does not check an aggregate unless all the check aggregates that this check requires are filled when the check starts. If you have selected aggregates with the check time Now, the system executes this part of the check in the dialog and displays the results afterwards in the application log.
The settings for aggregates with the check time Now are not transferred to the definition of the aggregate check. |
|
If you confirm the confirmation prompt, the check is deleted. |
|
The check you have chosen is executed in the dialog. The system displays the results in the application log. |
|
The Check-Time Selection for Individual Aggregate screen appears. ... 1. Select the aggregates that you want to check. 2. You have to choose Now as the check time. 3. In the context menu of the aggregates to be checked, choose the check mode. You can only select the Check Aggregate check mode if a corresponding check aggregate already exists. Choose confirm again and the system executes the check you have selected in the dialog. |
Evaluating Logs
If the check is executed After Change Run, After Rollup or After Deletion, you can find the logs for the aggregate check with the logs for the main process.
If you execute an ad-hoc check or execute a check using Now, the system displays the application log automatically at the end of the check.
If the check is scheduled for background processing and is executed in the background, the logs are available in the application log under object RSRV, sub-object AGGRCHECK. The InfoCube name and Check ID are recorded in the identifier.
You can also display these logs by choosing Logs on the Maintain Aggregate Check: Select InfoCube screen.
For more information see
Technical Information on Aggregate Check