Using the Aggregation Template
Use the Aggregation template to aggregate data values of members you specify.
Using the Aggregation template, you can:
-
Restrict the aggregation by entering members in the Point of View
-
Specify whether to aggregate missing values
-
Specify whether to aggregate values into the local currency (not supported for hybrid aggregation)
When aggregating values, the following calculation commands are supported:
-
SET UPTOLOCAL ON: Aggregate the data up to the local currency (This commnad is not suppored for hybrid aggregation.)
-
SET CACHE HIGH: Set a value for the calculator cache (This command is not supported for hybrid aggregation.)
-
SET AGGMISSG ON: Aggregate the missing values in the database
-
SET FRMLBOTTOMUP ON: Optimize the calculation on a sparse dimension
For example, you could use the Aggregation template to aggregate dense or sparse dimensions using a parent member, and select a level of aggregation, such as Descendants, Children, or Ancestors(all).
To use the Aggregation template:
Table 6-6 Aggregation Wizard Steps
Step | Explanation |
---|---|
Information | Describes the function of the template. |
Point of View | Select the members for the dimensions to which you want to restrict the aggregation.
The following options are available to select members.
|
Full Dense Aggregation | Select up to two dense dimensions to aggregate fully, and specify whether the dense dimensions have stored non-level 0 members. Note the following:
|
Full Sparse Aggregation | Select up to three sparse dimensions to aggregate fully, and specify whether the sparse dimensions have member formulas that need to be calculated.
If a sparse dimension has a member formula, then the sparse dimension is calculated. If a sparse dimension does not have a member formula, then the sparse dimension is aggregated. |
Partial Dimension Aggregation Dense | Select up to two dense dimensions for partial aggregation. For each dense dimension, select a member and an aggregation level. Note the following:
|
Partial Dimension Aggregation Sparse | Select up to three sparse dimensions for partial aggregation. For each sparse dimension, select a member and an aggregation level. Note the following:
Note:
|
Settings | Specify the settings on the step. |