Options dialog: Query Governor tab

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

For more information, see:

"What are summaries?"

"What are worksheets, workbooks, and queries?"

Summary Data

When do you want to use Summary data?

Use this pull down list to specify when you want Discoverer to use summaries:

Option	Use to
Always, when available	Specify that you want Discoverer to use summaries automatically where possible.
Only when summary data is not out of date (stale)	Specify that you want Discoverer to use summaries when up-to-date data is available.
Never	Specify that you do not want Discoverer to use summaries.

Query Governor

Use these radio buttons 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 to 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 greater 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 to 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 to the right.

• Retrieve data incrementally in groups of

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

• 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.