Home > OLAP Calculation Templates > Prior and Future Periods > Future Period
![]() Previous |
![]() Next |
Returns the value of a later time period at the same level.
Future period for measure measure (...) in the time dimension and time hierarchy hierarchy number period ahead.
This calculated measure returns the value of the next time period.
Future period for measure UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy 1 period ahead.
The Next Period column shows Units for the next time period.
Time Level Units Next Period ------ ------------------- ------- ----------- Q1.04 CALENDAR_QUARTER 146529 143070 Q2.04 CALENDAR_QUARTER 143070 148292 Q3.04 CALENDAR_QUARTER 148292 149528 Q4.04 CALENDAR_QUARTER 149528 143607 Q1.05 CALENDAR_QUARTER 143607 138096 Q2.05 CALENDAR_QUARTER 138096 138953 Q3.05 CALENDAR_QUARTER 138953 145062 Q4.05 CALENDAR_QUARTER 145062 146819 2004 TOTAL 587419 565718 2005 TOTAL 565718 584929