Discoverer Plus - Definitions

...

Distribution

ODS Specialist

ODS Specialist-Limited

ODS Specialist-Restricted

Ownership

The ISDS System Usability Director is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

Definitions

Axis item: A non-numeric column from a table.

Business area (List): A group of related folders in the End User Layer. (Select a business area from the drop-down list to display a list of all of its folders.)

Condition: A filter defined by the administrator. (Selecting a condition for inclusion in your query is analogous to selecting a data item for inclusion.)

Crosstab: Crosstab output looks like a bus or train timetable, with values running across the top, down the left edge, and in the intersection of rows and columns. These values are usually summarized to show a total or average. A crosstab is sometimes called a matrix report.

Data-point item: The numeric column from a folder. Data-point items have aggregates such as in the case of monthly expenditures in the FM reports. (You can use SUM, Count, Max, and Min in numeric items. Detail (i.e. – no aggregation) is generally set as the default in SIS

Folder: A database object such as a table, view, or some combination of database columns or derived columns. (If a folder is selected for inclusion, all of its items are included in the query.)

Graph: By default, Graph is checked. We suggest you uncheck this box. If you change your mind later, you can always view the graph; this is not your only chance to do so.

Items: Folders are composed of items. Items map to columns in a database table. Each item has a name and contains a specific type of information.

Page-Items: Page Items can be used with both table and crosstab reports. Page items allow you to subdivide a large amount of data into more manageable chunks. The values of the page item appear outside the main body of the layout. We recommend you keep Page Items checked; even if you don’t use it initially, it makes it easy to rearrange the report later.

Query: A query is simply a question you ask the database.

Rows: A folder or item consists of any number of rows, each of which represents all the information about one member of that folder.

Table: Table output has columns of information with headings. Each column is also called a column item.

Text: Getting started, we encourage users to deselect the text box, so that you will see more data space on the screen. However, you can turn this feature on and off at any time, so it is always available to you.

Workbooks and Worksheets: Discoverer uses workbooks. Workbooks contain one or more worksheets. A worksheet contains information retrieved from the database based on the items selected in the query. This feature of Discoverer has the same look and feel as Excel workbooks and worksheets. However, Discoverer saves the (query) only, and does not save the results of that query.

Effective: 6/29/10

Revision: 1

Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.