SAP Help Site

Hi,
I made a workbook with 4 queries. And yes it loads the queries bottom up (meaning the latest query you attached will be the first to load).
However, there is a workaround for this. open your VB Editor (Alt+F11), look on the left side for the sapbexqueries worksheet, click it and you will see the visibility property, set it to Visible so you can see it in excel.
The first table here contains all your queries that are in your workbook. When you refresh all queries, it loads from the bottom upwards. So, what you could do is place the one you want to load first on the bottom then go up. Take note of the row of your queries before you move them (e.g. 1st query is in row 4). After you move them, take note again of row numbers (e.g. 1st query now in row 6) then change all the succeeding tables (still in sapbexqueries worksheet, scroll right to find the other tables)
you will see the first column of every table contains numbers. These are the references for which queries they are 4 (e.g. the value 4 means it is for the query on row 4). So if you move 1st query from row 4 to row 6, you must change the values here as well from 4 to 6. Same goes with SAPBEXfilters worksheet as well I think.
For more information, try searching ITtoolbox with keywords “sap bw multiple queries”, that’s where I found all the answers.
Although what I’m trying to find out right now is when I refresh all the queries, and the first one returns no value, I want all queries to stop refreshing already. Does anyone know how to do this?
Thanks,
Ian
—–Original Message—–
Hello,I have five queries in a workbook. I want the firstthree queries to run based on the value I input in theselection criteria but the last two queries should runautomatically there after. I can’t change the order inwhich the queries execute.Is there a way to achieve this? Appreciate your help.RJ
‘Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity…..’ __.____._

_.____.__