Best Practices for Interactive and Analyzer Reports

To improve the performance of Analyze reports, Data Platform makes the following recommendations:

1.

Disable “auto-refresh,” build your report, and “refresh” it when you are done (see Disabling Auto Refresh Mode in Analyzer Reports, and Disabling Auto Refresh Mode in Analyzer Reports). When you proceed this way the queries are sent only once to the Server and the Database. This method is recommended when you know beforehand which attributes and measures are to be included in your report. However, when exploring interactive data, you may have to leave “auto-refresh” enabled. If that is the case, we suggest you follow the recommendations provided in point #2 as often as possible.

2.

When building reports, consider dragging the dimensional attributes first, and adding the measures last. Adding measures typically involves aggregation operations such as count, sum, and averaging. When used at the beginning of your report building session, aggregation operations must be recalculated each time you add another dimensional attribute, triggering aggregations and group-by operations that incur costly and time-consuming processing cycles on your database.

Open topic with navigation