Presenter Adaptive filters
In Incentives, you can optimize filter performance by adhering to the following guidelines:
Recommendations
Case sensitivity: When filtering reporting objects, it is crucial to turn on the Case sensitive toggle. This is because disabling the toggle causes the underlying queries to use UPPER(FilterValue) = UPPER(ColumnValue), which invalidates indexes and forces a full table scan. Full table scans can significantly degrade performance, especially on larger data sources.
Default settings: The Case sensitive toggle is enabled by default for all new filters. However, for existing filters created prior to this release, it's recommended to review and enable the toggle wherever possible to enhance performance.
