Aggregation setup determines, data by dimensions will be aggregated and by which method.
Aggregation can be set up on the Aggregation page in the aggregation block editing wizard:
To set up dimension aggregation:
Select the dimension to be aggregated.
Click the Edit button or double-click the dimension with the main mouse button.
The Set Up Aggregation dialog box opens, in which set dimension aggregation parameters.
As a result, dimension aggregation is set up. If required, similarly set up aggregation for the next dimension.
To delete the selected aggregation settings, click the Delete button.
To set up dimension aggregation parameters, use the Set Up Aggregation dialog box:
Setup order:
Determine dimension elements used in the aggregation. If it is required that only selected dimension elements are used in aggregation, select the Aggregate Selected Elements Only checkbox. By default, the checkbox is deselected and aggregation is calculated by all dimension elements.
Select a destination level in the dimension, for which aggregation is set up. Use the Destination Level drop-down list. If the [All Levels] element is selected as a level, aggregation will be set up for all levels including those that can appear later.
Determine aggregation method in the Aggregation Method drop-down list. For details about available aggregation methods, see the Aggregation Methods section.
Determine source levels for aggregation.
To automatically determine source levels, select the Automatically Determine Source Levels (Child Elements) checkbox.
To manually determine source levels, make sure that the Automatically Determine Source Levels (Child Elements) checkbox is deselected and select checkboxes of all required levels.
If aggregation is set up for all levels, the source levels are always determined automatically.
Determine whether the destination level value should be taken into account on aggregation calculation. By default, aggregation is calculated taking into account destination level. If the value is required to be excluded from aggregation, deselect the Include Owner Value checkbox.
Determine method of saving non-aggregated data at the destination level. Use the Save Non-Aggregated Data group of radio buttons:
Never. Aggregated data is always written to the destination level.
Always. Aggregated data is not saved to the destination level if the destination level already contains data.
Only When the Result is Empty. Aggregated data is saved to the destination level only if the aggregation result is empty.
As a result, aggregation for the selected dimension is set up.
The following methods are available to aggregate dimension in matrix aggregation model:
None. No aggregation.
Sum. Source level elements are summed up.
Minimum. The minimum value is selected at the source level.
Maximum. The maximum value is selected at the source level.
Number of Non-Empty. The number of non-empty values is determined at the source level.
Number of Empty. The number of empty values is determined at the source level.
Number of All Children. The number of child elements is determined at the source level.
Arithmetic Mean. The arithmetic mean of the level elements, considering empty values, is determined.
Actual Mean. The actual mean value of the level elements, not considering empty values, is determined.
First Actual. The first actual value is taken at the source level.
Last Actual. The last actual value is taken at the source level.
Root-Mean-Square Deviation by Sampling. Root-mean-square deviation is defined for row based on sample.
Median. Determines a median for source level values.
Root-Mean-Square Deviation. Determines a root-mean-square series deviation based on the entire population.
Number of Different Values. The number of unique values is determined at the source level.
See also: