Overview: Executing Rollups 

Use

Rollups allow you to store commonly-used data in a summarized form, depending on the level of detail you require. By using rollups, you can achieve a significant reduction in processing time.

Procedure

  1. Define a rollup ledger.

    2. The rollup ledger receives summarized data from one or more source ledgers and must be defined before you can define a rollup. You must activate the Rollup allowed indicator in Customizing for Special Purpose Ledger if you want to define a ledger as a rollup ledger.

    For more information about defining a ledger, see the Maintain Ledgers step in the Implementation Guide (IMG) for Special Purpose Ledger.

  2. Create field movements and substitution activities.

    3. Before you create a rollup, you must define a field grouping code that contains field movements. Field movements determine which dimensions from the source ledger(s) are transferred to the rollup ledger.

    If you want to substitute data being transferred from the source ledger(s) to the rollup ledger, you need to create a substitution activity and enter a substitution activity code as part of the field movement. You enter the field movement code in each rollup action sequence you define.

    For more information, see Field Movements and Rollups.

    You can create field movements and substitution activities in Customizing. Detailed procedures for creating field movements and substitution activities in Customizing are described in the Maintain Field Movements and Maintain Substitution steps in the Implementation Guide (IMG) for Special Purpose Ledger.

  3. Create sets.

    4. Before you define a rollup, you must create sets for the rollup. The header set used in a rollup determines the data to be summarized into a rollup ledger, and the reset set determines the data fields in the rollup ledger to be reset to zero. The sequence set restricts the data to be processed for the respective rollup sequence.

    For more information, see Sets and Rollups and Creating Sets.

    You can find more information on creating sets under Set Creation.

  4. Create the rollup.

You create an allocation cycle in the following steps:
  1. Create the rollup and choose a rollup type
  2. Define the rollup header.

b) Define the rollup sequences (for standard rollups).

c) Enter the field movement information.

For more information, see Creating Rollups.
  1. Verify the rollup.

    2. After you have created a rollup, you can use the Check rollup function to check for any errors in your rollup definition.

    For more information, see Checking Rollups.

  2. Document your rollup.

    3. If you want to print a detailed listing of your rollup definition and statistics, you can use the Document rollup function.

    For more information, see Documenting Rollups.

  3. Execute the rollup.

    4. To execute a rollup, you use the Execute function.

    For more information, see Executing Rollups.

  4. Reverse a rollup, if desired.

    5. If you want to reverse a rollup, you use the Reverse function. Reversing a rollup is different from resetting data with a reset set. When you reverse a rollup the system creates reversing documents that offset the original line items. When you reset data with a reset set, the system resets selected data fields to zero but does not create any new documents. Refer to the online documentation for the Write line items field for further information.

    For more information, see Reversing Rollups.

  5. Execute or reverse a rollup in background processing.

If executing or reversing your rollup involves large amounts of data and requires a long processing time, you should execute or reverse your rollup in background processing.

For more information, see Defining Rollups for Background Processing.