Options dialog: Query Governor tab

Use this tab to specify how Discoverer uses summaries and performs queries.

Note: Do not change these options unless advised to do so by the Discoverer manager.

For more information, see:

"What are summaries?"

"What are worksheets?"

Summary Data

When do you want to use Summary data?

Use these options to specify when you want Discoverer to use summaries. The table below describes options available.

Query Governor

Use these options to specify how Discoverer handles queries.

• Warn me if predicted time exceeds

  Use this check box to display a warning when the predicted query times exceed the time that you define in the box on the right. The estimated query time is displayed so that you can choose whether to continue. If the wait time is too long, you can schedule the workbook to run at a later time. For example, you might want to schedule the workbook to run overnight so that it is ready to open in the morning.

• Prevent queries from running longer than

  Use this check box if you do not want to run queries when the predicted query time exceeds the time that you define in the box on the right.

• Limit retrieved query data to

  Use this check box to not retrieve more than the number of rows that you define in the box on the right.

• Retrieve data incrementally in groups of

  Use this field to define how many rows to retrieve from the database at once.

  The value you enter cannot be greater than the value of the MaxRowsPerFetch setting, defined by the middle tier administrator in the file pref.txt. For more information, see Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer.

• Cancel list of values retrieval after

  Use this field to define the maximum time you want to wait while Discoverer retrieves list of values items.

Notes

• If the Retrieve data incrementally in groups of value is greater than or equal to the Limit retrieved query data to value, only one retrieval increment is fetched from the database.