Multidimensional Calculation on DB Server

The calculated cube features are implemented using a multidimensional calculation on DB sever, but the actual calculation is executed on the database server to release resources of the local computer. The multidimensional calculation using specified formulas calculates the values of one cube's factors on the basis of the factor values of other cubes. The factor calculation formulas are stored in a special table.

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

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

The multidimensional calculation wizard opens.

The wizard for multidimensional calculation on DB server contains a number of basic pages described in the Working with Wizards section.

The Properties page is used to select the database where the calculation should be executed.

The Sources page is used to form a list of standard cubes, which data will be used in calculation.

The Structure page is used to select destination cube and to fix dimensions.

The Formulas Table page is used to select the table that stores calculation formulas.

The Manage Parameters page is used to pass parameter values to open objects used in multidimensional calculation.

Parameters controlling of those dimensions are set up using another cube dimensions on the Controlling Dimensions page.

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 after one of the following operations is executed for selected multidimensional calculation:
- Select the Run context menu item.
- Double-click.

Executing any of these actions opens the Calculation Options dialog box.