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

Bex 3.5 : hide variable screen popup running SAPBEXrefresh

Hi all,

We need to create a simple tool specifying a file list of excel workbooks containing queries to be refereshed.

Thanks to the doc of "boeke" and the precious Peter Knoer's posts, I've done the following :

> log on BW,

then for each workbook in the specified file list,

> open workbook,

then for each query of the opened workbook ,

> get Variables from the "SAPBEXqueries" worksheet

> Run SAPBEXsetVariables ("Memory and reuse variable values" option is ticked on)

> Run SAPBEXrefresh

..and so on

Everything works fine, except that each time the SAPBEXrefresh runs, the variable screen pops up with the "free caracteristics" input. I've nothing to input in there : and if click on the run button (F8), it continues correctly.

How can I get rid off this variable screen popup from the refresh process ?

Thanks in advance for all your helps,


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2012 at 02:15 PM


    If you don't want the pop-up of variable screen you can uncheck the Variable is Ready for Input checkbox in the [Details|] tab of the variable in the query designer.

    Hope this helps...



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 05, 2012 at 08:35 AM

    Hi sylsyl ,

    I guess you need variable screen at starting level. but when you refrest result set it should not show.

    if it is the requirement, you will have two different buttons to refresh.

    1) variable refresh

    2) normal refresh

    Instead of using normal resfresh you might use variable refresh.

    so please use normal refresh. it will be solved.



    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.