Home > OLAP Calculation Templates > Cumulative Aggregates > Cumulative Maximum
![]() Previous |
![]() Next |
Returns a running maximum value from a range of consecutive time periods.
Cumulative maximum 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 returns the maximum number of Units from the last period to the current period within a parent.
Cumulative maximum of UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy within parent. Total from current to following member.
MAX(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.CALENDAR BETWEEN CURRENT MEMBER AND UNBOUNDED FOLLOWING WITHIN PARENT)
The Maximum column shows the maximum number of Units from the last quarter to the current quarter in calendar years 2005 and 2006, and from the last year to the current year. The calculation returns more years than are shown.
Time Parent Units Maximum ------ -------- ------- -------- Q1.05 CY2005 143607 145062 Q2.05 CY2005 138096 145062 Q3.05 CY2005 138953 145062 Q4.05 CY2005 145062 145062 Q1.06 CY2006 146819 149305 Q2.06 CY2006 145233 149305 Q3.06 CY2006 143572 149305 Q4.06 CY2006 149305 149305 2005 TOTAL 565718 584929 2006 TOTAL 584929 584929