1. Modeling
  2. Work with data
  3. Filter data
  4. Optimize filter performance

Achieve optimum performance with your filters when you follow best practice.

To achieve optimum performance and reduce the time it takes a module to load:

  • Evaluate your filters to see if they still produce meaningful results. Remove any filter that is no longer useful.
  • Do not filter line items with a line item summary. A numeric filter on 10,000,000 items can take less than a second, but a summary takes at least 5 seconds.
  • Limit the filters applied to nested dimensions on rows. The nested filter is slower on the same number of items compared to a flat list. A filter applied to a 10 by 1,000,000 nested dimension compared to a 10,000,000 item list is 40% slower.
  • Use a single Boolean filter on a line item that does not have time or versions applied and does not have a summary. This enables you to reuse the line item and combine a series of Boolean line items into a single Boolean to use in a filter. This increases speed.
  • Check the saved view open time to see the impact on the import performance and adjust the filter if possible. Filter duration affects saved views used in imports.
  • If you need to repeatedly filter for specific list items, create a subset of list items and then a new module to view a set of data.