Skip Headers
Previous
Previous
 
Next
Next

Difference from Parallel Period

Calculates the difference between the current value and a prior parallel period.

Template

Difference from { parallel period | parallel period closest } for measure (...) in the time dimension and time hierarchy hierarchy number time level ago based on position from { beginning to end | end to beginning } of period.

Example

The following template calculates the difference in values between the current period and the parallel period in the previous year.

Calculation

Difference from parallel period for UNITS(...) in the TIME dimension and TIME.CALENDAR hierarchy 1 TIME.CALENDAR.CALENDAR_YEAR ago based on position from beginning to end of period.

OLAP Expression Syntax

LAG_VARIANCE(UNITS_CUBE.UNITS,1) OVER HIERARCHY (TIME.CALENDAR BY ANCESTOR AT LEVEL TIME.CALENDAR.CALENDAR_YEAR POSITION FROM BEGINNING)

Query Results

The Diff column shows the difference between the current value of Units and the value of the preceding year. The calculations compare 2006 to 2005, Q1.06 to Q1.05, Q2.06 to Q2.05, and so forth.

Time   Level                  Units Last Year   Diff
------ -------------------- ------- --------- ------
Q1.05  CALENDAR_QUARTER      143607    146529  -2922
Q2.05  CALENDAR_QUARTER      138096    143070  -4974
Q3.05  CALENDAR_QUARTER      138953    148292  -9339
Q4.05  CALENDAR_QUARTER      145062    149528  -4466
Q1.06  CALENDAR_QUARTER      146819    143607   3212
Q2.06  CALENDAR_QUARTER      145233    138096   7137
Q3.06  CALENDAR_QUARTER      143572    138953   4619
Q4.06  CALENDAR_QUARTER      149305    145062   4243
2005   CALENDAR_YEAR         565718    587419 -21701
2006   CALENDAR_YEAR         584929    565718  19211