Selecting Calculated Element and Calendar Frequency

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:

    1. Click the dimension's drop-down list on the calculated element panel. The list of dimension elements opens.

    2. Select the element for each dimension in the list.

    1. Click the Add Dimension button at the right part of the calculated element panel. The list of filtered dimensions will be displayed.

    2. Select the dimension. The selected dimension will be displayed on the calculated element panel.

    3. Click the dimension's drop-down list on the calculated element panel. The list of dimension elements opens.

    4. 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.

Selecting Calendar Frequency

Select the formula calculation calendar frequency in the Frequency Step drop-down list on the calculation options panel:

If the Set Calculation Period switch is toggled to the active state, the formula is calculated at each calendar frequency step within the specified algorithm calculation period. If the switch is toggled to the inactive state, frequency step affects the offset of dates specified taking into account the number of periods.

See also:

Setting Up Calculation Formulas | Generating Calculation Formula