User should be able to "hard" refresh a cached report

Michael Johansen shared this idea 4 months ago
Idea Logged

When caching has been enabled at view-level (fx. 60 minutes) the report content will stay cached even if the underlying data has been updated meanwhile. For most cases that is fine and the purpose with caching. Though, in some cases it is a big problem for the user to wait until the cache has been released in case they need latest data.

For that reason I suggest the user should be able to manually "hard" refresh the cached data which should result in a new DB query and update the cached values for another 60 minutes.

That could easily be done with an integrated button at report and dashboard level.

Comments (3)

photo
1

Hi Michael,


Thank you for your suggestion.


One point here to make is that Cached Filters can be hard refreshed via the Admin Console > Schedule Management page. Ideally, the User would know which Cached Filters they are refreshing, which is where I can see this Idea benefitting. Another thing to note is that the appropriate role functions should be put in place to make sure only authorised Users can perform this action, as it could cause the server to run poorly if run at a bad time.


/1417ff5f1337b29ce29031621b412755


Before becoming a request, ideas will be reviewed by our Product Team and chosen for Enhancements based on feasibility, level of positive impact to the user experience, and votes from the community.


This post will be updated with any future information relevant to this process.


Kind regards,

Simon

photo
1

Thanks Simon

It is not cached filters I’m refering to but instead cached report. 

First time you load a report the dataset is cached and cannot be changed for the next 60 minutes even though the underlying data has changed. 

The end user should be able to reset/refresh the entire report dataset. It could be done via a standard button on report level and Dashboard level. 

Br

Michael

Den 18. jun. 2021 kl. 03.27 skrev Yellowfin Support <support@yellowfin.bi>:



photo
1

Hi Michael,


Thanks for the clarification, apologies for my misunderstanding. I've gone ahead and amended the task to reflect your comments. It doesn't seem that you can re-cache the View from the Schedule Management page either, meaning there doesn't look to be a way around this behaviour.


I will keep you updated with any changes.


Kind regards,

Simon