Single-Dimension Sets
Definition
You use single-dimension sets to build hierarchies within a dimension. You create single-dimension sets by combining basic sets and/or other single-dimension sets that use the same dimension.
Note
As in basic sets you can also include values in single-dimension sets.
You can combine the basic sets ASSETS and LIABILITIES because they use the same dimension - "Account".
In a single-dimension set, you can not combine sets that use different dimensions. You use multi-dimension sets to combine sets that use more than one dimension.
The following graphic shows a single-dimension set called BAL-SHEET, which contains the basic sets ASSETS and LIABILITIES (dimension "Account").
Use
If you use the above set in a report row, the report lists your asset accounts (1000010, 1000020-1000050) and then your liability accounts (2000010, 2000020-2000050).
The following graphic shows an example balance sheet that uses the single-dimension set BAL-SHEET in the report rows.
In the above graphic, the Report Writer uses the data set ACT-GRP to select data for the report. The report only contains actual data in group currency for the year 1995. The accounts in the report appear in the order defined in the single-dimension set BAL-SHEET (basic sets ASSETS and LIABILITIES). If you change the sequence of the values in the set, then the order of the values also changes in a report.
Example
In the above graphic, assets are listed before liabilities. If you wanted to list liabilities before assets, you would change the single-dimension set BAL-SHEET, so that LIABILITIES is the first set in the single-dimension set.