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

Drop down Box in Excel planning workbook should pass values to Query variables

Hi All,

There are variables defined in the Bex query for the Excel planning book. I would like to pass values to this variables from the Planning work book. As of now the drop down box will filter only on the Posted values, MD table and Dimension table.

Is there any way which user can choose values ( Like drill down) and pass values into the variables .


Satish M

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Mar 05, 2015 at 08:15 AM

    Hi Satish,

    no, this is not possible, because after changing a variable, the query would have to read fresh data from the server (make a so called server round trip).

    This is all included in calling the variable pop up, change the variable values there and refresh the whole workbook.

    This can be done by the yellow button in the menu or you can create a button in the workbook to call the variable pop up.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 05, 2015 at 01:47 AM

    Hi Satish,

    The entered value should at least exist in MD table. If it is not, it will be considered as an invalid value and it is not possible to enter any new transaction data for it either.

    Best Regards,

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Satish,

      if you want to have this behaviour for variable - you have to define an exit which changes the values in F4 help - search for this here and in the bex forum, there are several threads about this.

      if you want to have this behaviour for filter values inside the workbook, change the settings for the info objects to show filter values according to navigation state - but this will not be good for performance.



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.