---

Preferences page

Use this page to specify the following settings for Discoverer Viewer:

• "Query Governor"

• "Worksheets"

• "Measure Unit"

• "Summary Data"

• "Fan Trap Detection"

• "Locale Selection"

Query Governor

The Query Governor preferences enable you to set limits on the amount of time a query should take to complete. Use these preferences to limit the time you wait for Discoverer to run a query. These preferences set time and size limits on data as it is being retrieved from the database.

Warn me if predicted query time exceeds:

Select this option for Discoverer to display a message if the estimated query completion time exceeds the number of seconds that you specify here.

Prevent queries from running longer than:

Select this option for Discoverer to cancel a query that runs longer than the time specified here. Discoverer will display a message informing you if the query exceeds the specified time, then Discoverer cancels the query. Select this option if long running queries might affect server performance.

Limit retrieved query data to:

This option sets the maximum number of rows to retrieve for a query. If the database contains more rows than the number required for the query, Discoverer displays a message informing you that not all data is retrieved, and therefore the displayed data might not be complete.

Retrieve data incrementally in groups of:

Set this option when the database contains large tables with many rows that might take a long time to retrieve. With an entry made here Discoverer retrieves rows of data in increments rather than all at the same time. The smaller the number of rows to retrieve as a group, the faster the initial retrieval. The default data group size of 100 rows, equates to the first 10 pages of data at 10 rows per page. You can set the number of rows per page in the "Worksheet Display page" page.

Cancel list-of-values retrieval after:

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

Worksheets

The Worksheets preferences enable you to define a number of worksheet display settings.

Number of rows per page

Worksheet data is displayed on a page-by-page basis. This sets the maximum number of rows of data that can be displayed on a page.

Number of columns per page

Worksheet data is displayed on a page-by-page basis. This sets the maximum number of columns of data that can be displayed on a page.

Measure Unit

PDF measure unit

Use the drop down list to select a unit of measure to display PDF files (i.e. inches and centimeters).

Axis Label

Show Axis Label

Use the drop down list to select whether to display axis labels (i.e. Always, Never, Worksheet) as follows:

• Always

  Axis labels are always shown in crosstab worksheets after they are opened. The saved worksheet value is overridden.

• Never

  Axis labels are hidden in crosstab worksheets after they are opened. The saved worksheet value is overridden.

• Worksheet

  Axis labels are shown or hidden in crosstab worksheets depending on how they were last saved.

Summary Data

Using summary data loads data more quickly for the work you do most often. When you request data for a worksheet, Discoverer first checks summary tables set up by the Discoverer manager to see if their saved data satisfies your request and, if it does, loads the appropriate data quickly. If the summary tables' data does not satisfy your request, Discoverer then redirects the request to the rest of the database and runs the query using the data in the database.

The preferences that are available to you here depend on whether your database supports materialized views.

For databases that support materialized views, the following options are available:

Always, when available

Select this option if time-sensitive data is not important for data analysis. Discoverer Viewer retrieves and displays saved data from the materialized views regardless of whether the data is current.

Only when summary data is not out of date (stale)

Select this option when time-sensitive data is necessary for worksheets. If the data in the materialized views is out of date (stale), Discoverer Viewer does not use the materialized views to fulfill your query request. Instead Discoverer Viewer redirects your query request to the full database and uses the latest data for the worksheet.

Never

Select this option if you always want Discoverer Viewer to ignore the Summary Tables and use the latest data.

For databases that don't support materialized views, the following options are available:

Always, when available

Select this option if time-sensitive data is not important for data analysis. Discoverer retrieves and displays saved data from the summary tables regardless of whether the data is current.

When summary data is more recent than nn days

Select this option when time-sensitive data is necessary for worksheets. Specify the number of days from the last data update. For example, if you're analyzing monthly data using summary tables, you want to make sure the data is less than thirty days old. If the data in the summary tables has not been updated within the specified time, Discoverer Viewer does not use the summary tables to fulfill your query request. Instead Discoverer Viewer redirects your query request to the full database and uses the latest data for the worksheet.

Warning: Do not use summary tables if you normally work with the most current data in the database. The saved data in the summary tables remains constant until updated with new data. summary tables should be updated periodically to incorporate new data. The Database administrator creates summary tables based on the type of data and the type of queries you use most often. Normally, summary tables are used for the queries that take a long time to aggregate and display data. Other queries that require less time to aggregate and join data might not need summary tables. See your Database administrator if you want to use summary tables

Fan Trap Detection

A fan-trap occurs when the data items in two folders are not directly related (such as with a Customer ID), but do have a relationship based on the data items in a third folder.

Discoverer automatically detects and resolves potential fan trap queries into multiple SQL statements to obtain normal expected results. Where Discoverer cannot resolve a fan trap, Discoverer prevents the worksheet from running and displays a warning message dialog.

If you disable fan trap detection, Discoverer still detects potential fan trap configurations, and resolves them by generating the correct SQL and displaying correct worksheet data. If Discoverer cannot resolve a fan trap, it displays the worksheet data and does not display a warning message dialog. The result of disabling fan trap detection might result in a query based on an unresolvable fan trap configuration, generating potentially misleading results.

For more information about fan traps, see the Oracle Business Intelligence Discoverer Plus User's guide.

Enable fan-trap detection

Use this check box to enable fan trap detection.

Locale Selection

Discoverer Viewer supports many different languages.

Select a locale

Use this drop down list to select a different language to display Discoverer Viewer in.