Performing Checks for Aggregates

Use

You perform aggregate checks to check the correctness of the data records in an aggregate. You can define as many aggregate checks as you require for each InfoCube. You can check the required aggregates in different check modes at any time.

Tip

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

You can view the results of the check in the logs in theapplication 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.

Caution

You cannot transport aggregate checks 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 aggregate check maintenance either from aggregate maintenance (transaction 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.

Selecting Checks

Each check is specified by the InfoCube name and an ID.

Enter the name of the InfoCube.
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, change, execute, execute ad hoc or delete aggregate checks for an InfoCube.

The following functions are available:

Editing Function	Description
Display	The Display of Check Time for the Aggregate screen appears. The system displays the aggregate tree of selected aggregates with their 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.
Edit	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. You can change these properties here. If you save the check, the previous settings are overwritten.
Create	The Check-Time Selection for Individual Aggregate screen appears. The system displays the aggregate tree with all the aggregates in the InfoCube. Select the aggregates that you want to check. Determine the check time by setting the corresponding indicator. 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. Choose Continue. The system checks whether new aggregates have to be created or whether 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. 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. 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 (seeActivating 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. Caution 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 check time Now, the system executes this part of the check in dialog mode and displays the results afterwards in the application log. Note The settings for aggregates with check time Now are not transferred to the definition of the aggregate check.
Delete	If you confirm the confirmation prompt, the check is deleted.
Execute	The check you have chosen is executed in dialog mode. The system displays the results in the application log.
Ad hoc	The Check-Time Selection for Individual Aggregate screen appears. Select the aggregates that you want to check. Choose Now as the check time. 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 Roll Up 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, subobject 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:

Check Time

Check Mode

Technical Information About Aggregate Check