Data Aggregation

Display versions is a separate set of aggregation parameters, which is used to quickly switch between and calculate data on viewing the cube.

The display version, for which aggregation parameters are set up, is selected in the Display Versions drop-down list.

NOTE. The Display Versions drop-down list is available only in the desktop application. In the web application, one can set up cube display versions on the Display Versions page.

By default, a cube has a single display version, name and identifier of which match the name and identifier of the cube itself. To create a new display version, click the Add button, to edit the existing display version, select it in the drop-down list and click the Edit button. After that the Display Versions dialog box opens:

The dialog box enables the user to determine name and unique identifier of the display version. The dialog box also contains the Hidden Display Version checkbox. If this checkbox is selected, the display version cannot be selected on working with the cube in the Analytical Queries (OLAP) tool.

The Set as Default button enables the user to choose the display version, which will be applied on opening the cube.

In the drop-down list select cube facts, by which values aggregation will be executed. One can select multiple facts in the list for simultaneous aggregation mechanism setup:

• If aggregation settings for selected facts match or are not set, settings changes are applied to all selected facts.

• If aggregation settings for selected facts differ, the confirmation dialog box opens. If the answer is positive, aggregation settings for selected facts are reset.

If required, one can determine different aggregation mechanisms for each fact.

Set up dimension aggregation. Originally, this area displays the list of elements corresponding to cube dimensions.

To set up aggregation of the selected dimension:

• In the web application click the Edit button.

• In the desktop application:

• Click the Edit button.

• Select the Edit item in the dimension's context menu.

• Press F4.

After executing one of the operations the <dictionary name> - Main aggregation mechanism dialog box opens.

NOTE. Aggregation setup is available if one tree element is selected or tree elements belonging to the same dimension are selected.

To change aggregation mechanism of calendar dimension from main to chronological and vice versa, click the Change Aggregation Mechanism button. This change is displayed in the Aggregation Mechanism/Method column. When aggregation mechanism is changed, all settings of the current mechanism are deleted (confirmation required).

By default, basic aggregation mechanism is selected for calendar dimension. If no aggregation settings have been determined for a calendar (the Aggregation Mechanism/Aggregation Method column is empty), the chronological aggregation mechanism is set up on clicking the Change Aggregation Mechanism button.

To reset aggregation settings of the selected dimension:

• In the web application click the Delete button

• In the desktop application:

• Click the Delete button.

• Select the Delete item in the dimension's context menu.

• Press the DELETE key.

After executing one of the operations the operation confirmation dialog box opens. If the answer is positive, aggregation settings of the selected dimensions are reset.

If dictionaries with alternative hierarchy were selected in cube dimensions, aggregation can be set up by alternative hierarchy levels.

For dictionaries with alternative hierarchy, the Alternative Hierarchy folder with alternative hierarchy levels available for dictionary, for which aggregation can be set up, will be displayed.

Aggregation for Years or Quarters levels can be set up in the Alternative Calendar dictionary. The aggregation is set up separately for each level.

The aggregation setup by alternative hierarchy levels is the same as aggregation setup by dimensions.