Print Outline in PDF format

Duration: 2 days

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:

• Oracle9i Discoverer For End Users

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

• Understanding of Relational Databases helpful.

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

Course Content:

INTRODUCTION

• Benefits of Discoverer

• Components of Oracle Discoverer

• Business Areas

• The Role of the Discoverer Manager

SETTING UP THE TUTORIAL