Skip Headers
Previous
Previous
 
Next
Next

Cumulative Maximum

Returns a running maximum value from a range of consecutive time periods.

Template

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.

Example

This calculated measure returns the maximum number of Units from the last period to the current period within a parent.

Calculation

Cumulative maximum of UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy within parent. Total from current to following member.

OLAP Expression Syntax

MAX(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.CALENDAR BETWEEN CURRENT MEMBER AND UNBOUNDED FOLLOWING WITHIN PARENT)

Query Results

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