Options dialog: Advanced tab

Use this tab to specify the way that Discoverer keeps worksheet data up-to-date, and how it processes complex data. For example, if you use static data that is not changed frequently, you might not want a worksheet refreshed when you change the format of a sheet.

For more information, see:

"About multiple join paths"

"About fan traps"

"About automatic querying"

Automatic querying

Disable automatic querying from database (only used cached results)

Use this check box to specify whether Discoverer refreshes worksheets with up-to-date data when you change a worksheet format. Do not select this check box without first contacting the Discoverer manager. For more information about the Discoverer Server cache, contact the Discoverer manager.

If you clear this check box, Discoverer always displays up-to-date data, however performance might be affected. If you select this check box, you might need to choose Tools | Refresh Sheet after changing a worksheet layout.

Joins

Disable fan trap detection

Clear this check box if you want Discoverer to detect potential fan trap configurations, generate the correct SQL and display correct worksheet data. Where Discoverer cannot resolve a fan trap, Discoverer prevents the worksheet from running and displays a warning message dialog.

Note: It is recommended that you clear this check box. Do not select this check box without first contacting the Discoverer manager.

Select this check box if you do not want Discoverer to detect or resolve potential fan trap configurations (see Note above).

Disable multiple join path detection

Use this check box to disable multiple join detection.

Note: Do not select this check box without first contacting the Discoverer manager as Discoverer might display unexpected data depending on the join(s) that Discoverer automatically selects.

Select this check box for Discoverer to automatically select all joins between folders (where multiple joins exist between two folders) when you create a worksheet.

Clear this check box for Discoverer to display the "Join folders dialog" (where multiple joins exist between two folders) when you create a worksheet.

Show Joins

Select this check box to show the name and description of the database joins used in the following lists in the "Edit Worksheet dialog: Select Items tab":

• the Available list

  The joins shown in the Available list enable you to select items from the folders displayed, and use them in a worksheet.

• the Selected list

  The joins shown in the Selected list are the joins that are required to display the selected items in a worksheet.