...

...

...

Discoverer Plus - Setting Advanced Options

Distribution

ODS Specialist

ODS Specialist-Limited

ODS Specialist-Restricted

Ownership

The ISDS System Usability Director is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

Discoverer Plus        
Enter connection details > Go > Cancel > Blank Workbook > Tools > Options
Advanced tab

1.   Check [Disable] automatic querying from database

• If you create a lot of workbooks, you may want to disable automatic querying. 
• Use the Refresh Worksheet icon when you are ready to run your query.

Disable fan-trap detection:

2.   Leave unchecked [Disable] fan-trap detection.

• A fan trap, in very simple terms, is a SQL query that gives you unexpected results.   The most common manifestation occurs when a master table is joined to two detail tables separately and results in incorrectly aggregated measures. 
• There are times, however, when you may need to disable fan-trap detection.  An example would be if you need to use data from three or more folders, you may get the message “Invalid join configuration – includes a master with two separately joined detail folders”. 
• Disabling fan-trap detection may be necessary, but if you are unsure as to the results, or whether you should disable this feature, please phone the Help Desk (434-924-HELP) and ask to have your case escalated to the Reports team.

Joins

Joins are defined by the administrator.Joins are a basic relational construct for combining information between folders.

You can have more than one join path between two folders. For example, there can be two joins between the SR Schedule of Classes folder and the SR Class Meeting Pattern folder:

• An equijoin that contains all courses offered by a department
• An outer join that contains the days of the week that the courses will be taught

Multiple Join Path Detection:

3.   Do not disable multiple join path detection. 

• A multiple join path occurs when two folders have more than one join relationship defined between them. 
• If you disable multiple-path detection, Discoverer will not check for multiple joins and will use all joins defined between the folders.
• This may very well result receiving incorrect data.

  Effective: 6/30/2010

  Revision: 1

  ---

  Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.

  Oracle® Tutor   Copyright © 1997, 2009, Oracle. All rights reserved.