Script Logic partial variable

[Former Member]

Hi

We have requirement, the requirement is, User run package by selecting Time as "FY2018" or else "FY2019". Here "FY" prefix is fixed and year changes. Now from Dynamic script this variable pass to Script logic. In Script logic is there any chance to get partial value only YEAR i.e 2018 or 2019, ie FY to eliminate.

XDIMMEMBERSET TIME = FY%TIME%. (here %TIME% pass from Dynamic script

Regards

Siluklien

[former_member186338]

Instead of selecting Time member in DM package prompt, use COMBOBOX with a list of years.

Please read my blog: https://blogs.sap.com/2014/09/19/dm-promptcombobox-behavior-in-bpc-nw-10-and-75/

something like:

PROMPT(COMBOBOX,%Y%,"Select Year",0,2018,{2018,2019,2020,2021,2022})
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,Y%EQU%%Y%)
...

Then in script logic you will use variable $Y$ containing Year

*XDIM_MEMBERSET TIME = FY$Y$
...