Home > OLAP Calculation Templates > Prior and Future Periods > Prior Period
![]() Previous |
![]() Next |
Returns the value of an earlier time period at the same level.
Prior period for measure measure (...) in the time dimension and time hierarchy number period ago.
This calculated measure returns the value of Units for the previous time period.
Prior period for measure UNITS(...) in the TIME dimension and TIME.CALENDAR hierarchy 1 period ago.
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