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