Oracle® Business Intelligence Discoverer Plus User's Guide
10g Release 2 (10.1.2.0.0) Part No. B13915-01 |
|
![]() Previous |
![]() Next |
The following table shows the icons displayed in the Discoverer item navigator.
Icon | Description |
---|---|
![]() |
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. |
![]() |
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. |
![]() |
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. |
![]() |
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. |
![]() |
Folder - contains the items that you can include in your worksheets. Click the plus (+) and minus (-) symbol next to the folder to open and close the folder. |
![]() |
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). |
![]() |
Item Value - an item in a list of values (LOV). |
![]() |
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. |
![]() |
Percentage - a percentage that Discoverer calculates to summarize values in a numeric worksheet item. |
![]() |
Tick symbol (or check mark) - worksheet items marked with a tick symbol are currently displayed on the current worksheet. |
![]() |
Total - a total that Discoverer calculates to summarize values in a numeric worksheet item. |
Note: Items that are grayed out are not available to the worksheet.