Entering content frame

Procedure documentation Rolling Up Data in Aggregates Locate the document in its SAP Library structure

Use

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.

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 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

Recommendation

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.

Note

The system recommends the greatest possible value for Rollup to Request ID. You can overwrite this if necessary.

       2.      Choose Process Chain Maintenance.

This graphic is explained in the accompanying text 

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 Structure linkCreating Process Chains in the section Creating Process Chains by Using a Maintenance Dialog for a Process.  

Starting data package rollup manually

This graphic is explained in the accompanying text 

Use this procedure especially when the data from several data packages create a logical unit, and they therefore only need to be released.

Example

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

Structure linkPostprocessing

...

       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 Structure linkProcess Control and Structure linkCreating an Event Collector.

Roll up each data package in the aggregate automatically

Note 

The InfoCube has to be technically correct and the quality has to be assured.

Caution

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 Structure linkAutomatic Further Processing.

...

       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 Structure linkDirect Execution - Reports).

Note

You can schedule this program as a regular background job or use it in an Structure linkEvent Collector .

Result

The new data is available in reporting for queries that are started after the rollup.

 

See also:

Structure linkManaging InfoCubes

 

Leaving content frame