Open Workbook from Database dialog

Use this dialog to choose a workbook to open. For example, you might have saved a Discoverer workbook previously and want to edit it again. Or, you might want to edit a workbook created by another Discoverer user.

Note: You can only open one workbook at a time. If a workbook is currently open, opening a different workbook causes the currently open workbook to be closed.

For more information, see:

"What are workbooks?"

View

Use this list to specify the type of workbooks you want to display in the Workbooks list. For example, you might choose My Workbooks to display only workbooks owned by the database user that you are logged in as.

Use this drop down list to select a style for the Workbooks list. For example, you might choose the User Tree option to display workbooks grouped by database user. Or you might choose Workbook Tree to display workbooks in alphabetical order.

Name contains

Use this field to restrict the Workbooks list to those workbooks with names that contain the character(s) that you specify. For example, enter 'January' to display in the Workbooks list only those workbooks with names that contain January.

Clear

Use this button to clear any text in the Name contains field and display the names of all workbooks in the Workbooks list.

Workbooks

Use this list to select the workbook you want to open. Workbooks are represented by a book icon. Scheduled workbooks are represented by a clock icon. To open a workbook, double-click on the workbook name, or select the workbook and click Open. Type a letter to jump to workbooks beginning with that letter.

Hint: Click on a column name to sort the Workbooks list on that column. Click on the arrow in a column name to reverse the sort order. You can also drag and drop columns to a different position in the Workbooks list.

If the workbook you want to open is not in the Workbooks list, ensure that you chose the correct connection when you started Discoverer Plus Relational. If a workbook has been created by another Discoverer user, ensure that the Discoverer user has shared the workbook with you (for more information, see "About sharing workbooks").

If you cannot find a scheduled workbook you want to open, check the status of scheduled workbooks by choosing File | Scheduling to display the "Scheduling Manager dialog".

Note: The date and time in the Modified field is the date and time on the Web server, which might be different from the date and time on the system on which the browser is running.

Description

This field displays additional information about the workbook, which was entered using the "Workbook Properties dialog". Use this information to help you decide which workbook you want to analyze. This area is blank if no description is available.

Hint: To add or edit the description, update the workbook properties (for more information, see "How to view and update a workbook's properties").

Open

Use this button to open the workbook selected in the Workbooks list.

Notes

When connected as an Oracle Applications user, the following security rules apply:

If you connect as a particular user and responsibility and schedule a workbook, the scheduled workbook is specific to that user and responsibility.
If you connect as a particular user but a different responsibility from the one used to schedule a workbook, the scheduled workbook might contain different results from the original scheduled workbook that was created.

For more information about using Discoverer as an Oracle Applications user, see "How to start Discoverer in Oracle Applications mode using an existing connection".