Sets and Rollups 

Use

You have the option of using sets in rollups. These select data for a rollup ledger, to rollup data based on a hierarchical set definition, and to select data to be reset to zero. You can use the following types of sets:

You can use sets in the following rollup components:

You can also use value variables in your rollup header, sequence, and reset sets, as well as set variables in your rollup sets.

When you use a set variable and/or value variable in a rollup, the system will prompt you to enter information for the variable when you execute the rollup.

Features

Rollup Sets

The rollup set values apply to all sequences within the rollup.

A rollup header set is always a multi-dimension set and must contain the following dimensions:

You cannot use the following dimensions in your rollup header set:

Your multi-dimension header set can include basic and/or single-dimension sets.

You can define a multi-dimension set that contains the following values:

You can enter the name of the multi-dimension reset set in the rollup header. When the system processes the rollup, fixed asset accounts 500000-501000 for ledger 01, record type 0, version 001, and companies 1000 and 1001 will be rolled up according to the field movement information you enter for the rollup.

If you want to create a hierarchical rollup, you include your cost center and/or business area hierarchy in the rollup header set (single-dimension set).

For more information, see Types of Rollups.

Rollup Sequence Sets

A rollup sequence set can be defined per sequence. The values you define in a rollup sequence set determine which data for a specific sequence will be rolled up.

The rollup header set determines the data that is selected for all sequences, and the rollup sequence set further defines the data to be selected for the specific rollup sequence. You can create a basic set that contains only the fixed asset accounts 500000-500020 (dimension Account). You can then enter the set name in the rollup sequence and enter a specific field movement and substitution activity for the sequence. In this case, the system will roll up accounts 500000-500020 only for ledger 01, record type 0, version 001, and companies 1000 and 1001 in the appropriate sequence according to the field movement information you enter for the rollup.

Reset Sets

A reset set is used to select data fields from a rollup ledger and reset the data fields to zero before the rollup is executed.

A rollup reset set is a multi-dimension set and must contain the following dimensions:

You cannot use the following dimensions in your rollup reset set:

Your multi-dimension reset set can include basic and/or single-dimension sets.

You can define a multi-dimension set that contains the following values:

You can enter the name of the multi-dimension reset set in the rollup header. When the system processes the rollup, the data records for fixed asset accounts 500000-501000 for ledger 01, record type 0, version 001, and companies 1000 and 1001 will be reset to zero before the rollup is executed.

You can find more information on creating sets under Creating Sets.