Home > OLAP Calculation Templates > Cumulative Aggregates > Cumulative Minimum
![]() Previous |
![]() Next |
Returns a running minimum value from a range of consecutive time periods.
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.
This calculated measure returns the minimum number of Units from the last period to the current period within a parent.
Cumulative minimum of UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy within parent. Total from current to following member.
MIN(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.CALENDAR BETWEEN CURRENT MEMBER AND UNBOUNDED FOLLOWING WITHIN PARENT)
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