Skip Headers
Previous
Previous
 
Next
Next

Future Period

Returns the value of a later time period at the same level.

Template

Future period for measure measure (...) in the time dimension and time hierarchy hierarchy number period ahead.

Example

This calculated measure returns the value of the next time period.

Calculation

Future period for measure UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy 1 period ahead.

OLAP Expression Syntax

LEAD(UNITS_CUBE.UNITS,1) OVER HIERARCHY (TIME.CALENDAR)

Query Results

The Next Period column shows Units for the next time period.

Time   Level                 Units Next Period
------ ------------------- ------- -----------
Q1.04  CALENDAR_QUARTER     146529      143070
Q2.04  CALENDAR_QUARTER     143070      148292
Q3.04  CALENDAR_QUARTER     148292      149528
Q4.04  CALENDAR_QUARTER     149528      143607
Q1.05  CALENDAR_QUARTER     143607      138096
Q2.05  CALENDAR_QUARTER     138096      138953
Q3.05  CALENDAR_QUARTER     138953      145062
Q4.05  CALENDAR_QUARTER     145062      146819
2004   TOTAL                587419      565718
2005   TOTAL                565718      584929