Product Documentation
Abstract
When you create a hierarchy for a time-based dimension, next period relative time members are now available.
Content
When you create a hierarchy for a time-based dimension, the following next period relative time members are now available:
- 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 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 table. The current quarter is 201303.
Time dimension
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 |
Sales fact table
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 is derived from 'aggregate(currentMeasure within set periodsToDate(Year, 201303))'.
The value of 'Prior Year to Date (2012)' is 12.
This is derived from 'aggregate(currentMeasure within set periodsToDate(Year, parallelPeriod(Year,1, 201303)))'.
The value of 'Next Year to Date (2014)' is 36.
This is derived from 'aggregate(currentMeasure within set periodsToDate(Year, parallelPeriod(Year,-1, 201303)))'.
The value of 'Year to Date Change' is 12.
This is derived from 'Year to Date' - 'Prior Year to Date'.
The value of 'Next Year to Date Change' is 12.
This is derived from 'Next Year to Date' - 'Year to Date'.
The value of 'Next Year to Date % Growth' is 50%.
This is derived from 'Next Year to Date Change' / 'Year to Date' * 100.
Predefined relative time members in virtual cubes
All relative time members are inherited from the single source cube that supplies the current period.
Relative time calculated members
The following relative time members behave the same as the Current Period, Prior Period, Current Period to Date and Prior Period to Date members:
- Next Period
- Next Period to Date
The following relative time members behave the same as the Period to Date Change and Period to Date Growth relative time calculated members:
- Next Period to Date Change
- Next Period to Date % Growth
For information on including next period relative time members in a hierarchy, see http://www.ibm.com/support/docview.wss?uid=swg27041029.
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cube Designer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27040513