Rolling Up Data in Aggregates
Use
When you load new data packages (requests) into the InfoCube, these are not immediately available in reporting for use in an aggregate. To fill the aggregate with the new data from the InfoCube, you first have to load these into the aggregate tables for a set time frame. This process is known as roll up.
Prerequisites
● New data packages (requests) have been loaded into an InfoCube.
● Aggregates for this InfoCube have been activated and filled with data.
Procedure
In InfoCube maintenance, you can specify 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 system copies the InfoCube data into the table at the top of the screen.
To optimize data load performance, you can specify that you want to automatically delete indexes before the load operation and recreate them when the data load is complete. You do this on the Performance tab page. Building indexes in this way accelerates the data load process, although it has a negative impact on system performance when the data is read. Only use this method if no read process takes place during the data load.
If you want to switch on index building during roll up anyway, choose Create Index (Batch) and select the required options: Delete InfoCube Indexes Before Each Data Load and then Refresh or Also Delete and then Refresh Indexes with Each Delta Upload.
Type of Execution |
Procedure |
Including roll up of data package as a process in a process chain
We recommend that you include this in a process chain ● with complex schedules ● where there are difficulties with automations and event collectors ● for all new development |
... 1. Choose the Roll Up tab page.
The system proposes the greatest possible value for Roll Up to Request ID. However, you can overwrite this. 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 BI system. If no suitable process chain is available, you can create a new process chain for the roll up. For more
information, see section Creating Process Chains by Using a Maintenance
Dialog for a Process in
|
Starting data package roll up manually
Use this procedure if the data from several data packages creates a logical unit, and therefore only needs to be released.
Different plants deliver their data at different points in time. The data only needs to be visible in the InfoCube when all plants have loaded their data into the InfoCube. |
... 1. Choose the Roll Up tab page. 2. Choose Selection. The Start Time dialog box appears. 3. Choose the start time. You have the following options: - Immediate start - Date/time - After job - After event - By operation mode 4. Set the appropriate indicator if you want to run the job periodically. 5. Save your entries. |
Creating Process
Chains
The following procedures are also possible but should not be used for new scenarios.
Type of Execution |
Procedure |
... 1. Choose the Roll Up tab page. 2. Choose Postprocessing. The Maintain Events to Run 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 automatic roll up if you are loading requests into the InfoCube and there is no overlap between the processes for loading, roll up, 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 Roll Up Data into the Aggregate indicator. 3. Save your entries. |
Program RSDDK_AGGREGATES_ROLLUP |
You can also run
roll up using program RSDDK_AGGREGATES_ROLLUP (see
You can
schedule this program as a regular background job or use it in an
|
Result
The new data is available in reporting for queries that are started after the roll up.
See also: