Home > OLAP Calculation Templates > Parallel Period > Parallel Period
![]() Previous |
![]() Next |
Returns the value of a prior parallel period.
{ 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.
This calculated measure returns values from the previous quarter for calendar quarters and months.
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.
LAG(UNITS_CUBE.UNITS,1 ) OVER HIERARCHY (TIME.CALENDAR BY ANCESTOR AT LEVEL TIME.CALENDAR.CALENDAR_QUARTER POSITION FROM BEGINNING)
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