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:

  • Basic sets

  • Single dimension sets

  • Multi-dimension sets

You can use sets in the following rollup components:

  • Rollup header, as rollup sets or reset sets

  • Rollup sequences, as rollup sequence sets

Note Note

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.

End of the note.

Features

Rollup Sets

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

Caution Caution

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

End of the caution.

  • Ledger

  • Record type

  • Version

  • Company code or company (local or global)

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

  • Client

  • Period

  • Year

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

Example Example

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

End of the example.

  • Ledger 01 (dimension Ledger)

  • Record Type 0 (dimension Record Type)

  • Version 001 (dimension Version)

  • Companies 1000 and 1001 (dimension Company)

  • Fixed Asset Accounts 500000-501000 (dimension Account)

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.

Example Example

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).

End of the example.

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.

Example Example

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.

End of the example.

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.

Caution Caution

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

End of the caution.

  • Ledger

  • Record type

  • Version

  • Company code or company (local or global)

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

  • Client

  • Period

  • Year

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

Example Example

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

End of the example.

  • Ledger 01 (dimension Ledger)

  • Record Type 0 (dimension Record Type)

  • Version 001 (dimension Version)

  • Companies 1000 and 1001 (dimension Company)

  • Fixed Asset Accounts 500000-501000 (dimension Account)

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 .