Comparing Frequency Levels

The rule compares values by calendar frequency levels, if data source is standard cube with calendar dimension or time series database with several calendar frequency levels.

NOTE. Comparison of two and more time series by various calendar frequency levels is available, if values of all time series mandatory attributes matches and calendar frequency differs.

To set up the rule:

  1. Set general parameters of the rule.

  2. Set initial calendar level and level used for comparison. Use the Apply to Level and Compare with Level drop-down lists.

NOTE. Calendar frequency of the compared level should be greater that frequency of the level used for comparison.

Features of working with drop-down lists

  1. Set aggregation data method in the Comparison Method drop-down list.
    Data aggregation is performed from the level set in the Compare with Level list to the level set in the Apply to Level list.
    Available aggregation methods:

  1. Set frequency of time series observation change between different levels. Use the If the Value parameter group:

See also:

Setting Up Validation Rule