New predefined relative time members in IBM Cognos Cube Designer 10.2.1.1 Fix Pack 3

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.