Calendar parameters can be set up for all types of operands except for operands based on dimension elements. The data source should also contain a calendar dimension.
If a data source contains several calendar dimensions, the dimension is used, for which the Timeline type is specified.
Calendar frequency can be changed only in the desktop application and is used to change operand frequency without its editing. Frequency changing is relevant if the calendar dimension of data source contains several frequencies.
To change calendar frequency of operand:
Select the Frequency item in the operand's context menu.
Select operand frequency in the menu that opens. The menu contains all calendar frequencies of data source and the From Selection item selected by default. This item enables the user to automatically determine operand frequency based on the selection made in the calendar dimension. For example, a data source has the annual and quarterly frequencies. When an operand is inserted, the 1 Quarter 2018 element is selected in the calendar dimension. Therefore, the operand has the quarterly frequency.
As a result, the selected calendar frequency will be used for the operand.
Changing time lag of operand enables the user to shift all its data by the specified number of points in the time interval. For example, all its data can be shifted 2 years back.
To change time lag of the operand:
Double-click the operand or select the Edit item in the operand's context menu. It opens in edit mode. For example:
{-|-|Federal State Statistic Service data|-[t]}
Put the cursor before the closing square bracket.
Enter time lag value. If the lag value is:
Positive. Data is shifted backward.
Negative. Data is shifted forward.
As a result, the lag is set for the data, for example:
{Data or Russian Federal State Statistics Service[t+1]}
Example of operand data before and after time lag is changed
When working with operands take into account the following calendar features:
If a function that uses operands with equal calendar parameters is used in the expression, correspondence of the following parameters is checked before calculation:
Calculation frequency.
Data series start date.
Data series length.
Week start day. Only for operands with weekly or daily frequency.
Days off. Only for operands with daily frequency.
Calculation is executed only if all operand parameters are equal, otherwise an error message is displayed.
In the Time Series Analysis tool, calendar frequency of operands must match the calendar frequency of expression. If the expression requires operands with the calendar frequency that is different from the expression's calendar frequency, use aggregation functions.
For example, there is an energy loss formula with monthly frequency:
{Months|Energy consumption by Russian Federation entity|[t]} * {Years|Energy loss|[t]} / {Years|Energy consumption by Russian Federation entity|[t]}
The operands {Years|Energy loss|[t]} and {Years|Energy consumption by Russian Federation entity|[t]} have the annual frequency. To correctly calculate them, their data must be interpolated from the annual to quarterly frequency by means of the Interpolate function:
{Months|Energy consumption by Russian Federation entity|[t]} * Interpolate({Years|Energy loss|[t]} / {Years|Energy consumption by Russian Federation entity|[t]},MsInterpolateType.Repeat_,MsFrequency.Monthly)
See also: