CV Scenario PY dynamic

[Marco]

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.

[CMBPM · Accepted solution]

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