Oracle Discoverer for End Users

AUDIENCE: This course is for Oracle Discoverer end users and technical support professionals.
PREREQUISITES: Delegates should be familiar with Web browsers and a good knowledge of Windows applications is required.
DURATION: 2 days. Hands on.
OBJECTIVES: On completion of the course delegates will be able to:
- Create, modify and run ad hoc queries.
- Create filters and use functions.
- Schedule reports.
- Share workbooks with other users and export reports to other applications.
COURSE CONTENT:
Discoverer Concepts
Identifying the concepts and components of Oracle Discoverer 4i(web edition)/4.1(Desktop)
Explaining the role of the Oracle Discoverer Administrator
Connecting to Discoverer
Describing Discoverer support for Oracle Applications

Creating Ad Hoc Queries
Using the Workbook Wizard
Creating a simple query and viewing the Output
Customizing the output

Managing Queries
Building and executing queries
Controlling query execution
Customizing Worksheets
Managing Workbook
Setting Advanced Options

Customizing Display Properties
Customizing heading, page and data properties
Formatting numbers and setting background
Creating exceptions (*)

Applying Conditions and using Parameters
Selecting and applying predefined conditions
Creating conditions
Creating complex conditions
Creating parameters
Creating parameterised conditions

Creating Subqueries (*)
Creating a simple subquery condition
Creating a correlated subquery condition

Creating Group Sorts and Applying Totals
Creating a group sort
Applying subtotals and totals in results
Creating percentages

Creating Calculated Items
Identifying types of calculations
Creating simple and complex calculated items
Modifying a calculation
Passing parameters to calculations
Applying simple and complex SQL functions including Analytical functions

Scheduling
Scheduling reports
Using the scheduling manager

Analysing Data With Drills
Identifying different drill types
Using the Drill Dialog Box
Drilling to a related item (*)
Drilling directly with hyperdrills
Drilling to external applications

Analysing Data Graphically
Creating different graphs types
Customising graphs, Titles and Legends
Drilling within graphs

Importing and Exporting Reports
Exporting reports to Excel, HTML, Notepad or Oracle Reports
Sending workbooks via e-mail
Exporting and Importing SQL
Using the command-line interface

(*) - Where available