Skip to Content
0
May 28, 2018 at 10:11 AM

Is it possible to read user id dynamically in DM script and pass it on logic script?

161 Views Last edit May 28, 2018 at 10:31 AM 2 rev

Hi Experts,

Is it some way possible to read the user id of the user executing a data manager package then concatenate it with a char string and pass that concatenated value to a logic script?

For example, currently i have the below script (partial declaration part only), where $INPVERSION$ is a DM Input variable, which is reading input from the user say, "USER123456". Here "123456" is the user id of the user executing the package and "USER" is just a text string appended before. "USER123456" is a member ID of the version dimension.

Script :

*SELECT(%STEAVERS%,"[STEAVERS]",VERSION,"[ID]= $INPVERSION$") *SELECT(%SBCVERS%,"[SBCVERS]",VERSION,"[ID]= $INPVERSION$") *SELECT(%FFYEAR%,"[FFYEAR]",VERSION,"[ID]= $INPVERSION$") *SELECT(%LFYEAR%,"[LFYEAR]",VERSION,"[ID]= $INPVERSION$") *SELECT(%FYEARALL%,"[ID]",TIME,"[ID]>=%FFYEAR% AND ID<=%LFYEAR%") *SELECT(%LAYEAR%,"[LAYEAR]",VERSION,"[ID]= $INPVERSION$") *SELECT(%FYEARLAG%,"[ID]",TIME,"[ID]>=%LAYEAR% AND ID<=%LFYEAR%") *SELECT(%FYEARNXT%,"[ID]",TIME,"[ID]>%FFYEAR% AND ID<=%LFYEAR%")

The above is working fine with DM input variable as explained but the objective is to avoid the DM input and make it dynamic through combination of DM script and Logic script.

I hope i have been able to explain.

Any ideas?