Skip Headers
Previous
Previous
 
Next
Next

Percent Difference from Prior Period

Returns the percent difference between the current value and the value of an earlier time period.

Template

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

Example

This calculated measure computes the percent difference between the current value of Units and the value for the previous time period.

Calculation

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

OLAP Expression Syntax

LAG_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 previous time period. A Prior Period calculation computes the values of the Last Period column, and a Difference From Prior Period calculation computes the values of the Change column. The calculations include more quarters and years than are shown here.

Time   Level                  Units Last Period  Change  Pct Change
------ -------------------- ------- ----------- ------- -----------
Q1.05  CALENDAR_QUARTER      143607      149528   -5921        -.04
Q2.05  CALENDAR_QUARTER      138096      143607   -5511        -.04
Q3.05  CALENDAR_QUARTER      138953      138096     857         .01
Q4.05  CALENDAR_QUARTER      145062      138953    6109         .04
Q1.06  CALENDAR_QUARTER      146819      145062   1757          .01
Q2.06  CALENDAR_QUARTER      145233      146819  -1586         -.01
Q3.06  CALENDAR_QUARTER      143572      145233  -1661         -.01
Q4.06  CALENDAR_QUARTER      149305      143572   5733          .04
2005   TOTAL                 565718      587419  -21701        -.04
2006   TOTAL                 584929      565718   19211         .03