What are worksheets?

Worksheets contain the data that you want to analyze, together with a number of Discoverer components to help you analyze the data. For example, a worksheet can contain parameters, totals, percentages, exceptions, and calculations.

You create a worksheet in a workbook (for more information, see "What are workbooks?").

If you are familiar with spreadsheet applications (e.g. Microsoft Excel), think of a workbook as a spreadsheet file and worksheets as different sheets in that spreadsheet file.

In the figure below, a Discoverer worksheet called Tabular Layout contains information about profits made by two departments across three regions in the year 2000.

Figure 6-2 A Discoverer worksheet

Description of the illustration ws.gif

You can develop worksheets in different ways:

• you can create your own worksheets, which you can subsequently share with other Discoverer users.

• you can use worksheets created by other Discoverer users or by the Discoverer manager

• you can include parameters in a worksheet to filter the worksheet each time it is opened or refreshed