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?