Build large reports
If you are building Interactive Reports with a large amount of data, you might find that it is quicker to build the report if the data is not constantly refreshing or returning a large number of rows. You can manually refresh the report to view your results at any point in the process.
When you are done designing the report, run the full data set by scheduling the report. See Schedule Reports.
You can limit how often you query the data while building your report to help reduce the amount of time required to refresh the report. Use the options in the Query Settings dialog box to adjust refresh times while you are building your report.
In the Data tab, click the Settings icon in the upper-right corner to open the Query Settings dialog box. Make changes as needed and close the dialog box when you are done.
Turn off auto-refresh
Design your report layout first, including calculations and filtering, without querying the database. Clear the Auto-Refresh option in the Query Settings dialog box.
Turn off auto-refresh mode to reduce the number of queries sent to the data source. Use it when the data source responds slowly.
When your layout is ready, turn Auto-Refresh back on. Data retrieval runs once and your report displays results.
Distinct values
By default, Interactive Reports queries data with the SQL SELECT DISTINCT statement when no GROUP BY is used. SELECT DISTINCT returns only distinct values. It can require an extensive sorting operation in the database.
To stop returning distinct values, clear Select Distinct in the Query Settings dialog box. This setting is saved with your report.
If you are an administrator, right-click the toolbar and select View SQL. Check whether DISTINCT is included.
To clear Select Distinct by default for new reports, ask your system administrator. See the Administer Pentaho Data Integration and Analytics document.
Row limits and query timeouts
Limit the number of rows displayed while designing your report. Set Row Limit options in the Interactive Toolbar.
Limit how long a query runs. Select Query Timeout in the Query Settings dialog box and specify seconds.
Row limits and timeouts help avoid out-of-memory errors. They also reduce load on the database server.
If you exceed the system maximum row limit, a help message appears.
To change the system maximum row limit, ask your system administrator. See the Administer Pentaho Data Integration and Analytics document.
Last updated
Was this helpful?