Question Re: Pass Values for Time in transformation file in Financial Management Q&A

Pass Values for Time in transformation file

Former Member — Wed, 06 Apr 2016 20:25:19 GMT

Hi Peoples,

I am wondering if we can pass parameters in transformation file while running Transformation file or DM Package.

Let say below is my transformation file and fixed the time i.e TIME = *STR(2016.INP) , is there any way to have prompt to change values for time later *STR(2015.INP)

Thanks,

Vishu

Re: Pass Values for Time in transformation file

Former Member — Wed, 06 Apr 2016 23:47:44 GMT

Hi Vishu,

Standard BPC transaction data load doesn't allow prompts.

What do you want to achieve?

maybe you can use conversion files and use the first 4 char from time, so 2015* will be 2015.INP and so on.

Andy

Re: Pass Values for Time in transformation file

former_member186338 — Thu, 07 Apr 2016 06:03:49 GMT

What is the source of your records?

Re: Pass Values for Time in transformation file

Former Member — Thu, 07 Apr 2016 16:31:41 GMT

Csv File

Re: Pass Values for Time in transformation file

former_member186338 — Thu, 07 Apr 2016 16:43:01 GMT

And you have no time column in this file? Or something like...?

Re: Pass Values for Time in transformation file

david_ings — Thu, 07 Apr 2016 16:50:54 GMT

Hi Vishu,

One way around this is to send the data in the transformation file to a dummy dimension member, then some logic is run which puts it onto the "correct" time member (which can then therefore be dynamic using properties etc).

This can work nicely in a package link - e.g. so you first load in the transaction data (to the dummy member), then the final step in the package link moves it across to the new time member dynamically.

David

Re: Pass Values for Time in transformation file

former_member186338 — Thu, 07 Apr 2016 17:01:26 GMT

It depends on dimension members used in the flat file... Single dummy member for time dimension can be not enough...