Set Hierarchies
Use
When you create basic, single-dimension, data, and multi-dimension sets, you create the building blocks for a set hierarchy . Using single-dimension sets, you create a set hierarchy that links together sets with the same dimensions. Using multi-dimension sets, you link together sets with different dimensions.
You do not have to include all set types in a set hierarchy. For example, you could define a hierarchy of only basic sets within a single-dimension set.
Note
Before you begin building a set hierarchy, you must plan the structure of your hierarchy and know how you will use the hierarchy. You should also know which dimensions, sets, and values you want to use in the hierarchy.
Features
When you create a set hierarchy, you create different levels of information. You can define up to 99 levels in a set hierarchy.
Example
You can combine single-dimension sets and basic sets to create the multi-dimension set hierarchy in the following graphic. In the set CC-ACCT, the dimension "Cost Center" occurs first and the dimension "Account" is second. When you use the set CC-ACCT as a row of a report, overhead accounts are listed by account number within cost centers.
Example Set Hierarchy
By moving the order of a value in a set, you can change the order of set values in a report or produce reports with the same information, but in different formats.
Example
The following graphic contains the same sets as in the previous graphic; however the dimension "Account" occurs first in the set, and the dimension "Cost Center" is second. When this set is used as a row of a report, cost centers are listed within overhead accounts.
Changed Set Hierarchy
If you change a set, you do not have to change the definition of a report that uses the set; you only need to regenerate the report. For more information, see uses of sets in Report Writer .