Skip to Content
0
Jul 13, 2015 at 04:14 PM

Dynamic operations with Variable in DM Advanced Script

86 Views

Hi,

I have created a custom DM Packages for copy all the dimension from one version to another.

I want to minimize the input from the final user and i set only one Prompt to get the YEAR.

The script:

PROMPT(COMBOBOX,%YEAR%,Insert Year:,1,,{2015,2016,2017,2018,2019,2020})

INFO(%Q1%,.Q1)

INFO(%Q2%,.Q2)

INFO(%Q3%,.Q3)

INFO(%Q4%,.Q4)

.....

TASK(/CPMB/CM_CONVERT................TIME_DIMENSION|%YEAR%%Q1%,%YEAR%%Q2%,%YEAR%%Q3%,%YEAR%%Q4%||....................

.....

This work fine for me, but i need to copy the data for 3 YEAR.

Example:

User Input 2015 | Copy 2015/2016/2017 - V1 to 2015/2016/2017 - V2

Is there a way to create a variabile like INFO(%YEAR_1%,%YEAR% + 1) ?

If there is no way with script, what is the best way to perform my requisite(Logic Script/Badi) ?

Thanks,

Angelo.