Edit Worksheet dialog: Select Items tab

Use this tab to specify which items to display on the current worksheet. For example, you might want to add items so that you can analyze your data in a new way.

For more information, see:

"What are worksheets?"

"About icons in the Workbook Wizard"

Available

This field displays the name of the Business Area that the workbook is connected to. Use the expandable list below to specify which items you want to analyze in the worksheet (see table below for information about item types available).

Click the plus (+) and minus (-) buttons next to folders and items to expand and collapse them.
To select more than one item at a time, hold down the control key (Ctrl) when you select items.
To add items to the worksheet, select the item in the Available list, then click the right arrow button (>) to add it to the Selected list.

Table 19-2 Workbook Wizard and Worksheet Wizard icons

Icon	Description
Text description of the illustration icon_ba.gif	Business area - displays a business area created by the Discoverer manager. To select another business area for the new worksheet, click the drop-down arrow and choose from the list of business areas. A business area contains one or more folders.
Text description of the illustration icon_fol.gif	Folder - contains the items that you can select for your worksheets. Click the plus (+) and minus (-) symbol next to the folder to open and close the folder.
Text description of the illustration icon_ax.gif	Axis Item - corresponds to a column on a table or a level on a crosstab axis. Axis items remain constant and have relatively few unique values (e.g. the names of departments in your organization, the names of your Sales Regions). The values of an axis item are shown as a list of values (LOV).
Text description of the illustration icon_axi.gif	Item Value - an item in a list of values (LOV).
Text description of the illustration icon_num.gif	Numeric Item - represents numeric data. The values of numeric items can change as you analyze the data (e.g. summing profits will produce different results for cities than for regions). Numeric items behave as axis items on table worksheets and correspond to the data in the body of a crosstab.
Text description of the illustration icon_agg.gif	Aggregations - the mathematical functions to aggregate data. For text items (e.g. Region), the typical aggregations are Count, Max, and Min. For example, you can count the number of Regions items, or find the highest or lowest (where A might be the highest and Z the lowest). For numeric items, typical aggregations are Sum, Count, Max, Min, Average, and Detail. For example, you can find the Sum or Average of the numeric data. The default aggregation (specified by the Discoverer manager) is displayed in bold.
Text description of the illustration icon_con.gif	Condition - a filter for finding specific data. Note: Conditions defined by the Discoverer manager appear in folders. User-defined conditions do not appear in folders.
Text description of the illustration icon_cal.gif	Calculation - a mathematical expression to produce new data from other items. Note: Calculations defined by the Discoverer manager appear in folders. User-defined calculations) do not appear in folders.

<Torch icon>

Click the torch icon ( The torch icon, used to display the Find dialog where you search for items in the EUL ) above the Available box to display the "Find dialog (in Item Navigator)", where you search the EUL for items that you want to add to the worksheet.

Hint: To locate an item quickly when the focus is on the Item Navigator, type the first letter of the item or folder that you want to locate. The next item or folder beginning with the typed letter is highlighted. Repeat this process to highlight the next item or folder beginning with the typed letter. For example, type 'r' or 'R' to locate the Region item.

Selected

Use this list to look at items currently in the worksheet.

To remove an item from the worksheet, select the item in the Available list, then click the left arrow button (<) to move it back to the Available list.
To select more than one item at a time, hold down the control key (Ctrl) when you select items.

Options

Use this button to display the Options dialog. Use the Options dialog to specify:

how Discoverer handles queries (see "Options dialog: Query Governor tab")
how Discoverer formats worksheets (see "Options dialog: Sheet Format tabs")