Forum Discussion

Marco's avatar
Marco
Contributor II
11 months ago

CV Scenario PY dynamic

Hi everyone.

I’m working on a cube view, and I have a variable that handles the scenario, and I want another column to have the PY of that selected scenario, so if you could help me know how this can be done.

Example for the scenario to modify.

 

Cube View
Parameters
  • CMBPM's avatar
    CMBPM
    11 months ago

    Hi Marco, you could try utilizing this time filter by comma delimiting your current column time or adding a new column:

    T#YearPrior1(|!PLN_ParamTimeYr!|)Period(|!PLN_ParamTimeYr!|)

    This will give you the period you have select for your parameter in its prior year. This would include if you input 2023, it will return 2022. If you input 2023M6, it will return 2022M6, etc. 

    CMBPM

     

  • CMBPM's avatar
    CMBPM
    New Contributor II
    11 months ago

    Hi Marco, you could try utilizing this time filter by comma delimiting your current column time or adding a new column:

    T#YearPrior1(|!PLN_ParamTimeYr!|)Period(|!PLN_ParamTimeYr!|)

    This will give you the period you have select for your parameter in its prior year. This would include if you input 2023, it will return 2022. If you input 2023M6, it will return 2022M6, etc. 

    CMBPM