!--a11y-->
Rolling Up Data in Aggregates 
When you load new data packages (requests) into the InfoCube, these are not immediately available in reporting for use in an aggregate. In order to supply the aggregate with the new InfoCube data, you first have to load these into the aggregate tables for a set time frame. This process is known as a Rollup.
· New data packages (requests) have been loaded into an InfoCube.
· Aggregates for this InfoCube have been activated and filled with data.
In InfoCube maintenance, you can set how the data packages are rolled up in the aggregate. You can do this on an InfoCube-by-InfoCube basis.
You are in the Data Warehousing Workbench in the Modeling functional area. In the context menu of the required InfoCube, choose Manage. The Manage Data Targets screen appears. The system copies the InfoCube data into the list in the top area of the screen.
Type of Execution |
Procedure |
Including rollup of data package as a process in a process chain
We recommend that you include this in a process chain · for complex flows · where there are difficulties with automations and event collectors · for all new developments |
... 1. In the Manage Data Targets screen select the Rollup tab page.
The system recommends the greatest possible value for Rollup to Request ID. You can overwrite this if necessary. 2. Choose Process Chain Maintenance.
Transaction RSPC takes you to the Process Chain Selection dialog box. Here you obtain an overview of the process chains that exist in the BW system. If no suitable process chain is available, you can create a new process chain for the rollup. For more
information, see |
Starting data package rollup manually
Use this procedure especially when the data from several data packages create a logical unit, and they therefore only need to be released.
Different plants deliver their data at different times. The data should only be visible in the InfoCube when all the plants have loaded their data into the InfoCube. |
... 1. In the Manage Data Targets screen select the Rollup tab page. 2. Choose Selection. The Start Time dialog box appears. 3. Select the start date. You have the following options: - Immediate start - Date/time - After job - After event - In operation mode 4. Set the appropriate indicator if you want to run the job periodically. 5. Save your entries. |
The following procedures are also possible, but should not be used for new scenarios.
Execution Mode |
Procedure |
... 1. In the Manage Data Targets screen select the Rollup tab page. 2. Choose Postprocessing. The Maintain Events Performed after Processing dialog box appears. For more
information, see |
|
Roll up each data package in the aggregate automatically
The InfoCube has to be technically correct and the quality has to be assured.
Only use the automatic rollup if you are loading requests into the InfoCube and there is no overlap between the processes for loading, rollup, and the other automatisms for the InfoCube. For more
information, see |
... 1. On the Manage Data Targets screen choose Environment -> Automatic Request Processing. The Automatism Maintenance dialog box appears. 2. Under the group header Automatic Processing, set the Rollup Data into the Aggregate indicator. 3. Save your entries. |
Program RSDDK_AGGREGATES_ROLLUP |
You can also run
rollup using program RSDDK_AGGREGATES_ROLLUP (see
You can
schedule this program as a regular background job or use it in an |
The new data is available in reporting for queries that are started after the rollup.
See also: