How to refresh data connections after the load.
I have a dashboard that has a number of real time performance measures but also contains a WTD component.
My issue is that accessing the data from the operational system for all figures for the WTD takes longer then I would like to have the users wait for the dashboard to load.
What I would like to do is load only those figures for the current day using refresh on load but trigger the other connection to refresh after the dashboard is displayed. However I do not wish to run the query more then once as the WTD figures won't change and hence don't want to us the refresh every _ seconds/min
Any suggestions would be much appreciated