Skip to Content

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

Filter 3 querys with 1 selection

Hi all,

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.

Former Member
Former Member replied

Hi,

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.

Regards

YY

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