Skip Headers
Previous
Previous
 
Next
Next

Moving Minimum

Returns the smallest value among a fixed number of consecutive time periods surrounding the current period.

Template

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 }.

Example

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.

Calculation

Moving minimum of UNITS(...) in the TIME dimension and TIME.CALENDAR hierarchy. Include 0 preceding and 2 following members within level.

OLAP Expression Syntax

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

Query Results

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