Pass Values for Time in transformation file

[former_member398742]

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

[david_ings]

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

[former_member186338]

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

[former_member186338]

What is the source of your records?

[former_member398742]

Csv File

[former_member186338]

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

[Former Member]

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