Calculated Cube

A calculated cube is used to get new data calculated on the other cubes' data. Creating a calculated cube requires one or several cubes of any type. Dimensions in the calculated cube can be copied from source cubes or created on basis of arbitrary dictionaries. Facts can be created by the user or copied from the source cube. All formulas for calculating cube data are user-defined.

The calculated cube wizard contains the pages:

Basic Settings/Basic Properties. The page is used to set object name, identifier and comment.
Parameters. The page is used to create a list of parameters.
Facts. The page is used to create a list of cube facts, which will then reflect actual cube data.
Cubes Structure. The page is used to specify source cubes, which data will be used in calculation, and a calculated cube structure is created.
Alternative Cube. The page is used to specify the cube, to which calculated values should be saved if the source cube does not support data saving.
Units and Indicators. The page is used to specify dictionaries, which are used to organize automatic data scaling into required measurement units.
Manage Formulas. The page is used to specify the dimension and dimension attribute, by which values formula actual period should be determined.
Manage Parameters. The page is used to set up passing of parameter values to open objects used in the cube.
Controlling Dimensions. The page is used to set up interaction between parametric cube dimensions and other dimensions.
Formula Editor. The page is used to set up calculation formulas. The page is available only in the web application.

To save settings in the cube wizard:

In the web application:

Click the Save button.
Select the Save and Close item in the drop-down menu of the Save button. After this the specified settings are saved, the wizard closes, and the object navigator opens.

NOTE. The Save and Close item is available only on editing the settings.

In the desktop application click the Finish button.

To create or edit calculated cube formulas, select the Edit Formulas item in the context menu. The formula editor opens. The option is available only in the desktop application.