Skip to main content
M
Marco
January 24, 2024
Solved

CV Scenario PY dynamic

  • January 24, 2024
  • 1 reply
  • 0 views

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

 

Best answer by CMBPM

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

C
CMBPMAnswer
January 24, 2024

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

 

Terms & ConditionsAccessibility statement