Calculated Elements

Calculated items use the user-defined formula to get the value, which can be based on dictionary source elements.

The calculated element is considered to be the following:

Aggregating element.
Calculation of intermediate totals and totals.
Calculation of MDX expression to measure ADOMD cubes.

To edit a calculated element formula, select it on the side panel, table or in the Total Dimension list of the Edit Dimension dialog box:

Select the Element > Edit Formula or Edit Formula in the element's context menu.
Click the Edit Formula button in the Edit Dimension dialog box.
Click the Edit Formula button in the Element group on the Hierarchy ribbon tab.

To edit the formula of dimension calculated element, the Expression Editor dialog box opens.

To set up calculation by edited data without preliminary data saving to the source, Setting Up Formula Calculation is used.

NOTE. Calculated elements are calculated automatically by defined formulas, without possibility to edit them manually.

Calculation Chain

To change the order of formula calculation, use the Calculation Chain dialog box.

To display the Calculation Chain dialog box

The dialog box has the Aggregation Calculation and Totals Calculation sections. The formula calculation order can be changed within the Aggregation Calculation and Totals Calculation. The Totals Calculation is always below the Aggregation Calculation section. Calculation of calculated elements can be set before these elements and between them. Calculated element formulas are added into the Calculation Chain before the Aggregation Chain section. By default, formulas are calculated as they are added.

NOTE. Changing of formula calculation order in the Totals Calculation item may cause changing of totals result.

If the Aggregation Calculation item is not the first one, if the From Source Dimensions aggregation type, it will become the the first in the calculation chain; the user is informed about changing the order of elements in the calculation chain, aggregation is executed first, then all the other elements based on aggregation results are calculated. Clicking the OK button applies the set aggregation type and changes the order of items in the calculation chain.

The dialog box enables the user to execute the following operations with formulas:

Use the and buttons to edit the order of formula calculation.
On calculating formulas, empty values may be considered as zeros. To do this, select the Treat Empty Values as Zeros checkbox. This is important, for example, on calculating average values.
To calculate formulas by elements, which contain data, select the Calculate by Data Only checkbox.

TIP. To calculate formulas by elements, which contain data, select the Calculate by Data Only checkbox.

To set up formulas, click the Edit button. The Expression Editor.
To delete the selected formula, click the Delete button.
To change formula calculation order taking into account their dependency, click the Default button. If calculation of one element depends on calculation of other element, calculation of the dependent element is located before in the calculation chain, clicking the Default button