Skip Headers
Previous
Previous
 
Next
Next

Prior Period

Returns the value of an earlier time period at the same level.

Template

Prior period for measure measure (...) in the time dimension and time hierarchy number period ago.

Example

This calculated measure returns the value of Units for the previous time period.

Calculation

Prior period for measure UNITS(...) in the TIME dimension and TIME.CALENDAR hierarchy 1 period ago.

OLAP Expression Syntax

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

Query Results

The Last Period column shows the value of Units for the previous time period.

Time  Level                  Units Last Period
----- -------------------- ------- -----------
Q1.05 CALENDAR_QUARTER      143607      149528
Q2.05 CALENDAR_QUARTER      138096      143607
Q3.05 CALENDAR_QUARTER      138953      138096
Q4.05 CALENDAR_QUARTER      145062      138953
Q1.06 CALENDAR_QUARTER      146819      145062
Q2.06 CALENDAR_QUARTER      145233      146819
Q3.06 CALENDAR_QUARTER      143572      145233
Q4.06 CALENDAR_QUARTER      149305      143572
2005  TOTAL                 565718      587419
2006  TOTAL                 584929      565718