Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.