Course Description:

This course provides hands-on experience with administration tasks for Oracle’s Graphical User Interface (GUI) based ad hoc query and data access tool – Discoverer.

You can learn how to…

• Define the Administrator’s Responsibilities

• Create a Desktop layer

• Grant Access Privileges

• Create Folders

• Create Items

• Create Hierarchies

• Create a Business Area

• Synchronize a Business Area

• Delete Objects

• Create Calculations

• Create Conditions

• Create Joins

Who Needs to Attend:

• Oracle Discoverer Administrators

• Support Staff

• Analysts

Prerequisites:

• Oracle10g Discoverer For End Users

• Familiarity with Windows 98/NT/2000/XP.

• Understanding of Relational Databases helpful.

Course Content:

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 SECURITY

• 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

• 10g AS Discoverer Plus and Viewer

• Registry Settings

Course Labs:

1. Administrator Components

2. Tutorial Setup

3. Tutorial Customization

4. Building an End User Layer

5. Building a New Business Area

6. Access Privileges and Security

7. Creating Item classes

8. Defining Joins

9. Creating Complex Calculations

10. Creating Optional and Mandatory Conditions

11. Creating Item and Date Hierarchies

12. Creating Custom and Complex Folders

13. Creating Summary Folders

14. Creating Custom Functions / Advanced Options