Worksheet List page

This page enables you to search for and select a worksheet to display, from the list of available workbooks. A workbook contains worksheets that display related data, but combined using different perspectives. For example, a workbook may show the sales history for Product A. However, one worksheet could show sales for last month, another worksheet could show sales compared to the same month five years ago, and another could show sales per region. All three worksheets contain sales data related to Product A, but each is organized to show a different perspective.

For more information, see:

"How to open a Discoverer worksheet"

You can select workbooks either from a list of available database workbooks or from a list of scheduled workbooks that have already run (scheduled workbooks are not available for OLAP connections).

Use the Search drop down list to display the available Database Workbooks or Scheduled Workbooks.

Database Workbooks

Discoverer will query the database to display the latest data, and the results are not stored.
Scheduled Workbooks (not available with OLAP connections)

Discoverer has already run the query at a predetermined time and the results have been stored in the database.

Use the Search field to refine the list of workbooks to display in the Result List. Enter partial or full details for any matching workbook names you want to display and click the Go button. The Search field is case insensitive.

Note: Wildcards such as " * ? % " etc. are unnecessary and should not be used in the search.

Result List

The list of workbooks displayed in this area will include workbook names that match the details entered in the Search field.

Expand All/Collapse All

Use these links to display or hide all workbook and worksheet details.

Use the Expand link to display workbook and worksheet details for all workbooks.

Use the Collapse All link to hide workbook and worksheet details for all workbooks.

Discoverer Workbooks

Use this link to display all Discoverer workbooks.

Note: Discoverer only displays this link after you use the target icon in the Focus column to display the details of a specific workbook (for more information, see the Focus column).

Focus

Use the target icon to hide details for all folders/workbooks except the one selected.

Name

Use the arrow icons to display or hide workbook and worksheet details.

Use a link in the Name column to display a worksheet.