Managing Formulas

In the drop-down list select the dimension, which attribute will control formula actual period selection.

Select the controlling attribute in the drop-down list.

Select the checkbox if formulas should be cached on first cube calculation. This will speed up subsequent cube recalculations.

Select the checkbox if it is required to calculate formulas by physical data. This enables the user to calculate formulas not by the entire selection, but by physical data, which speeds up calculation.

When this checkbox is selected, take into account the following restriction: if a formula uses the expression, which value is shifted several points backward or forward, the values are calculated in the selection, for which the matrix contains data for selection, from which the data is shifted. That is, the value is not calculated if:

• Any source matrix value after the offset is not included in the current selection.

• The current selection value must be calculated from the source matrix that goes beyond the current selection.