Rolling up Data into an Aggregate (SAP Library

Rolling up Data into an Aggregate

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 the data into the aggregate tables for a set time frame. This process is known as rolling 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.

Note

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, but has a negative impact on system performance when the data is read. Only use this method if no read process takes place while the data is being loaded.

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

Include roll-up of the data packages as a process in a process chain

Recommendation

We recommend use 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.

Note

The system recommends the highest possible value for Rollup to Request ID. You can overwrite this if you need to.

2. Choose Process Chain Maintenance.

Note

Call transaction RSPC. This opens the Process Chain Selection dialog box. This provides an overview of the various process chains in the BW system.

If you cannot find any suitable process chains, you can create a new process chain for the roll up.

For more information, see Creating Process Chains in Creating Process Chains by Using a Maintenance Dialog for a Process.

Start data package roll up manually

Note

Use this procedure in particular if data from several data packages creates a logical unit, and therefore should to be released together.

Example

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. Select the start date. You have the following options:

- Immediately

- Date/time

- After job

- After event

- In operation mode

4. If you want to run the job periodically, set the corresponding flag .

5. Save your entries.

The following procedures are also possible but should not be used for new scenarios.

Type of Execution	Procedure
Postprocessing	... 1. Choose the Roll Up tab page. 2. Choose Postprocessing. The Maintain Events to Run After Processing dialog box appears.
Roll up each data package in 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. On the Manage Data Targets screen choose Environment -> Automatic Request Processing. The Automatism Maintenance dialog box appears. 2. Under Automatic Processing, set the Roll Up Data into the Aggregate flag. 3. Save your entries.
Program RSDDK_AGGREGATES_ROLLUP	You can also run roll up using 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

The new data is available in reporting for queries started after the roll up.

See also:

Managing InfoCubes