Discoverer Plus - Setting 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
General

1. Select the Run option that you want.

Run a query automatically means that as soon as you open the workbook the query runs and you get the results worksheet.
Don’t run query (leave the sheet empty). If you want the results windows to appear, you need to select the Refresh icon.
The default option is set at ‘Ask for confirmation’ resulting in the appearance of this familiar decision box when you open a workbook.

2. Enter [9] in the number of workbooks to show in recently used.

You can select the number of recently used workbooks list so that you can select a workbook you run often without searching for it. You change this setting to ‘9’.

Query Governor

3. Select [Query Governor] tab.

Summary Data: The data administrator creates and refreshes summarized tables. Since the database is refreshed nightly, there is no need to make a selection in the Summary Data area of this window.

Query Governor: You can cancel a query while it is running. We recommend you leave unchecked:

Warning me when the limit exceeds a certain number of seconds or minutes
Prevent a query from running longer than a certain number of seconds or minutes.
Limit retrieved query data to a certain number of rows
Retrieve data incrementally in groups of a certain number of rows – no need to change
Cancel list of values retrieval after a preset amount of time. – probably won’t need

Sheet

4. Select [Sheet] tab.

Set your preference of layout formats.

Column Headings, Row numbers, Gridlines

If you are currently in a table report, the Options dialog box has a Table tab
Two Style options are available for crosstab layouts:

Inline and Outline.

Formats

5. Select [Formats].

Set formatting for all future worksheets, using the Format tab.
Title: You can create a new title by default; the title will not appear in the current workbook, but will appear in the next new workbook.

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.