Options dialog: Advanced tab

Use this tab to configure the way that Discoverer keeps workbook 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 workbook refreshed.

For more information, see:

"About multiple join paths"

"About fan traps"

"About automatic querying"

Disable automatic querying?

Use this check box when you do not want the worksheet to be refreshed with up-to-date data when the sheet format is changed. Do not select this check box without first contacting the Discoverer manager.

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 paths?

Use this check box when you want 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 more than one join exists between two folders) when you create a worksheet.

Clear this check box for Discoverer to display the "Join folders dialog" (where more than one join exists between two folders) when you create a worksheet.