Skip to Content
avatar image
Former Member

Pass Values for Time in transformation file

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

im.JPG (39.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 06, 2016 at 11:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2016 at 06:03 AM

    What is the source of your records?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2016 at 04:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded