Course Search:

Oracle Discoverer 4.1 Desktop User Edition

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.
  • Cost: Price on application
  • Duration: 2 Days
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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):


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.