Plus - Setting Advanced Options
ISDS System Usability Director is
responsible for ensuring that this document is necessary, reflects actual
practice, and supports University policy.
Enter connection details > Go > Cancel > Blank Workbook > Tools
1. Check [Disable] automatic querying from
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.
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.
are defined by the administrator.Joins are a basic relational construct for
combining information between folders.
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
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
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
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.
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.