Home > OLAP Calculation Templates > Parallel Period > Difference from Parallel Pe...
![]() Previous |
![]() Next |
Calculates the difference between the current value and a prior parallel period.
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.
The following template calculates the difference in values between the current period and the parallel period in the previous year.
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.
LAG_VARIANCE(UNITS_CUBE.UNITS,1) OVER HIERARCHY (TIME.CALENDAR BY ANCESTOR AT LEVEL TIME.CALENDAR.CALENDAR_YEAR POSITION FROM BEGINNING)
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