Filter 3 querys with 1 selection
I have a workbook with 3 queries that use the same structure, the 3 have set the same Filter valuer (Fiscal Period), is there a way to add a filter option that affects the 3 queries at the same time? if so, can someone please help me to do it?
Thanks in advance.
Yuanyuan Gao replied
You mentioned that your 3 queries with the same structure have the same Filter value (Fiscal Period). Is this fiscal period a variable or fix value? If the queries are all restricted to the same variable (I mean the technical name of the variable) and when you enter the value in the variable dialog during executing the workbook, all the query results must already be affected by the selection. (in BEx 7.0)
If you want to select the fiscal period in the workbook manually, you can insert a design item, e.g. dropdown box, which has been assigned to 3 Data Provider (your 3 queries).
Hope it's helpful.