Discoverer for End Users

Course Overview

This course provides a hands-on approach to Oracle’s Discoverer application for End Users. The course begins with a very brief overview of the Oracle database and Oracle Discoverer’s place in the system. Delegates will then use the wizards to create the four different types of report that can be generated.

Delegates will be guided through drilling, sorting, totals, percentages, conditions, exceptions, formatting, printing, parameters, scheduling, graphs and exporting. The course is structured in such a way that the delegates are using Discoverer for the entire day. They will be taken through tasks step-by-step and then given exercises to enforce what they have just learned.

Introduction
• The Oracle Database
• The Purpose of Oracle Discoverer
• The End User Layer

Creating Workbooks
• The Workbook Wizard
• Table Report
• Crosstab Report
• Page-Detail Table Report
• Page-Detail Crosstab Report

Maintaining Workbooks and Worksheets
• Saving a Workbook
• Creating a New Worksheet in Your Workbook
• Sharing Workbooks
• Worksheet Maintenance
• Printing a Worksheet

Formatting Data
• Renaming Your Column Names
• Rearranging the Order of the Columns
• The Formatting Toolbar
• The Format Data Dialogue Box
• Formatting Columns
• Formatting Totals
• Adding a Title to Your Query
• Adding a Background Bitmap

Filtering Data with Conditions
• Different Methods Available
• Creating a Basic Filter
• Creating a Complicated Filter

Ordering Results
• Basic Sorts
• Sorting into Groups
• Using Groups for Pagination

Generating Totals and Percentages
• Creating a Basic Total
• Creating a Total Based on a Group
• Creating a Basic Percentage
• Creating a Percentage on a Group

Exception Reporting
• Creating an Exception

Calculated Fields
• Creating a Calculated Field without Oracle Functions
• Creating a Calculated Field Using Oracle Functions

Applying Conditions Using Parameters
• Using Existing Conditions
• Creating Parameters without Existing Conditions

Remaining Features
• Implementing Graphs using the Graph Wizard
• Batch Scheduling
• Exporting Data