Skip to Content

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

Control order of single refresh of multiple query workbook

Hello,

I have a workbook which contains 3 queries. The selections variables are as follows:

- Query 1: Date, unit of measure

- Query 2: Date

- Query 3: Date, unit of measure, currency

The number of selection screens which I have to execute depends in which order the browser executes the queries. If it selects query 1 first, the selection screen for query 2 won’t appear (as the range of dates is taken from query 1 selection screen). The selection screen for query 3 appears but with only the field currency (the dates and unit of measure are taken from query 1 selection screen).

Is it possible to control the order in which the browser executes the queries when I do a refresh all? i.e. if query 3 is executed first I will only have to execute one selection screen, the values for the other two will be taken automatically.

Thank you

Simon

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question