Using Relative Time Periods

For rows and columns, you can use these keywords to select a period relative to the current POV:

• @Cur

• @First

• @Last

• @Next

• @Prev

  Note:

  Year and period values are not case sensitive.

For example, if the period selected in the POV is January, the column or row that is created using this formula displays data for February:

P#CUR+1

For the system to apply the relative year when the period extends past the current year, or if you need to refer to a prior year, you must specify Y#@Cur as part of the row or column definition.

For example, you need to specify C1=Y#@Cur.P#@Cur(+1) to return the correct year if the current period is the last period. If the current Point of View is 2013 December: C1=Y#@Cur.P#@Cur(+1) returns 2014 January.

If the current Point of View is 2013 December: C2=P#@Cur(+1) returns 2014 January (if January is the first period in the year, and December is the last). Therefore, for the system to correctly reflect the year information, you specify the year in the column definition. For example, C2=Y#@Cur.P#@Cur(+1)

The @CUR function can be used for other dimensions to retrieve the current POV. However, @CUR for the other dimensions does not support using an offset, for example, +2, since the other dimensions are not chronological. For example, if the current POV had the Actual scenario, a valid example for a column would be to use C1=S#@CUR to return "Actual". If you changed the POV scenario to Budget, this same column definition would return "Budget".