Skip to Content
avatar image
Former Member

Derive Input Parameter Value from preceding Input Parameter

Hi everyone,

In BW there is an option of using an object called Variable with Replacement Path. The idea is that if I have two Input Parameters, once I select one Input Parameter manually, the second Input Parameter derives the value from the first one. In an example it would look like this.

1. User selects a Month in a first Input Parameter (visible to him through a Front end tool)

2. From the month selected in first Input Parameter, the Second Input Parameter (hidden from user) derives the last day and it is used as a filter for underlying Calculation view.

Any advise how to make it work?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 21, 2015 at 04:20 AM

    Hi Kuatroka,

    I had a similar requirement, and I implemented in the following way. There might be are options which someone can share here.

    To my understanding I don't think we could do the calculation for the second input parameter in the graphical calc view. So what you can do is ,

    • Create a scripted calc view and get the first input parameter from the user using this view
    • Do the calculations for the second input parameter inside the scripted calc view
    • Then pass these two input parameters to the original graphical calc view by calling the same inside the scripted calc view

    Regards,

    Monissha

    Add comment
    10|10000 characters needed characters exceeded