Oracle Discoverer 4.1 Desktop User Edition
Course Description
This class will teach students 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.
2 Days
Contact us for pricing
Prerequisites
None RequiredCreating Queries
Starting Discoverer 4.1 Desktop User EditionCommand Line Options
Online Help
The Workbook Wizard
The Results Window
Query Management
Managing WorkbooksManaging Worksheets
Editing Worksheets
Managing Items
Modifying the Display (1)
Adding a Report TitlePage Setup Options
Formatting Headings
Changing Heading Text
Modifying Heading Properties
Formatting Data
Changing Default Column Size
Displaying Images in Background
Modifying the Display (2)
Modifying Data Display PropertiesPrinting the Report
Working with Conditions and Parameters (1)
Viewing, Applying, Disabling ConditionsCreating New Conditions
Multiple and Nested Formula Conditions
Subqueries
Create Conditions using the Analysis Bar
Editing Conditions
Viewing, Applying and Disabling Parameters
Creating New Parameters
Working with Conditions and Parameters (2)
Executing the QueryEditing Parameters
Working with Exceptions and Calculations
Viewing, Applying, Disabling ExceptionsCreating and Editing Exceptions
Creating Calculations using the Edit Calculations Dialog
Creating Calculations using the Analysis Bar
Editing Calculations
Working with Sorts, Totals, Percentages
Creating Column SortsCreating/Editing Group Sorts
Viewing, Displaying, Hiding Totals
Creating Totals using the Totals Dialog
Creating Totals using the Analysis Bar
Viewing, Displaying, Hiding Percentages
Creating and Editing Percentages
Drilling the Data
Drilling Up and DownDrilling from the Workbook Window
Using the Drill Dialog
Specifying Drill Options
Drilling to a Related Item
Drilling to Details in Another Sheet
Graphing Data
Creating a GraphSelecting a Graph Type
The Graph Window
Customizing the Colors and Patterns
Customizing the Graph
3D View Properties
Scale and Numbers
Editing the Graph
Workbook Maintenance
Scheduling WorkbooksSchedule Workbook Dialog
Scheduling Manager
Opening Scheduled Workbooks
Exporting Discoverer Output
Using the Export Dialog
HTML Export Example
Sending Workbooks via email
Working with SQL and Setting Options (1)
Viewing, Exporting, and Importing SQLThe SQL Inspector and Plan Display
Setting Discoverer Options
General Options
Query Governor Options
Table/Crosstab Options
Format Options
Cache Options
Working with SQL and Setting Options (2)
Advanced OptionsEUL Options
Connection Options
Using SQL Functions in Discoverer
Function CategoriesTypes of Functions
String Functions
Numeric Functions
Numeric Comparison and Presentation Functions
Date Functions
Nesting a Function
Introduction to Analytic Functions (Optional)
Discoverer