Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: WHAT IS ORACLE DISCOVERER?

• Overview
• Discoverer Components
• The Discoverer Administration Interface
• The Data Page
• The Hierarchies Page
• The Item Classes Page
• The Summaries Page
• The Discoverer Workbook Window

Session 2: DATABASE REQUIREMENTS FOR USING DISCOVERER

• Introduction
• Preparing for the use of Scheduled Workbooks
• Requirements for Summary Management
• Query Prediction

Session 3: THE END USER LAYER

• Introduction - the Purpose of the End User Layer
• Creating an EUL
• Managing the EUL
• Deleting an EUL

Session 4: BUSINESS AREA MANAGEMENT

• Introduction - Business Areas and their Use
• Building a New Business Area
• Building a New Business Area with the Load Wizard
• Applying security and privileges to a Business Area
• Scheduling workbooks

Session 5: FOLDER MANAGEMENT

• Introduction - the Types of Folder
• Creating a Simple Folder
• Creating a Complex Folder
• Creating a Custom Folder
• Folder Properties
• Editing the SQL of a Custom Folder
• Sharing Folders across Business Areas
• Folder Operations
• Importing and Exporting using Discoverer Administrator

Session 6: MANAGING ITEMS AND ITEM CLASSES

• Introduction - Items, Item Classes and their Use
• Item Properties
• Deleting an Item
• Creating and Editing Item Classes
• Using the Item Class Page to Manage Item Classes

Session 7: JOINS, CALCULATIONS, CONDITIONS AND HIERARCHIES

• Introduction - the Use and Purpose of these Objects
• Joins
• Calculations
• Conditions
• Hierarchies

Session 8: SUMMARY FOLDERS

• Introduction - the Purpose of Summary Folders
• What is a summary Folder?
• Creating a Summary Folder
• Editing and Repairing Summary folders
• Summary Folder Properties
• Automated Summary Management

Session 9: EUL STATUS WORKBOOKS

• Introduction - What are EUL Status Workbooks?
• Installing the EUL v5 Business Area
• Workbook Content

Session 10: INTRODUCTION TO APPLICATION SERVER

• Introduction to the Application Server
• A Simple Application Server Environment to Support Discoverer
• Oracle Application Server Installation Types
• Managing an Application Server
• The Enterprise Manager Website
• The Application Server Farm Home Page
• The Application Server Instance Home Page
• The Components' Home Pages
• Starting and Stopping Components and their Effects
• Clues to Potential Web Problems

Session 11: DISCOVERER ARCHITECTURE

• Introduction - Discoverer Architecture on the Web
• The Discoverer Services
• Accessing Discoverer Plus
• Accessing Discoverer Viewer

Session 12: CONFIGURING DISCOVERER FOR THE WEB

• Introduction - the Discoverer Configuration Page
• Issues Concerning Running Discoverer Plus for the First Time
• Managing Discoverer Services
• Shutting Down the Discoverer System
• Using Discoverer in a Multi-Machine Environment
• Creating Public and Private Discoverer Connections
• Discoverer and Oracle Single Sign-On
• Configuring Single Sign-On to Protect Discoverer
• Connecting to Discoverer with Single Sign-On

Session 13: INFLUENCING DISCOVERER BEHAVIOUR

• Introduction - Discoverer Preferences and Oracle Web Cache
• Maintaining Oracle Discoverer Preferences
• Using Parameters in the Oracle Discoverer URLs
• Oracle Discoverer and the Oracle Web Cache
• Configuring Oracle Discoverer to use the Web Cache