Show TOC

Rolling Up Data into AggregatesLocate this document in the navigation 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 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.

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

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 proposes the greatest possible value for Rollup to Request ID. However, you can overwrite this.

  2. Choose Process Chain Maintenance.

    Note

    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.

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

Start data package rollup manually

Note

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

Note

Different plants deliver their data at different points in time. The data needs to be visible first, however, in the InfoCube if 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

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

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

Note

The InfoCube must be technically correct and you must be sure of its quality.

Note

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 Start of the navigation path Environment Next navigation step Automatic Request Processing End of the navigation path. The Automatism Maintenance dialog box appears.

  2. Under the group header 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).

Note

You can schedule this program as a regular background job.

Result

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

More information:

Managing InfoCubes