Multidimensional Calculation on Database Server

Calculated cube features are implemented using a multidimensional calculation on database sever, but the actual calculation is executed on the database server to free resources of the local computer in the desktop application. Multidimensional calculation using specified formulas calculates the values of one cube's facts on the basis of the fact values of other cubes. Fact calculation formulas are stored in a special table.

To create a multidimensional calculation, open the object navigator and select:

The Create > Other > Cube > Multidimensional Calculation on Database Server context menu item.
The New Object > Other > Cube > Multidimensional Calculation on Database Server item in the Create group on the Home ribbon tab.

After executing one of the operations the multidimensional calculation wizard opens. The wizard contains the pages:

Basic Properties. The page is used to set object name, identifier and comment.
Parameters. The page is used to create a list of parameters.
Properties. The page is used to specify a database connection, in which calculation will be executed.
Sources. The page is used to create a list of standard cubes, which data will be used in calculation.
Structure. The page is used to specify a source cube and to fix dimensions.
Formulas Table. The page is used to specify the table, which will store calculation formulas.
Manage Parameters. The page is used to set up passing of parameter values to open objects used in multidimensional calculation.
Controlling Dimensions. The page is used to set up management of dimension parameters using other cube dimensions.

To define or edit multidimensional calculation formulas, open the object navigator and select the Edit Formulas context menu item.

Calculation is started:

From the formula editor dialog box.
From the object navigator:
- Select the Execute item in the multidimensional calculation's context menu.
- On double-click on multidimensional calculation.

After executing one of the operations the Calculation Options dialog box opens.