Show TOC

Procedure documentationRolling Up Data into Aggregates Locate this document in the navigation structure

 

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

End of the note.

Type of Execution

Procedure

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

Recommendation Recommendation

We recommend use in a process chain

End of the recommendation.

· with complex schedules

· where there are difficulties with automations and event collectors

· for all new development

  1. Choose the Roll Up tab page.

    Note Note

    The system proposes the greatest possible value for Rollup to Request ID. However, you can overwrite this.

    End of the note.

  2. Choose Process Chain Maintenance.

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

    End of the note.

Start data package rollup manually

Note Note

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

End of the note.

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

End of the note.

  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 Note

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

End of the note.

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

End of the note.

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

You can schedule this program as a regular background job.

End of the note.

Result

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

More information:

Managing InfoCubes