Home > OLAP Calculation Templates > Moving Aggregates > Moving Minimum
![]() Previous |
![]() Next |
Returns the smallest value among a fixed number of consecutive time periods surrounding the current period.
Moving minimum of measure (...) in the time dimension and time hierarchy hierarchy. Include number preceding and number following members within { level | parent | ancestor at level level | Gregorian level }.
This calculated measure returns the smallest number of units from within a range of three time periods: the current period and the next two periods.
Moving minimum of UNITS(...) in the TIME dimension and TIME.CALENDAR hierarchy. Include 0 preceding and 2 following members within level.
MIN(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.CALENDAR BETWEEN CURRENT MEMBER AND 2 FOLLOWING WITHIN LEVEL)
The Minimum column shows the smallest number of units between the current quarter and the two following quarters.
Time Level Units Minimum ------ -------------------- ------- ------- Q1.05 CALENDAR_QUARTER 143607 138096 Q2.05 CALENDAR_QUARTER 138096 138096 Q3.05 CALENDAR_QUARTER 138953 138953 Q4.05 CALENDAR_QUARTER 145062 145062 Q1.06 CALENDAR_QUARTER 146819 143572 Q2.06 CALENDAR_QUARTER 145233 143572 Q3.06 CALENDAR_QUARTER 143572 143572 Q4.06 CALENDAR_QUARTER 149305 149305