Multiple Variable selection filtering for BEx queries

[Former Member]

I created a web template which accesses three BEx queries. I have the same variable in all three queries so when I run the report, it pulls the data from all three queries correctly. BUT, when I change the filtering criteria within the report, only one of the query results changes, but not the other two. My question is: Is there a way to link all three queries so I can change the filtering criteria only once and have it affect all three?

[Former Member]

Hi,

Let us consider you have 3 data providers DP1,DP2,DP3 based on 3 different queries.

You need to specify the following property in all the Table, Navigational Block and filter to make the same variable navigate through all the queries,

<param name="TARGET_DATA_PROVIDER_1" value="DP1"/>

<param name="TARGET_DATA_PROVIDER_2" value="DP2"/>

<param name="TARGET_DATA_PROVIDER_3" value="DP3"/>

Hope this helps

Arun

[Former Member]

I read the documentation you pointed me to, but I do not think this is what I'm looking for. I would like to filter by different criteria once I'm within the report and have the filters change all three queries at the same time.

For example, all my queries have a variable for 0plant. If I select 5 plants from the variable selection screen and then run the report, I will get results for all 5 plants in all three queries. Then if I filter by three of those 5 plants from the navigation block (which only points to query #1), then only query #1 changes, while the other two queries remain with the 5 plants.

Does the personalization allow this variable to be linked together?

[former_member188975]

Hi Danae,

You could try using check boxes for the 0PLANT values, and use the TARGET_DATA_PROVIDER attribute to select the list of data providers to which all checkbox commands are sent.

Hope this helps...

[Former Member]

Reading one Query variable(values) reflects in other query

are come under personalization.

this link give some idea...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/help/sdn_nw04/saphelp_nw04...

Regards,

Vijay