I have a dashboard using multiple BEX queries. Iam using Query prompt selector to select "Calendar month which is BETWEEN", "Region is EQUAL".
So, first I select Calendar month(Start month, End month) and then the Region. Region has Apply button. Before I select Region itself, based on Calendar month's (Query Prompt Selector's) Properties,all the queries are getting refreshed. Each query internally triggers the other queries since for all the queries Calendar month and Region are the prompts. So, to select Region, I need to wait for a long time. That makes the User impatient.
I want to know if there is any property of Query Prompt selector I could use so that refresh does not happen automatically until I choose a Region and click on Apply button.
Any help is highly appreciated.