1. Analytical Application Infrastructure User Guide
  2. Unified Analytical Metadata
  3. References
  4. Measure Types
  5. Simple Relationship
  6. Time-Series Function

Time-Series Function

The Time Series type measures are time dependent. The Time Series types are:

  • Aggregation type – This option computes the estimate of the periodical performance on a period-to-date basis.
  • Rolling Average – This option computes the average for the previous N values based on the given dynamic value (N).This dynamic range could vary from a period of three months to any number of months.

Aggregation Type Option

  1. Select the Aggregate option.
  2. Select the measure from the Select the Measure pane. Depending on the Information Domain you are logged in to, the measures for that domain are displayed in the pane.

Rolling Average Option

  1. Select the Rolling Average option.
  2. Enter the rolling average in the Select the number of periods for which to calculate the rolling average field.

    Note:

    The duration/period refers to the number of periods with respect to the current level in the time dimension of the chosen cube i.e. if the Current Value of the time dimension + the previous X values (where 'x' is 10 as you have specified) / 10 +1.
  3. Select the measure from the Select the Measure pane. Depending on the Information Domain you are logged in to, the measures for that domain are displayed in the pane.