Limit a Report's SQL Per Pass

You can limit a report's SQL size per pass. This includes limits on the amount of time that each pass can take and the maximum size (in bytes) that the SQL statement can be. These limits are set in the VLDB properties, as described below. For more information about VLDB properties in general, see SQL Generation and Data Processing: VLDB Properties

You can also limit the amount of memory that Intelligence Server uses during report SQL generation. This limit is set for all reports generated on the server. To set this limit, in the Project Configuration Editor, open the Governing Rules: Default: Result Sets category, and specify the Memory consumption during SQL generation. A value of -1 indicates no limit.

SQL Time Out (Per Pass) (Database Instance and Report)

You can limit the amount of time that each pass of SQL can take within the data warehouse. If the time for a SQL pass reaches the maximum, Intelligence Server cancels the job and the user sees an error message. You can specify this setting at either the database instance level or at the report level.

To specify this setting, edit the VLDB properties for the database instance or for a report, expand Governing settings, then select the SQL Time Out (Per Pass) option.

Maximum SQL Size (Database Instance)

You can limit the size (in bytes) of the SQL statement per pass before it is submitted to the data warehouse. If the size for a SQL pass reaches the maximum, Intelligence Server cancels the job and the user sees an error message. You can specify this setting at the database instance level.

To specify this, edit the VLDB properties for the database instance, expand Governing settings, then select the Maximum SQL Size option.