Cached Value List Clarification
This knowledge article doesn't clarify for me how the "Value List Setup" options work: https://community.yellowfinbi.com/knowledge-base/article/filter-format-cached-values-on-demand
Can someone please explain how these options work in the context of report maintenance over time? I have several fields that I want to filter on that are semi-static, meaning I expect these values to change infrequently (1-4 times per year). Re-fetching the list each time I open a report will be wasteful 95% of the time relative to having a cached list. But if I do go with the cached list and the values do change (those 1-4 times per year), does that mean I will have to edit dozens of reports and manually refresh the cache on every filter?