Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Script logic in packages: take variables from package

Hi all,

I have a package where the user must select Time dimension member. I know that the selected value is saved in the variable %TIME_SET%. Imagine the user select 2015.JUN. I would like to run a script for all months of 2015, but I don't know how to code the selection of the year of the member selected by the user in the package.

I have tried using %YEAR%, but it does not work, as %YEAR% is the year of the temporal registers, not the year selected in the package.

Any idea?

Best regards,

Fernando

Tags:
replied

Hi Fernando,

TID_RA=%YR%.01,%YR%.02,%YR%.03,...,%YR%.12



Or:


*SELECT(%YMONTHS%,"[ID]",TIME,"[YEAR]=%YR% AND [CALC]='N'")

TID_RA=%YMONTHS%


Vadim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question