Redesigning Analyzer Reports for Maximum Performance
Once you have an idea of what you want to show with your Analyzer report, you will almost certainly have to redesign it to be more performant. Because an Analyzer report is basically a hierarchical list of actions, the order in which fields and filters are added to the report can make a big difference in query response time. Even though this does not change the report's graphical output, what happens behind the scenes can make that output display more quickly.
When you re-create your reports, follow this process for best performance:
- Add and filter by low-cardinality dimensions first
- Add measures to the report
- Add high-cardinality dimensions last
When filtering, always choose include/exclude over contains/doesn't contain.