Skip Headers
Previous
Previous
 
Next
Next

Difference from Future Period

Returns the difference between the current value and a value of a later time period at the same level.

Template

Difference from future period for measure (...) in the time dimension and time hierarchy hierarchy number period ahead.

Example

This calculated measure returns the difference in Units between the current time period and the next time period.

Calculation

Difference from future period for UNITS(...) in the TIME dimension and TIME.CALENDAR hierarchy 1 period ahead.

OLAP Expression Syntax

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

Query Results

The Change column shows the difference between the current time period and the next time period. A Future Period calculation computes the values in the Next Period column.

Time   Level                  Units Next Period Change
------ -------------------- ------- ----------- ------
Q1.04  CALENDAR_QUARTER      146529      143070   3459
Q2.04  CALENDAR_QUARTER      143070      148292  -5222
Q3.04  CALENDAR_QUARTER      148292      149528  -1236
Q4.04  CALENDAR_QUARTER      149528      143607   5921
Q1.05  CALENDAR_QUARTER      143607      138096   5511
Q2.05  CALENDAR_QUARTER      138096      138953   -857
Q3.05  CALENDAR_QUARTER      138953      145062  -6109
Q4.05  CALENDAR_QUARTER      145062      146819  -1757
2004   TOTAL                 587419      565718  21701
2005   TOTAL                 565718     584929-  19211