Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

Rolling Up Data into an Aggregate

Procedure documentation Rolling Up Data into an Aggregate Locate the document in its SAP Library structure

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
Recommendation
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.
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 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  Structure linkCreating a Process Chain in the Creating a Process Chain Using the Maintenance Dialog for a Process section.
Start data package roll-up manually
This graphic is explained in the accompanying text 
Use this procedure if the data of multiple data packages form one logical unit and should therefore only be released together.
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 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
...
       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 Structure linkProcess Control and Structure linkCreating an Event Collector.
Roll up each data package to the aggregate automatically
Note 
The InfoCube must be technically correct and you must be sure of its quality.
Caution
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 Structure linkAutomatic 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 Structure linkDirect Execution - Reports).
Note
You can schedule this program as a regular background job or use it in an Structure linkEvent Collector.

Result

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

2 comments:

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget