You can use these year and period functions:
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 2008 December: C1=Y#@Cur.P#@Cur(+1) returns 2009 January.
If the current Point of View is 2008 December: C2=P#@Cur(+1) returns 2009 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”.