Skip to Content
author's profile photo Former Member
Former Member

Using filter values in planning functions

Hi experts!

Is it possible to somehow pass the values users set in query filters (during query execution) into the planning function and use them there as variables?

Thanks!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 03:20 PM

    Hello,

    I think it is possible.

    Please follow the steps

    1) Create query with only one characteristic ( WHich you want to use in Planing funnction)

    2) Create variable with replacement path using above query name.

    3) Use above variable in filter.

    4) read variable value using varv(Variable name)

    Thanks

    With regards,

    Anand Kumar

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Anand,

      Thanks a lot for your reply.

      But how to process multiple values set in the filter? Is it possible to pass all of them into the planning function and process them as an array or set of values (like FOR EACH ... DO)?

      Best regards,

      Andrey

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 06:33 AM

    Hello Andrey

    In planning function type formula use Foreach in variable. The same variable use at WAD sequence properties. Choose selection binding for DP that has link with your filter.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 09:16 AM

    Hello, Andrey.

    U can use function VARI instead of VARV. So it will be an array of values.

    Regards, Igor.

    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.