Automatically caching reports that will be viewed in AF

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!


riccoa (BOB member since 2004-07-20)

You may want to try the caching solution from SolvCentral it is called SolvCache (www.solvcentral.com)


i_amit123 :india: (BOB member since 2002-10-09)

Hi Al (Welcome),

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

HTH


Chris Pohl :us: (BOB member since 2002-06-18)