How can custom reports be examined in order to determine how much data they will return?

Environment:

Analytics, Analyzing report output

Resolution:

The report analyzer is designed to check the queries that a custom report makes on a site's database. This tool helps your custom reports run as quickly and efficiently as possible.

The report analyzer examines your report and provides suggestions as to how you can improve it by removing database tables, add­ing filters, and making other changes. The analyzer also shows you the estimated number of rows the report’s query may need to access so you know if the report can run without encountering row limits.  Please note, this is an estimate only and the estimated number of rows can actually be much higher due to aggregate functions for example.  The analyzer cannot return the exact number of rows because this would require it to run the entire query (which would defeat the purpose of analyzing the report before running it).
 

Report analyzer button in the ribbon

Para obtener información adicional, consulte la sección 'Troubleshoot Reports with the Report Analyzer' en la documentación en línea para la versión que su sitio está ejecutando actualmente. Para acceder a los manuales y la documentación en línea de Oracle B2C Service, consulte la Documentación de los productos de Oracle B2C Service.