Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus 11g Release 1 (11.1.1) Part Number B40105-01 |
|
|
View PDF |
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:
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.