Forum Discussion

db_pdx's avatar
db_pdx
Valued Contributor
9 months ago

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 f...
Cube View
Dashboards
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
9 months ago

yep, sounds pretty typical.  And probably a good reason for all.
I'd be looking to pre-calc those variances into stat accts.  Usually no need to calc them every time the CV loads.  It might be surprising how much that helps.

I agree with you, it would be nice to cache parts of the dashboard so every click isn't a full round trip reload to the server