The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
db_pdx
2 years agoValued Contributor
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...
tomdarnall
2 years agoNew Contributor III
So radio buttons should only refresh the page you're on...whereas tabs try to refresh everything. This is where I think it could provide some time savings for you.
When you set up the component, you define the buttons options with a param. Typically I'd just use a param type = delimited list. The param can be hardcoded with the various options, or can contain variables if you want the list to be dynamic based on other selections.
- db_pdx2 years agoValued Contributor
Understood. I should clarify, the issue is not with making parameter selections. That is handled at the start. After the user sets their appropriate reporting dimensions, they won't change.
It's about a user navigating to the P&L to review something, then to the balance sheet (8-15 to display it), then back to the P&L, and back to the balance sheet (another 8-15 seconds because it doesn't cache the result and re-runs the CV), all within the same overall dashboard.
- tomdarnall2 years agoNew Contributor III
Gotcha, yeah...unfortunately I don't think the radio buttons natively prevent a re-running of the CV.
Related Content
- 5 months ago
- 8 months ago
- 6 months ago