To set up this aggregation mechanism on the Data Aggregation page:
Click the Edit button. The button is available when a single element or elements of one dimension are selected in the tree of elements.
Double-click the element/level/dimension/.
A dialog box for setting up aggregation for the selected dimension opens.
The dialog box for aggregation setup contains the following parameters:
Aggregate Selected Elements Only. If the checkbox is selected, aggregation is executed using the method specified for the dimension and taking into account dimension selection. The checkbox is deselected by default.
Destination Level. In the drop-down list select a level, for which aggregation is to be set up. If the [All Levels] element is selected as a level, aggregation is set up for all levels including those that can be created later.
Aggregation Method. In the drop-down list select the required aggregation method:
None. No aggregation.
Sum. Source level elements are summed up.
Minimum. The minimum value is selected on the source level.
Maximum. The maximum value is selected on the source level.
Number of Non-Empty. The number of non-empty values is defined on the source level.
Number of Empty. The number of empty values is defined on the source level.
Number of All Children. The number of child elements is defined on the source level.
Arithmetic Mean. The arithmetic mean of the level elements is defined, considering empty values.
Actual Mean. The actual mean value of the level elements is defined, not considering empty values.
First Actual. The first actual value is found on the source level.
Last Actual. The last actual value is found on the source level.
Root-Mean-Square Deviation Based on Sample. Root-mean-square deviation is defined for row by sample data.
Median. A median is defined for source level values.
Root-Mean-Square Deviation. A root-mean-square series deviation based on the entire population is defined.
Number of Different Values. The number of different values is defined on the source level.
Automatically Determine Source Levels (Child Elements). When the checkbox is deselected, a list of lower levels becomes available for editing. This list shows all elements that are located lower than the selected destination level. The checkbox is always selected and unavailable for editing for the All Levels element.
Save Aggregated Data. The area contains radio buttons to determine cases of aggregated data calculation and to display them to preview area in reports:
Always. The radio button is selected by default. Aggregated data will always be calculated and displayed on consumer level.
Only When There is No Data. Aggregated data will be calculated and displayed at consumer level, in case if there is no data at consumer level.
Only When Result is Not Empty. Aggregated data will be calculated and displayed on consumer level only if aggregation result is not empty.
NOTE. Aggregated data is not saved to cube data source, it is calculated and displayed to preview area.
Handle Empty Values. The area contains radio buttons to determine how empty values are handled:
Used in Aggregation. Empty values are not used in aggregation.
Only When Parent is Not Empty. Empty values are not used in aggregation only if the parent element is not empty. If aggregation result by child elements is equal to empty value, and the parent element already has value, the value is replaced with empty value.
Not Used in Aggregation. Empty values are not used in aggregation. It is used by default.
Additional Parameters. The area contains the Consider Value in Owner checkbox. The checkbox is selected by default, and when aggregated data is loaded to consumer level, values on this level are considered.
After the basic aggregation mechanism is set up, non-aggregated data is loaded to the cube. Data aggregation is to be executed within the cube.
If the parent element is not selected, the following is selected:
Aggregation to Its Level. If the parent element is not selected, data by its child elements is not used during calculation of parent elements.
Aggregation with a Jump to One Level. It is used by default. If parent element is not selected, data by its child elements is used to calculate the next parent element. It is used, if the IBasicMatrixAggregator.UseSelectionEx property is set to True for aggregated dimension.
For example, there is a hierarchy where the following elements are selected:
Calculation can be executed in different ways:
On aggregation to its level:
Step | The Consider Value in Owner checkbox is selected | The Consider value in Owner checkbox is deselected |
Calculation is executed on low level | ||
Item 1.1 = Item 1.1 + item 1.1.1 + item 1.1.2 | Item 1.1 = item 1.1.1 + item 1.1.2 | |
Value of high level is calculated | ||
Item 2 = Item 2 | Item 2 = Item 2 | |
Item 3 = Item 3 | Item 3 = Item 3 | |
Value for the root element is calculated | ||
Root = Root + item 2 + item 3 | Root = item 2 + item 3 |
On aggregation with jump to level:
Step | The Consider Value in Owner checkbox is selected | The Consider value in Owner checkbox is deselected |
Calculation is executed on low level | ||
Item 1.1 = Item 1.1 + item 1.1.1 + item 1.1.2 | Item 1.1 = item 1.1.1 + item 1.1.2 | |
Value of high level is calculated | ||
Item 2 = Item 2+ item 2.1.1 + 2.1.2 | Item 2 = item 2.1.1 + 2.1.2 | |
Item 3 = Item 3 + item 3.1.1 | Item 3 = item 3.1.1 | |
Value for the root element is calculated | ||
Root = Root + item 1.1 + item 1.3 + item 2 + item 3 | Root = item 1.1 + item 1.3 + item 2 + item 3 |
See also: