Home > OLAP Calculation Templates > Cumulative Aggregates > Cumulative Average
![]() Previous |
![]() Next |
Calculates a running average across a range of consecutive time periods.
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.
This calculated measure computes the average number of Units at each level from the first time period to the current period.
Cumulative average of UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy within level. Total from beginning to current member.
AVG(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.CALENDAR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN LEVEL)
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