Skip Headers
Previous
Previous
 
Next
Next

Parallel Period

Returns the value of a prior parallel period.

Template

{ 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 returns values from the previous quarter for calendar quarters and months.

Calculation

Parallel period for UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy 1 TIME.CALENDAR.CALENDAR_QUARTER ago based on position from beginning to end of period.

OLAP Expression Syntax

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

Query Results

The Last Qtr column shows the value of the parallel period in the previous quarter. 2006 is null because the calculation is performed only within calendar quarters, that is, at the CALENDAR_QUARTER and MONTH levels. The calculation returns Q1.06 for Q2.06, Q2.06 for Q3.06, JAN-06 for APR-06, FEB-06 for MAY-06, and so forth.

Time    Level                  Units Last Qtr
------- -------------------- ------- --------
2006    CALENDAR_YEAR         584929     null
Q1.06   CALENDAR_QUARTER      146819   145062
JAN-06  MONTH                  47776    47476
FEB-06  MONTH                  47695    47496
MAR-06  MONTH                  51348    50090
Q2.06   CALENDAR_QUARTER      145233   146819
APR-06  MONTH                  47005    47776
MAY-06  MONTH                  52809    47695
JUN-06  MONTH                  45419    51348
Q3.06   CALENDAR_QUARTER      143572   145233
JUL-06  MONTH                  48388    47005
AUG-06  MONTH                  48830    52809
SEP-06  MONTH                  46354    45419
Q4.06   CALENDAR_QUARTER      149305   143572
OCT-06  MONTH                  47411    48388
NOV-06  MONTH                  46842    48830
DEC-06  MONTH                  55052    46354