Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus 11g Release 1 (11.1.1) Part Number B40105-01 |
|
|
View PDF |
This chapter introduces the main dialogs that you work with when you use Discoverer Plus Relational, and includes the following topics:
Note: The examples in this chapter use the sample Video Tutorial Workbook that comes with Discoverer. The specific tables, charts, data, and other items you see on your screen depend on the actual data in your database, and the workbook(s) designed by your organization's Discoverer manager.
The work area is where you do most of your analysis work with Discoverer. The work area displays the current worksheet and tabs for other worksheets in the current workbook. Discoverer's navigation facilities make it easy to find your way around workbooks and worksheets to find the information you want.
You can analyze data in the Discoverer work area in different ways:
using drag and drop (for more information, see "About Discoverer's drag and drop features"
using menus (for more information, see "About Discoverer menus"
using toolbars (for more information, see "About Discoverer toolbars"
using the worksheet wizard (for more information, see "What is the Discoverer Worksheet Wizard?"
When you are working in Discoverer, use the following drag and drop features:
add items to a worksheet by dragging and dropping the item from the Available Items pane onto the worksheet (for more information, see "About dragging and dropping items in the Discoverer work area")
reposition items on a worksheet by dragging and dropping items into position (for more information, see "About repositioning items in the Discoverer work area")
As well as using the menus to add and remove items, you can drag and drop items on a worksheet. The example below shows how to add an item to a worksheet by dragging an item from the Available Items pane onto the worksheet.
To remove a worksheet item, you can also drag and drop the item off the worksheet drag to anywhere outside of the worksheet area (except the Selected Items pane, if displayed).
As well as using the menus to add and remove items, you can reposition a worksheet item by dragging it from one area of the worksheet to another area of the worksheet. In the example below, the Department item is dragged from the left axis to the top axis.
Note: The black bar below the Profit SUM heading indicates where the item will be dragged to. You can also drop an item on top of another item to swap the positions of the two items (the target item is marked with a gray bar).
Dragging items to a different axis on a crosstab worksheet is known as pivoting (for more information, see "Pivoting data").
In Discoverer you can use a standard menu and a range of right-click menus to perform tasks.
The standard menu is displayed at the top of the Discoverer work area. The standard menu includes options in these categories: File, Edit, View, Format, Tools, and Help.
Right-click on any worksheet item heading to display a right-click menu of options that enable you to perform the most common analysis tasks. In the example below, right-clicking on the Profit SUM item displays a list of options that can be used to analyze this item.
In Discoverer you use a range of toolbars to access Discoverer's powerful features quickly and easily.
The Standard toolbar contains icons for the most common menu options (for example, Save, Print, Refresh, Edit Worksheet, Sort). As you become more familiar with Discoverer, you can use the toolbar instead of the menu bar to choose options.
To display the Standard toolbar, choose View | Toolbars| Standard Toolbar.
Hint: To display the name of a toolbar option, move the cursor over the toolbar option to display a tool tip on that option. For more information, see "About tool tips".
The formatting toolbar enables you to format selected worksheet items.
To display the Formatting toolbar, choose View | Toolbars| Formatting Toolbar.
Hint: To display the name of a toolbar option, move the cursor over the toolbar option to display a tool tip on that option. For more information, see "About tool tips".
The graph toolbar enables you to edit graphs.
To display the Graph toolbar, choose View | Toolbars| Graph Toolbar.
Hint: To display the name of a toolbar option, move the cursor over the toolbar option to display a tool tip on that option. For more information, see "About tool tips".
The Available Items toolbar enables you to edit the worksheet using all items available in the business area.
The Available Items toolbar is displayed above the Available Items pane. To display the Available Items pane, choose View | Available Items Pane.
For more information about options on the Available Items toolbar, see "Available Items pane".
The Selected Items toolbar enables you to edit worksheet items currently on the worksheet.
The Selected Items toolbar is displayed above the Selected Items pane. To display the Selected Items pane choose View | Selected Items Pane.
For more information about options on the Selected Items toolbar, see "Selected items pane".
To help you use Discoverer, tool tips are displayed when you move the cursor over toolbar options. Additional information on toolbar options is also displayed at the bottom of the work area.
The figure below shows the tool tip for the Conditions toolbar item and also shows where additional information is displayed at the bottom of the Discoverer work area.
The following table shows the icons displayed in the Discoverer item navigator.
Icon | Description |
---|---|
![]() |
Aggregations - the mathematical functions to aggregate data. For text items (for example, 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 (for example, 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 (for example, summing profits produces 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. |
![]() |
Worksheet items marked with a checkmark 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.
Axis items are items that appear in the workbook window in:
the page axis
the top axis
the left axis
Typically, axis items have a relatively few discrete values. You use axis items to identify particular data values.
For example, if a crosstab worksheet shows sales figures, it might include Year as the top axis and Region as the left axis. You can then use the axis items to see the sales of a particular region in a particular year. In the figure below, Department item is on the page axis, Year is on the top axis, and Region is on the left axis.
Data points on a worksheet are the data in the body of a worksheet. Data points are the data that you want to use for analysis purposes. Typically:
On a table worksheet, data points contain text and numeric information (for example, customer mailing lists, product part number lists).
On a crosstab worksheet, data points contain numeric values calculated at the intersection point of the top axis and left axis (for example, monthly profits, sales amounts by product).
Whenever you create a worksheet, the Worksheet Wizard walks you through the steps necessary to get data from the database and arrange the worksheet items. The figure below shows the Select Items page of the Worksheet Wizard. In the Available list, simply select the folder or item you want to add to the worksheet then drag it to the Selected list.