Skip Navigation
Expand
Using the report analyzer with custom reports
Answer ID 2844   |   Last Review Date 02/24/2020

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

Report analyzer button in the ribbon

 

For additional information, refer to the 'Troubleshoot Reports with the Report Analyzer' section in the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.