Oracle9i Discoverer for Desktop Users Course

This class will teach participants the purpose and capabilities of the Discoverer 9i Desktop tool. Users learn to create fully customized ad-hoc queries. They will also learn how to modify the display, drill to data at several levels, analyze the data graphically, and perform other various tasks such as scheduling, importing and exporting workbooks.

This class will present a thorough knowledge of the Discoverer Desktop tool.  Thereafter each user can learn to apply this knowledge to the company's internal data model. 

NOTE: Administrators are required to attend this 2-day session first!  This 2 day class is taught as Days 1 and 2 of the Administrator course.

This course is designed for End users and Administrators using Discoverer on the desktop.

Upon successful completion of this course, participants will be able to:
>Create ad-hoc queries
>Analyze data graphically
>Import and Export workbooks

Creating Queries
Starting Discoverer Desktop
Command Line Options
Online Help
The Workbook Wizard
The Results Window

Query Management
Managing Workbooks
Adding And Duplicating Worksheets
Moving/Copying Worksheets
Editing Worksheets
Renaming And Deleting Worksheets
Managing Items

Modifying The Display
Adding A Report Title
Page Setup Options
Formatting Headings
Changing Heading Text
Modifying Heading Properties
Formatting Data
Changing Default Column Size
Displaying Images In Background
Modifying Data Display Properties
Printing The Report

Working With Conditions And Parameters
Viewing, Applying, Disabling Conditions
Creating New Conditions
Using The New Condition Dialog
Multiple And Nested Formula Conditions
Subqueries
Create Conditions Using The Analysis Bar
Editing Conditions
Working With Parameters
Viewing, Applying, And Disabling Parameters
Creating New Parameters
Executing The Query With The Parameter Wizard

Working With Exceptions And Calculations
How Exceptions Are Used
Viewing, Applying, Disabling Exceptions
Creating And Editing Exceptions
Working With Calculations
Viewing, Displaying, Hiding Calculations
Creating Calculations Using The Edit Calculation Dialog
Creating Calculations Using The Analysis Bar
Editing Calculations

Working With Sorts, Totals, Percentages
Creating Column Sorts
Creating Group Sorts
The Sort Table Dialog
Working With Totals
Viewing, Displaying, Hiding Totals
Creating/Editing Totals Using The Total Dialog
Working With Percentages
Viewing, Displaying, Hiding Percentages
Creating/Editing Percentages
Using The Percentage Dialog
Using The Analysis Bar To Create Percentages

Drilling The Data
Drilling Up And Down
Drilling From The Workbook Window
Using The Drill Dialog
Specifying Drill Options
Drilling To A Related Item
Drilling To Details In Another Sheet
Drilling To External Applications

Graphing Data
Creating A Graph
Selecting A Graph Type
The Graph Window
Customizing The Graph
3d View Properties
Scale And Numbers
Editing The Graph
Workbook Maintenance
Scheduling Workbooks
Schedule Workbook Dialog
Scheduling Manager
Opening Scheduled Workbooks
Exporting Discoverer Output
Using The Export Dialog
Sending Workbooks Via Email

Working With SQL And Setting Options 
Viewing, Exporting, And Importing SQL 
The SQL Inspector And Plan Display 
Setting Discoverer Options 
General Options 
Query Governor Options 
Table / Crosstab Options 
Format Options
Cache Options 
Advanced Options 
EUL Options 
Connection Options 

Using SQL Functions In Discoverer 
Function Categories 
Types Of Functions 
String Functions 
Numeric Functions 
Numeric Comparison And Presentation Functions 
Date Functions 
Nesting A Function 

Introduction To Analytic Functions (Optional)

None