Skip to Content
avatar image
Former Member

SAP BO dashboard: Dynamic trigger for multiple Bex queries based on global filters selection by user

Hi Dashboard experts. Sorry for writing so long but I am facing stuck and cannot figure out how to trigger different queries on the basis of different global filters selection.

There are 4 Combo boxes for global filters namely Calendar year/month, Country, Product, Department, . Data is coming from Bex queries and having prompts as mentioned in global filters.

Now I have 3 charts which needs to refresh on different set of global filter selection and on click of refresh button(toggle button). 3 charts are based on 3 different Bex queries.
1st chart- Calendar year/month, Country filters

2nd chart- Calendar year/month, product, department filters

3rd chart- product, department filters

Now requirement is whenever user changes some value in calendar year/month and product and department and clicks on refresh button then only 1st and 2nd chart query should trigger refresh. In the same way if user changes only product and click on refresh then only 2nd chart and 3rd chart query should trigger refresh, 3rd chart query should not trigger refresh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers