Skip Headers
Previous
Previous
 
Next
Next

Percent Difference from Parallel Period

Calculates the percent difference in values between the current time period and a prior parallel period.

Template

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.

Example

This calculated measure computes the percent difference between the current period and the parallel period in the previous year.

Calculation

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.

OLAP Expression Syntax

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

Query Results

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