Skip Headers
Previous
Previous
 
Next
Next

Cumulative Average

Calculates a running average across a range of consecutive time periods.

Template

Cumulative average of measure (...) in the time dimension and time hierarchy within { level | parent | ancestor at level level | Gregorian level }. Total from { beginning to current | current to following | beginning to following } member.

Example

This calculated measure computes the average number of Units at each level from the first time period to the current period.

Calculation

Cumulative average of UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy within level. Total from beginning to current member.

OLAP Expression Syntax

AVG(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.CALENDAR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN LEVEL)

Query Results

The Average column shows the average number of Units from the first period to the current period. All quarters in the analytic workspace are calculated together in the Calendar Quarter level range, and all years are calculated in the Calendar Year level range. The calculation includes more quarters and years than are shown.

Time   Level                  Units Average
------ -------------------- ------- -------
Q1.05  CALENDAR_QUARTER      143607   103239
Q2.05  CALENDAR_QUARTER      138096   104401
Q3.05  CALENDAR_QUARTER      138953   105515
Q4.05  CALENDAR_QUARTER      145062   106751
Q1.06  CALENDAR_QUARTER      146819   107965
Q2.06  CALENDAR_QUARTER      145233   109062
Q3.06  CALENDAR_QUARTER      143572   110048
Q4.06  CALENDAR_QUARTER      149305   111138
2005   CALENDAR_YEAR         565718   427005
2006   CALENDAR_YEAR         584929   444552