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. It is used to set object name, identifier and comment.
Parameters. It is used to set a list of parameters
Facts. A list of cube facts, which will then reflect actual cube data, is created.
Cubes Structure. Source cubes are specified, which data will be used in calculation, and a calculated cube structure is created.
Alternative Cube. The cube is specified, to which calculated values should be saved if the source cube does not support data saving.
Units and Indicators. Dictionaries are specified, which are used to organize automatic data scaling into required measurement units
Manage Formulas. The dimension and dimension attribute are specified, by which values formula actual period should be determined.
Manage Parameters. Passing of parameter values to open objects used in the cube is set up
Controlling Dimensions. Interaction between parametric cube dimensions and other dimensions is set up.
Formula Editor. Calculation formulas are set up. The page is available only in the web application.
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.
See also: