Skip Headers
Previous
Previous
 
Next
Next

Cumulative Minimum

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

Template

Cumulative minimum 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 minimum number of Units from the last period to the current period within a parent.

Calculation

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

OLAP Expression Syntax

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

Query Results

The Minimum column shows the minimum 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 includes more years than are shown.

Time   Parent   Units   Minimum
------ -------- ------- -------
Q1.05  CY2005    143607  138096
Q2.05  CY2005    138096  138096
Q3.05  CY2005    138953  138953
Q4.05  CY2005    145062  145062
Q1.06  CY2006    146819  143572
Q2.06  CY2006    145233  143572
Q3.06  CY2006    143572  143572
Q4.06  CY2006    149305  149305
2005   TOTAL     565718  565718
2006   TOTAL     584929  584929