Discoverer Plus Menu & Toolbar

...

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.

Worksheet

The results of the query are displayed in this region.

After viewing the results, you may want to customize or save the output. The end-user component contains many tools and features for customizing and administering your output.

Menu and Toolbar

Menu Bar: The menu bar appears across the top of the screen. The options available depend on which action you are currently performing.

Toolbar: Below the menu bar are rows of icons and drop-down lists. As with the menu bar, the icons may be active or inactive depending on the action you are currently performing.

Edit Worksheet icon set

Edit Worksheet is the most direct method for adding/removing items from your query, creating conditions, parameters, sorts, etc. Using the Edit Worksheet icon allows the user to make changes to a query after you have viewed the results. You can make multiple changes and when you select [OK], the query runs only once.

Edit Table is the quick way to bring up the Edit Worksheet window where you can edit the layout, add and remove items, move columns, sort, and add or edit parameters.

The New Condition icon area (arrow)

The New Condition icon can be used to create a quick (on-the-fly) condition using one of the logical operators available in the list. Click on the Column on which you wish to base the condition, and then select the New Condition icon area. You have now completed with a couple of clicks two segments of a three part formula.

You can also click on the icon and begin from scratch. However, you may simply wish to use the [Edit Sheet] icon, where you have multiple choices for changes and additions available to you.

Refresh Sheet icon

Use the Refresh Sheet icon to run your query again. (i.e., if you have created parameters, you can change to a different parameter choice without closing the current workbook.)

New Calculation icon area

New Calculation icon can be used to create quick (on-the-fly) calculations. simple and complex calculations. Click on the Column on which you wish to base the calculation, and then select the New Calculation icon area. You have now completed with a couple of clicks two steps in creating a simple calculation.

Effective: 6/29/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.