INTRODUCTION

• Benefits of Discoverer
• Components of Oracle Discoverer
• Business Areas
• The Role of the Discoverer Manager

SETTING UP THE TUTORIAL

• Starting Oracle Discoverer Administrator
• Grant Access Privileges to Users
• Granting Business Area Access

CUSTOMIZING THE TUTORIAL

• Customizing Items
• Lists of values (LOV)
• Alternative Sorts
• Calculated Items
• Modifying Content Type
• Designing Complex Folders
• Creating and Working with Hierarchies
• Create Summary Folders

MANAGING THE END USER LAYER

• Creating an EUL
• Multiple EULs
• Migrating Between EUL Releases
• Setting The Default EUL
• EUL Status Workbooks

BUILDING A NEW BUSINESS AREA

• Building the Business Area
• Managing a Business Area

ACCESS PRIVILEGES AND SECRITY

• Using the Privileges Window
• Using the Security Window

ITEM CLASSES AND LIST OF VALUES

• Item Classes
• Lists Of Values
• The Item Class Wizard
• Creating an Alternative Sort Class
• Linking Folders For Drill-To-Detail

JOINS

• Joins
• Outer Joins
• Multi-Item Joins
• Join Properties
• Fan Traps

CALCULATIONS

• Choosing Items
• Choosing SQL Functions

CONDITIONS

• Mandatory Conditions
• Optional Conditions
• Choosing Items For Conditions
• Compound/Complex Conditions

HIERARCHIES

• Item Hierarchies
• Date Hierarchies
• Relating Items and Hierarchies

FOLDERS

• Creating a Custom Folder
• Creating a Complex Folder

SUMMARIES

• Summary Folders
• Summary Redirection

ADVANCED OPTIONS

• Creating Custom PL/SQL Functions
• Registering PL/SQL Functions
• The Command Line Interface
• 10gAS Discoverer Plus and Viewer
• Registry Settings