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
Contact us for dates
Contact us for dates

Prerequisites

None Required

Creating Queries

Starting Discoverer 4.1 Desktop User Edition
Command Line Options
Online Help
The Workbook Wizard
The Results Window

Query Management

Managing Workbooks
Managing Worksheets
Editing Worksheets
Managing Items

Modifying the Display (1)

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 the Display (2)

Modifying Data Display Properties
Printing the Report

Working with Conditions and Parameters (1)

Viewing, Applying, Disabling Conditions
Creating 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 Query
Editing Parameters

Working with Exceptions and Calculations

Viewing, Applying, Disabling Exceptions
Creating 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 Sorts
Creating/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 Down
Drilling 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 Graph
Selecting 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 Workbooks
Schedule 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 SQL
The 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 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)


Discoverer