Creating Rollup Headers for Standard Rollups 

Use

The rollup header contains information that is valid for the entire rollup. With a standard rollup, you can rollup data up into one or more rollup ledgers. To do so, you use one or more rollup sequences.

Prerequisites

On the Create Rollup initial screen, you have flagged the rollup type standard and chosen.

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 Tables, enter the name of the sender table and receiver table.
  4. Under reset, if required, enter the name of the reset set.

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 situations:

The rollup field movement was changed after execution. When a rollup is executed again for a given period, different rollup records are created to the ones created on previous execution. The new rollup records do not overwrite the old ones. 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 this period to 0. Subsequently, all rollups can be executed again with the Cumulate Values flag.

To optimize performance, your reset set must contain the following dimensions:

Your reset set must not use the following dimensions:

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

You have to enter the number of the user exit in the user exit field. For further information, see User Exits and Rollups.

The rollup set is used for all sequences in the rollup. Using the multi-dimension set specified in this field, the system chooses the data that is to be taken from the source ledger(s) and summarized.

To optimize performance, your rollup set must contain the following dimensions:

Your rollup set must not contain the following dimensions:
  1. To enter default values for processing the rollup, choose Processing Options. The Default Values dialog box appears. You can choose between the following functions:
    1. Write Line Items

      2. If you set the Write Line Items flag, a line item will be written for every you totals record when you execute the rollup. This line item will flag the totals record during drilldown. It will then be possible to reverse this rollup run.

      Only set the Write line items indicator if you want the option of reversing the rollup or if you only want to roll up a small amount of data. If you set the Write line items indicator, processing time will be increased enormously.

      Writing line items is something you should only do in exceptional cases.

      With an extremely long rollup, a very large amount of a data is rolled up to a rollup ledger. With a second rollup, a smaller amount of data is to be cumulated to the same ledger, meaning that the rollup must be performed again, as repostings will take place. In this case, you can reverse the data from the second rollup specifically and execute the rollup again. Should no line items be stored, you would have to execute both rollups again.

    2. Cumulate Values

      3. If you do not set the Cumulate Values flag (standard setting), the existing records in the rollup ledger will be overwritten by the rollup records in the current run. This only applies for periods for which the rollup is currently being executed. The other period are not affected. It is not possible to execute a rollup more than once for a given period, as the values will simply be overwritten.

      If you set the Cumulate Values flag, the currently records currently being rolled up will be added to the existing records in the rollup ledger. As a consequence, repeated execution of the rollup leads to a multiplication of the totals.

      Cumulating values is only useful if you want to roll up data from several source ledgers to a rollup ledger in a series of rollups.

    3. Write Records with Amount 0

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.

You can use the following additional functions on this screen:

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

To create rollup sequence, choose Rollup Sequence. You can define a rollup sequence set for each rollup sequence, or you can define the rollup so that only the rollup header set applies to the rollup sequences. For further information, see Creating Rollup Sequences.

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 create sets, move your cursor to required set, enter the name and choose Set.

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 completed rollup definition. For more information, see: