Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Many execution of a query with different selections in the same work book

Hi all,

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?

Any suggestion?

Former Member
Former Member 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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question