When creating a calculation formula, elements of data consumer dimension are used as a calculated element.
The panel of calculated elements is used to determine an element, which values are calculated by a formula:
To show or hide the calculated element panel, click the Output Variable button.
The panel displays non-filtered dimensions by default, which are not selected in the list of data consumer dimensions. Such dimensions are mandatory and are marked with the * character. One can select an element for a filtered dimension, by which calculation will be executed regardless of the selected filtering, on the Consumer page in the calculation block or control block editing wizard.
To select a dimension element:
From non-filtered dimension:
Click the dimension's drop-down list on the calculated element panel. The list of dimension elements opens.
Select the element for each dimension in the list.
From filtered dimension:
Click the Add Dimension button at the right part of the calculated element panel. The list of filtered dimensions will be displayed.
Select the dimension. The selected dimension will be displayed on the calculated element panel.
Click the dimension's drop-down list on the calculated element panel. The list of dimension elements opens.
Select the element in the list for each added dimension.
After executing the operations the calculated dimension element will be selected.
Next, generate a calculation formula.
Select the formula calculation calendar frequency in the Frequency Step drop-down list on the calculation options panel:
Annual.
Semi-annual.
Quarterly.
Monthly.
Weekly.
Daily.
Formula calculation depends on the Set Calculation Period switch:
If the switch is toggled to active state, the formula is calculated at each calendar frequency step within the specified algorithm calculation period.
If the switch is toggled to inactive state, frequency step affects the offset of dates specified taking into account the number of periods.
If calculation formula calendar frequency differs from operand calendar frequency, after the formula is calculated, data will be calculated by formula calculation frequency. For example, if the formula has monthly calculation frequency, and the operand has annual frequency, data will be calculated by months.
See also:
Setting Up Calculation Formulas | Generating Calculation Formula