Home > OLAP Calculation Templates > Parallel Period > Percent Difference from Par...
![]() Previous |
![]() Next |
Calculates the percent difference in values between the current time period and a prior parallel period.
Percent 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.
This calculated measure computes the percent difference between the current period and the parallel period in the previous year.
Percent 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_PERCENT(UNITS_CUBE.UNITS,1) OVER HIERARCHY (TIME.CALENDAR BY ANCESTOR AT LEVEL TIME.CALENDAR.CALENDAR_YEAR POSITION FROM BEGINNING)
The Pct Diff column shows the percent difference between the current period and the equivalent period in the previous year. A Parallel Period calculation generates the values of the Last Year column. The calculations compare 2006 to 2005, Q1.06 to Q1.05, Q2.06 to Q2.05, and so forth.
Time Level Units Last Year Pct Diff ------ -------------------- ------- ---------- -------- Q1.05 CALENDAR_QUARTER 143607 146529 -.02 Q2.05 CALENDAR_QUARTER 138096 143070 -.03 Q3.05 CALENDAR_QUARTER 138953 148292 -.06 Q4.05 CALENDAR_QUARTER 145062 149528 -.03 Q1.06 CALENDAR_QUARTER 146819 143607 .02 Q2.06 CALENDAR_QUARTER 145233 138096 .05 Q3.06 CALENDAR_QUARTER 143572 138953 .03 Q4.06 CALENDAR_QUARTER 149305 145062 .03 2005 CALENDAR_YEAR 565718 587419 -.04 2006 CALENDAR_YEAR 584929 565718 .03