Discoverer Plus - Worksheets - Selecting Additional Items

...

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.

After opening a Pre-Defined Worksheet you can add additional columns and retrieve additional information.

1. Select Sheet, [Edit, Worksheet] from the Menu bar.

2. Select the tab Select Items in the Edit Sheet window.

The right side of the screen, titled Selected, shows the items that you have queried on in the Pre-Defined worksheet that you ran.
The window on the left side shows all the items in the Database.

3. Select the business area from the drop down list.

The example below shows a query that will retrieve data from the Grants Management module, so the business area [PBPA-Project_Billing] is selected.

The folders that are lit contain items that are available to add to the report.

4. Select the folder with the data you need.

5. Select the item.

6. Either drag the item to the right panel or click the right-pointing arrow to move the item from the Available to the Selected pane.

7. Click [OK] and the query will run again and retrieve the item you added.

The added item will always appear in the last column. You may move the column that you added exactly as any other column in the report.

NOTE: You can click show folders to see from which folder selected items were chosen.

Discoverer Plus also allows a view of available and selected items within the report.

8. Select [View, Available Items Pane].

9. To add items from the available items pane right click and drag the item to the position in the worksheet where you want it to appear.

Remember release the item when the bold vertical line appears.

Effective: 6/28/10

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.