Badly designed DMI reports may execute slowly, even on systems running within the capacity limits defined in the sizing guidelines.
To create fast and efficient DMI reports, refer to the following guidelines:
Try to use the same subject data for all sections in the report. Control visibility of metrics on the Result Display tab.
Do not create reports containing unnecessary metrics and dimensions, or reports that display unnecessary data fields.
There are no specific limits for the number of metrics or dimensions used by a report. However, avoid making the reports more complicated than is required for the analysis you need to perform.
Do not create reports spanning unnecessarily long time intervals.
There are no specific limits for the length of the time interval covered by a report. However, avoid reporting on time intervals that are longer than is required for the analysis you need to perform.
Do not create reports with long, complicated filters for text dimensions.
Filtering for text dimensions requires additional resources.
Enable report pre-generation at night for reports that need to be accessed every day, but which cover longer time periods.
Use metrics and dimensions that are maintained in memory cache.
Avoid using metrics that cause long report generation time. This includes any of the user counter metrics.