I have a user who has a WebI R2 report which contains 5 queries from different data sources. When refreshed, each query takes approximately 3 minutes, making 15 minutes in total.
They feel that this is too long, and as only 1 of the data sources is refreshed frequently, they would like to be able to choose that that one query to refresh. I know they can do this in WebI, however they only access InfoView.
I would be grateful for any ideas of how best to do this. We are migrating to R3 SP3 in Q1 of 2011 if this helps?