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 may 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 for 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 for Discoverer to detect potential fan trap configurations, generate the correct SQL and display correct worksheet data. Where Discoverer cannot resolve a fan trap, Discoverer still displays the worksheet data and does not display a warning message dialog.

Disable multiple join paths?

Use this check box when you want to look at data that can be processed and displayed by Discoverer in more that one way. Do not select this check box without first contacting the Discoverer manager.