Skip to main content
Contributor
Jan 24, 2024 5:25 PM UTC
Solved

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.

Marco_0-1706117047009.png

 

CMBPMAnswer
Newcomer
Jan 24, 2024 6:45 PM UTC

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

 

1 reply

CMBPMAnswer
Newcomer
Jan 24, 2024 6:45 PM UTC

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