Question Re: Use a prompt in a transformation file in Financial Management Q&A

Use a prompt in a transformation file

Former Member — Fri, 04 Mar 2016 15:35:57 GMT

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?

Re: Use a prompt in a transformation file

former_member186338 — Fri, 04 Mar 2016 17:29:34 GMT

Hi Paul,

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

Vadim

Re: Use a prompt in a transformation file

former_member186338 — Fri, 04 Mar 2016 17:35:21 GMT

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

Re: Use a prompt in a transformation file

Former Member — Sat, 05 Mar 2016 22:01:21 GMT

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.