Rolling Up Data into an Aggregate

 Rolling Up Data into an Aggregate 

Use

If new data packages (requests) are loaded into the InfoCube, they are not immediately available for Reporting via an aggregate. To provide the aggregate with the new data from the InfoCube, you must first load the data into the aggregate tables at a time which you can set. This process is known as a Rollup.

Prerequisites

·        New data packages (requests) were loaded into an InfoCube.

·        Aggregates for this InfoCube were already activated and filled with data.

Procedure

In the InfoCube maintenance you can set how the data packages should be rolled up into the aggregate for each InfoCube.

You are in the Modeling function area of the Administrator Workbench. In the context menu of the required InfoCube select Manage. The Manage Data Targets dialog box appears. The system copies the data from the InfoCube to the list in the upper area of the screen.

Type of Execution	Procedure
Include roll-up of the data packages as a process in a process chain We recommend use in a process chain ·         for complex flows ·         for difficulties with automations and event collectors ·         for all new developments	...        1.      In the Manage Data Targets screen select tabpage Rollup. 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 with an overview of the process chains in the BW system. If there is no suitable process chain, you can create a new process chain with the process of rolling up. You can find additional information under  Creating a Process Chain in the Creating a Process Chain Using the Maintenance Dialog for a Process section.
Start data package roll-up manually   Use this procedure if the data of multiple data packages form one logical unit and should therefore only be released together. 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 tabpage Rollup.        2.      Choose Selection. You get to the Start Time dialog box.        3.      Select the start date. You have the following options: Immediate start Date/time After job After event At operation mode        4.      Set the appropriate flag if you want to run the job periodically.        5.      Save your entries.

In addition, the following processes are also possible, though they should no longer be used for new scenarios.

Type of Execution	Procedure
Subsequent Processing	...        1.      In the Manage Data Targets screen select tabpage Roll-Up.        2.      Select Subsequent processing. The Maintain Events Performed after Processing dialog box appears. You can find additional information under Process Control and Creating an Event Collector.
Roll up each data package to the aggregate automatically   The InfoCube must be technically correct and you must be sure of its quality. Only use automatic roll-up if you load requests into the InfoCube in such a way that there is no time overlap for the load process, the roll-up and other automatisms in the InfoCube. For more information see Automatic Further Processing.	...        1.      In the Manage Data Targets screen choose Environment -> Automatic Request Processing. The Maintenance of the Automatisms dialog box appears.        2.      Set the flag for rolling up the data into the aggregate under the group header Automatic Processing.        3.      Save your entries.
Program RSDDK_AGGREGATES_ROLLUP	You can also roll up with program RSDDK_AGGREGATES_ROLLUP (see Direct Execution - Reports). You can schedule this program as a regular background job or use it in an Event Collector.

Result

In Reporting, the new data is used in those queries that are started after the roll-up.