Use a prompt in a transformation file

[Former Member]

I have set up a package to import transaction data from a flat file (CPMB/IMPORT). It works perfectly if I designate the destination member in the version dimension in the transformation file:

Version=FORECAST004

However, I would prefer that the user supplies this during the import so I don't need to keep maintaining the transformation file. I have used the SELECT Prompt() Command in the Prompt SECTION of the dynamic script editor to assign the user's selected version to the variable %DESTVER%. Now I would like to use that variable in the transformation file:

Version=*NEWCOL(%DESTVER%)

But the transformation file doesn't recognise the variable. It tries to write to a member called "%DESTVER%".

Is there a way I can achieve this?

[former_member186338 · Accepted solution]

Hi Paul,

It's not possible. You can't pass the information from DM advanced script prompt to the transformation file!

Vadim

[former_member186338 · Accepted solution]

But if you create routine badi and use it in the transformation file you can read DM package parameters inside badi...

[Former Member · Accepted solution]

Thanks Vadim. I'm not authorised to create BADIs, but it's good to know I can't otherwise pass variables to transformations files. I can stop looking.