Cache dashboard results to improve performance when switching tab?
Hi folks: I am searching for suggestions to improve reporting performance in dashboards.
We have a couple of simple, executive dashboards that consist of 5-10 tabs of cube views. These work great for managing a common set of reports for end users. Parameters are managed within the dashboard and persist when switching cube views (tabs); all that works great.
However, users complain that it is slow to switch between cube views (tabs). It appears that each cube view is re-run when switching tabs rather than simply displaying the data that was previously refreshed. While most reports take <2 seconds to run, a few can take in the 8-15 second range which is deemed unacceptable.
Are there any methods (formal or hacked together) for caching cube view results so that switching tabs simply displays already refreshed data rather than re-running the cube view?
Thanks, -db