Q1: I have three different queries that the users want on different tabs in the same workbook. Is there a way to do that?
Q2: I cannot make the 'Selection' pop up box to open up whenever I open the workbook. I have checked all the basic things I need to check.
A fellow developer sent me this answer:
You can always have multiple queries in one workbook. All you need to do is to go at each and every tab and insert the query. Save your workbook on the server.
Once you will refresh your workbook, system will prompt you with the necessary variable window for all 3 queries at a time.
If you are using BI7.0, you might not see the refreshed value, if "refresh at open" is not set for the workbook. You have to click on the button, which will open a variable window and then you can refresh the data in your workbook.
I hope this would help !!
My follow up question:
Danny, thanks for the answer. I was not able to find the steps to insert the query in each tab. If possible can you (or anyone else reading this) list the steps in some if not a lot of detail. Thanks again.