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 informações adicionais, consulte a seção 'Troubleshoot Reports with the Report Analyzer' na documentação on-line para a versão que seu site está executando no momento. Para acessar os manuais e a documentação on-line do Oracle B2C Service, consulte a Documentação para produtos Oracle B2C Service.