Many execution of a query with different selections in the same work book
I have a workbook with one query that show sales of a plant. User can select many plants, but he doesn't like it, too easy. In this way query shows all the plant in the same sheet and he want a sheet for each plant.
The most simply way to do this is making a query for each plant with a filter with the plant as a constant. Then I put all that queries in the workbook. But this is not too smart, right?
Frédéric GAUTHIER replied
Yes, the solution I talked about is running the query each time you've a plant ... But the choice has to be done also by the user, HE is asking for a sheet per plant, you can do it, but at a price !
The other solution could be to have only 1 query in one hidden sheet, and to spread the results in different sheets, by using visual basic.
The solution preconised in the previous answer is to have only 1 screen for all the variables of all the queries, it's by default in BW 3.5, but it's not really answering your need.
Edited by: Frédéric GAUTHIER on Sep 19, 2008 1:21 PM