Data Aggregation

Aggregation is used to merge several values in a single element. For example, for calculation of parent element based on selected child elements or for calculation of element data based on several fields.

Data is merged by means of various mathematical functions, for example, the sum or arithmetical mean of all aggregated values.

Foresight Analytics Platform provides the following types of aggregation:

To set up calculations by edited data without pre-saving of data to source,Setting Up Formula Calculation is used.

Aggregation of Cube Fact Dimension

It enables the user to merge data source fields that are not linked to cube dimensions. Aggregation result is passed to cube fact dimension.

Depending on the calculation location, the aggregation is divided into two types:

The At Client Checkbox is selected by default.

Use the Facts Binding page of the standard cube creation wizard to set up aggregation.

Data aggregation method

Example of aggregation

NOTE. If cube fact dimension aggregation is set, it is not available to use calculated expressions in linked cube facts.

Aggregation by Dimension Levels

It enables the user to merge data of dimension elements by levels. Result of aggregation of child elements is passed to parent element.

Aggregation is executed in the cube opened in the client workstation.

Aggregation is set up for a separate cube display variant on the Aggregation page of standard or automatic cube creation wizard.

Data aggregation method

Example of aggregation

NOTE. If cube with aggregation by dimension levels is displayed, on setting up totals the From Source calculation method is available in the table visualizer.

Aggregation by Alternative Hierarchy Levels

It enables the user to merge data of dimension elements by alternative hierarchy levels. Result of aggregation of child elements is passed to parent element.

Aggregation is executed in the cube opened in the client workstation.

Aggregation is set up for a separate cube display variant on the Aggregation page of standard or automatic cube creation wizard.

Data aggregation method

Example of aggregation

Aggregation of Fixed Dimensions for Metrics

It enables the user to merge data of all elements selected in fixed dimensions. Aggregation result is passed to a tool visualizer. The aggregation method on dimensions is available for each dimension metric with the Metric role.

The aggregation method is set manually in report or is sent from cube:

In case of multiple selection by the Value metric, the aggregation type of the first cube element is applied.

Data aggregation method

See also:

Creating Cubes