Behavior of filter values "cached on demand"

Bogdan Kiselitsa shared this question 2 years ago
Answered

Hi, can someone please explain how this setting works?


What constitutes "on demand", and and how is it different to "manual" cache refresh?


Thanks

Best Answer
photo

Hi Bogdan,


Thanks for your query on the post:


In the Filter settings when you choose


Cached Values On Demand - Yellowfin will create a list of values by loading the contents of the field each time the report is loaded.

Cached Values - Yellowfin will create a list of values by caching the current contents of the field in the database.


Let me know if you have any questions or if this is not clear.


Regards,


Mahe

Comments (6)

photo
1

Hi Bogdan,


Thanks for your query on the post:


In the Filter settings when you choose


Cached Values On Demand - Yellowfin will create a list of values by loading the contents of the field each time the report is loaded.

Cached Values - Yellowfin will create a list of values by caching the current contents of the field in the database.


Let me know if you have any questions or if this is not clear.


Regards,


Mahe

photo
1

Hi,


Thanks for the clarification.


How does this work with relation to dependent filters?


i.e. If filter B has parent filter A, then are the values of B refreshed every time the selection of A changes? Or does this happen just once once per report load?


Cheers,

Bogdan.

photo
1

Hi Bogdan,


All possible value combinations are loaded when the report is opened.

So when changing values, it won't need to refresh the list.


Please let us know you have further questions on this.


Regards,

David

photo
1

I have filter values that might change 4-5 times per year. I don't want to take the performance hit of reloading the filter values every time the report loads, so I want to use cached, not cached on demand?

But what happens when my filter values do change? Do I need to manually edit dozens of reports and recache them all manually? Is Yellowfin smart enough to use a shared cache across all of the reports so I only have to manually update one?

photo
1

Hi Stephen Johnson,

Thanks for reaching us.

You can schedule the caching of the values and doesn't have to edit the report all the time.

Please click here for more information on Filter Refresh types

Hope this helps.

Please let me know if you have any questions.

Regards,

Mahesh

photo
1

Hi Stephen Johnson,

Hope you are doing well.

I will mark this as completed for the moment.

If you have any questions please reply back.

Regards,

Mahesh