Setting execution time limits for a data mart report

You can set the execution time limits for a data mart report. You can set the following performance parameters for data mart report execution:

• The maximum time to be allowed for table execution

• The maximum number of rows to be read into the analytical engine at one time

To set execution time limits for data mart reports

1. If the Report Data Mart Setup dialog box is not displayed, open it. For steps to open it, see Data mart tools: Report Data Mart Setup dialog box.

2. Select the Advanced tab on the Report Data Mart Setup dialog primary window.

3. In the entry window next to Maximum execution time (sec), under Governing, enter the number of seconds to be allowed before a query for this report times out.

4. In the entry window next to Maximum number of rows (Analytical Engine), under Governing, enter the maximum number of rows to be sent to the analytical engine at one time during report generation.

5. Click OK to exit the dialog box.

Related Topics

• About data mart reports

• Creating and editing column aliases in data mart reports

• Deleting definitions from data mart reports

• Entering custom SQL statements for a data mart table

• Selecting a database instance for a data mart table

• Setting table creation properties for a data mart report

• Data mart editors

For additional information, see the Advanced Reporting Help.