Skip Headers
Previous
Previous
 
Next
Next

Difference from Prior Period

Returns the difference between the current value and the value of an earlier time period at the same level.

Template

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

Example

This calculated measure compares the current value of Units with the value of the previous period.

Calculation

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

OLAP Expression Syntax

LAG_VARIANCE(UNITS_CUBE.UNITS,1) OVER HIERARCHY (TIME.CALENDAR)

Query Results

The Change column shows the difference in Units between the current period and the previous period. A Prior Period calculation computes the Last Period column.

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