Creating Rollup Headers for Hierarchical Rollups 

Use

The rollup header contains information that is valid for the entire rollup. In a hierarchical rollup, you rollup data according to the structure of the single-dimension set defined in your rollup header set.

Prerequisites

You have flagged a rollup type and chosen on the Create Rollup: Initial screen.

Procedure

  1. Under Title, enter a name for you rollup.
  2. If you want to require that a user have authorization for creating, displaying, maintaining, executing, and reversing this rollup, enter the name of an authorization group in the authorization group field.
  3. Under Summarize from, enter the name of the table in which you want the data to be summarized.
  4. If required, enter the name of the reset set under Reset. You can use the reset set to reset the data in the rollup ledger for the relevant periods to 0 prior to the actual rollup and before new data is summarized into the rollup ledger.

You can use the reset set to reset the data in the rollup ledger for the relevant periods to 0 prior to the actual rollup and before new data is summarized into the rollup ledger. A reset set is normally necessary, as the default active overwrite (see step 6: Cumulating Values) makes it possible for a rollup to be executed more than once in a given period.

A reset set is useful in the following circumstances:

Rollup field movement has been changed following execution of a rollup. When this rollup is executed again for a period, different rollup records are created to those created previously. The new rollup records do not match the old ones and therefore do not overwrite them. The old rollup records remain, therefore leading to incorrect results. By using a reset set, these old records can be set to 0.

If you want to roll up data from several source ledgers together in a rollup ledger, the Cumulate Values flag must be active for all affected rollups. If you then have to repeat these rollups in a given period, you can enter a reset set in one of the rollups. This will reset the values for these periods to 0. Subsequently, all rollups can be executed again with the Cumulated Values flag.

For performance reasons, you must include the following dimensions in your reset set:

You must not include the following dimensions in your reset set:

You can define a reset set to reset the data fields for account 100000 to zero. When you execute the rollup, the data fields for account 100000 will first be reset to zero in the receiver table, then the rollup will add data to all data fields that meet the selection condition in the rollup header set. For further information, see Sets and Rollups.
  1. If required, enter a user exit and/or a rollup set under Roles.

To refer the system to a user exit, enter the user exit number in the User exit field. For further information, see User Exits and Rollups.

The rollup set will be used for all sequences defined for the rollup. The multi-dimension set name you enter in this field selects the data to be rolled up from the source ledger(s).

For performance reasons, you must include the following dimensions in your rollup set:

You must not use the following dimensions in your rollup set:

If you are defining a hierarchical rollup, you must include the single-dimension set of the hierarchy dimension in the header set. For more information about sets and rollups, see Sets and Rollups.
  1. Under Hierarchy Dimension, enter the dimension that you want to use for processing the rollup (for example, cost center). This hierarchical dimension then determines the single-dimension set in the rollup set, over with the hierarchical summarization is to be made.

    2. Enter a representative value for each set in your hierarchy set. This representative value represents, for example, the node cost centers to which you want to roll up data. When the set is processed in the rollup, the system creates data records using the representative values. For more information about hierarchical rollups, see Rollup Types.

  2. Under Field Movement, enter the name of the field movement rule that should be used for the rollup. The field movement determines which dimensions will be transferred from the source ledger(s) to the rollup ledger.
  3. Under Receiver Ledger, specify how the data is to be summarized in the receiver system when you create an export rollup:
  4. Select the Processing optn indicator to enter default values for processing rollups. The Default Values dialog box appears. You can choose between the following functions:
    1. Cumulate Values

      2. If you want new rollup data to be added to existing rollup data in the rollup ledger, set the Cumulate Values flag. Do not set this flag if you want new rollup data to overwrite existing rollup data.

    2. Write Records with Amount 0

      3. If you want the system to insert blank records (records with the value zero in their amount fields) in the rollup ledger, set the Write records with amount 0 indicator.

      If you want to create a report that shows all accounts in a group of accounts (including accounts that have amounts equal to zero), you must include records that have zero in their amount fields. If blank records are not included in your rollup ledger, then the summary records of those accounts that are equal to zero will not be created or available for reporting.

    3. Elimination of Internal Business Volume

      4. If you want to eliminate internal business volume within a set hierarchy, set the Elim.of int.bus.vol.frm bus indicator . You can only use this field for hierarchical rollups. Elimination of internal business volume is only possible with dimensions for which a partner dimension has been defined in the master files (for example, SCNTR for SCNTR). If you have allocated costs between the final cost centers within a cost center area, you can eliminate inter-company business volume.

    4. Summarize Partners

Set the Summarize partner indicator to summarize data across sender and receiver cost center (only for hierarchical rollups).

You can use the following additional functions on this screen:

To display and maintain sets or field movements in the rollup header, choose . Move the cursor to the set or field movement you want to display. You can define field movement information for as many dimensions that you want to roll up in the ledger. You can define substitution activities for as many dimensions that you want to substitute in the ledger.

To check the rollup for errors, choose . For further information, see Checking Rollups.

To create sets, choose Set. Position your cursor on the required set.

To create a field movement, choose Field Movement.

Additional Processing Functions in the Create Rollup <Name>: Header screen

Menu Path

Function

Rollup ® Document

Document the rollup definition and Rollup Records

Extras ® History

Display change history for the rollup

Extras ® Different Currencies

Set the currency fields to zero

  1. To save the settings, choose .

Result

You have ended rollup definition. For more information, see: