We are using AF 3.0.2 with a lot of BO full client reports to display on the dashboard. But, it is taking up to 2 minutes to display a tab with 4 reports after they have been refreshed in the repository. After taking the initial hit of loading into cache the tab opens in a few seconds. Does anyone know of a macro that can be run to take the initial hit. We are in the process of installing/testing 6.5 and I know it has a caching feature, but in the mean time I need some help! Management is getting annoyed!
How 'bout if you setup a small “hidden” analytic on the bottom of your front page … it would load the 4 tab report in 1st, then when the user clicks on the 4 tab report, it would already be cached
You could also break the report into smaller pieces or buy more hardware