Skip Headers
Previous
Previous
 
Next
Next

Percent Difference from Future Period

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

Template

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

Example

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

Calculation

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

OLAP Expression Syntax

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

Query Results

The Pct Change column shows the percent difference between the current time period and the next period. A Future Period calculation computes the values of the Next Period column, and a Difference From Future Period calculation computes the values of the Change column.

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