Next period relative time members
The following next period members are available to add to a relative time dimension:
- Next Period
- Next Period to Date
- Next Period to Date Change
This member is derived from Next Period to Date - Period to Date
- Next Period to Date % Growth
This member is derived from Next Period to Date Change / Period to Date * 100
In all cases, Period is the level type that is defined for the hierarchy, for example Year or Semester.
These members have a fixed offset from the current period of +1. For example, if the current month is November, the next month is December.
Consider the following Time dimension and Sales fact tables. The current quarter is 201303.
| Year | Quarter |
|---|---|
| 2012 | 201201 |
| 2012 | 201202 |
| 2012 | 201203 |
| 2012 | 201204 |
| 2013 | 201301 |
| 2013 | 201302 |
| 2013 | 201303 |
| 2013 | 201304 |
| 2014 | 201401 |
| 2014 | 201402 |
| 2014 | 201403 |
| 2014 | 201404 |
| Quarter | Sales |
|---|---|
| 201201 | 3 |
| 201202 | 4 |
| 201203 | 5 |
| 201204 | 6 |
| 201301 | 7 |
| 201302 | 8 |
| 201303 | 9 |
| 201304 | 10 |
| 201401 | 11 |
| 201402 | 12 |
| 201403 | 13 |
| 201404 | 14 |
The value of 'Year to Date (2013)' is 24. This value is derived from 'aggregate(currentMeasure within set periodsToDate(Year, 201303))'.
The value of 'Prior Year to Date (2012)' is 12. This value is derived from 'aggregate(currentMeasure within set periodsToDate(Year, parallelPeriod(Year,1, 201303)))'.
The value of 'Next Year to Date (2014)' is 36. This value is derived from 'aggregate(currentMeasure within set periodsToDate(Year, parallelPeriod(Year,-1, 201303)))'.
The value of 'Year to Date Change' is 12. This value is derived from 'Year to Date' - 'Prior Year to Date'.
The value of 'Next Year to Date Change' is 12. This value is derived from 'Next Year to Date' - 'Year to Date'.
The value of 'Next Year to Date % Growth' is 50%. This value is derived from 'Next Year to Date Change' / 'Year to Date' * 100.