cancel
Showing results for 
Search instead for 
Did you mean: 

Derive Input Parameter Value from preceding Input Parameter

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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