Use the Cubes Structure page to define the structure of the calculated cube. Source cubes are selected, and calculated cube dimensions are defined.
To add source cubes:
In the web application click the 
Add Cube button in the Source Cubes field.
In the desktop application click the Add button below the Source Cubes field.
Coordinates of cube cells will be used to form equations of the calculated cube. Respective data will be used in calculations on creating a calculated cube.
To delete the selected source cube, click the 
Delete button in the web application or the Delete button in the desktop application.
To create multidimensional structure of calculated cube, add dictionaries to it. Each dictionary is a dimension of the calculated cube. To add dictionaries:
In the web application click the Add Dictionary button in the Destination Cube field.
In the desktop application click the Add button below the Destination Cube field.
In the desktop application one can also add the dimension existing in the source cube to the destination cube. To do this, select the Add to Destination Cube item in the context menu of the selected dimension.
NOTE. The Primary Key is not Specified for Free Dimension error can appear on creating a calculated cube. Proper creation of calculated cube requires the primary index to be in all dimensions of the source cube and destination cube.
To delete the selected dictionary:
In the web application click the Delete button or select the Delete context menu item.
In the desktop application click the Delete button or select the Delete Dimension context menu item.
NOTE. The dimension fixed in the source cube cannot be deleted from a destination cube. A warning message is displayed when this operation is executed. To delete this type of dimension, first remove a fixation and then try again.
Fixing dimension enables the user to reduce the number of dimensions that are used to describe cube cell coordinates in formulas. Fixation means direct correspondence between source dictionary elements and destination dictionary elements. Dimension elements are mapped by index.
NOTE. The dimension, which is not added to the destination cube, cannot be fixed.
Execute the following to fix the selected dictionary:
Double-click on it in the desktop application.
Select the Fix Dimension checkbox the context menu.
Fixed dictionaries are highlighted in bold.
To remove fixing, execute one of the following:
Double-click on it in the desktop application.
Deselect the Fix Dimension checkbox in the context menu.
The context menu includes the following items:
Show Names. Only names are displayed in the tree.
Show Identifiers. Only identifiers are displayed in the tree.
Show Names and Identifiers. Only names and identifiers are displayed in the tree.
Move Dimension Up. It moves the selected dimension up.
Move Dimension Down. It moves the selected dimension down.
Go to Object. The focus in the object navigator moves to the selected dimension.
NOTE. Other items are described in the corresponding subsections on this page.
Lags can be set for source cube and destination cube dimensions in the desktop application. The lag determines the number of neighbor values towards the current calculation point will be loaded on calculating formulas. The lag setting can be required, if formula supposes to use value of the element excluded from selection.
To set the lag, select the Edit lags context menu item of the required dimension. The Slice Lags dialog box opens:
Values to be set:
Backward Lag. It determines for how many previous elements excluded from selection the value will be extracted (default value is 0).
Forward Lag. It determines for how many next elements excluded from selection the value will be extracted (default value is 0).
NOTE. The lag setting can be required to provide a correct calculation of the LAGVAL function.
See also: