To work with the tool in Foresight Analytics Platform 10, use the new interface.

Setting Up Aggregation in Fixed Dimensions

Along with moving a dimension to another layout group and setting up selection, the user can set up aggregation in fixed dimensions on working with data area dimensions.

Aggregation by fixed dimensions allows for merging data by selected elements in fixed dimensions.

Multiple selection is available for a fixed dimension with configured aggregation:

In the Dimensions area on the Data Sources and Data Slices panel.
On the Controls panel.

Setting Up Aggregation Method

To enable aggregation in fixed dimensions of data area, select the Enable Data Aggregation checkbox in the Dimension Parameters dialog box and select aggregation method in the Method drop-down list.

Depending on the method of enabling aggregation, the following aggregation methods are available in fixed dimensions:

Sum. Elements are summed up.
Minimum. The element with the minimum value is selected.
Maximum. The element with the maximum value is selected.
Number of Non-Empty. The number of non-empty values is determined.
Number of Empty. The number of empty values is determined.
Number of All Children. The number of child elements is determined.
Arithmetic Mean. The mean value is calculated, taking into account empty values.
Actual Mean. The mean is calculated ignoring empty values.
First Actual. The first existing (actual) value is taken.
Last Actual. The last existing (actual) value is taken.
Root-Mean-Square Deviation Based on Sample. Root-mean-square deviation based on sample is determined.
Median. A median is determined for selected elements.
Root-Mean-Square Deviation. A root-mean-square deviation is determined for selected elements.
From Source Dimensions. Fixed dimension data is handled with the aggregation method specified in settings of data source.

When working with ADOMD cubes, the aggregation set up in the corresponding ADOMD sources is used.

From Source Facts. In fixed dimensions with full selection server aggregation is used according to the methods specified for source facts. Source facts aggregation should be set up if a data source contains several records for one set which should be aggregated.

If the Aggregate Selected Elements Only checkbox is selected in cube dimension aggregation settings and for facts on the Facts Binding page the aggregation method is selected, aggregation is calculated on the server by selected elements according to the methods specified for cube facts. If parent element is selected, aggregation is executed only for its child elements. If parent element is selected without child elements, data is not aggregated into it. If the checkbox is deselected and multiple selection is used, aggregation is executed by the entire dimension, regardless of the selection. If parent element is selected, aggregation is executed by its child elements.

If the ODBC data source is selected as a fact table, in the standard cube wizard for this data source one can calculate client aggregation.