Cubes Structure: Calculated cube

The Cubes Structure page is used to define the structure of the calculated cube. The page is used to select source cubes and to define calculated cube dimensions.

To add a source cube, click the Add Cube button in the Source Cubes area. The Select Source Cube dialog box opens.

To quickly select an object, enter object's name/identifier/key in the search box depending on display settings. Search is executed automatically while the searched text is entered into the search string. The list will display the objects, which names/identifiers/keys contain the entered text.

To set up displaying of repository objects, click the Show Object button and select display option in the drop-down menu:

Name. Objects are displayed with their names. Default option.
Identifier. Objects are displayed with their identifiers.
Key. Objects are displayed with their keys.

Several options can be selected. Identifier and key will be specified in brackets.

To reset selection for the selected objects, click the Clear button.

After executing the operation a cube is added in the Source Cubes field. Coordinates of added cube cells are used to create calculated cube equations. Cube data is used in calculations on creating a calculated cube.

To remove the selected source cube, click the Remove button.

To create a calculated cube multidimensional structure, add dictionaries, each of them will be a calculated cube dimension.

To add a dictionary:

Click the Add Dictionary button in the Destination Cube field.
Select the dictionary in the Source Cubes field and click the Add to Destination Cube button.

NOTE. All dimensions of source cubes and destination cube should have primary index.

To remove the selected dictionary from the Destination Cube field, click the Remove button.

NOTE. Removing dimension from destination cube is available if this dimension is not fixed in source cube.

To open the selected dictionary, select the Open Object context menu item. The dictionary opens for view in a new browser tab.

To edit the selected dictionary, select the Edit Object context menu item. The dictionary wizard opens in a new browser tab.

To set up displaying of objects in the Source Cubes and Destination Cube fields, in the drop-down menu of the Show Object button select the object display option:

Name. Default value. Only object names are displayed.
Identifier. Only object identifiers are displayed.
Name and Identifier. Object names and identifiers are displayed.

Fixing dimensions enables the user to reduce the number of dimensions that are used to describe cube cell coordinates in formulas. Fixing means setting direct correspondence between source dictionary elements and destination dictionary elements. Correspondence is set between dimension elements by index.

NOTE. Fixing dimensions in the Source Cubes field is available if dimensions are added to destination cube.

To fix dimensions, select dictionaries.

To unfix dimensions, deselect them.