Multi-Dimension Sets
Definition
You use multi-dimension sets to create combinations of sets that use more than one dimension. You create multi-dimension sets using basic, data, and single-dimension sets.
Example
You create a multi-dimension set (called CC-ACCT) that contains the basic set CENTERS (dimension Cost Center) and the basic set OHD-ACCT (dimension Account). This multi-dimension set contains cost centers 100, 200, 300, and 400, and accounts 3000010, 3000020, and 3000030 (see the following graphic).
Multi-Dimension Set CC-ACCT
You cannot combine multi-dimension sets. Also, a dimension can only appear once in a multi-dimension set.
For example, you cannot define a multi-dimension set that contains the basic set ASSETS and the basic set LIABILITIES (dimension Account). You should first define a single-dimension set that contains the basic set ASSETS and the basic set LIABILITIES, and then include the single-dimension set in the multi-dimension set.
Use
The primary use of multi-dimension sets is to combine sets with values from different dimensions to create set hierarchies.
Example
You could define a multi-dimension set that contains the dimensions Business Area and Account (sales accounts). When you use the set in a report row, you could display the sales within each business area.