Discoverer 9i: Discoverer for Administrators (2 day)

Course Overview

This two day course is designed for personnel responsible for the configuration and management of Oracle Discoverer. At the end of this course the successful delegate will be able to create and maintain the end user layer, business areas and grant and control user access.

Audience

This course is designed for personnel responsible for the configuration and management of Oracle Discoverer.

Skills Gained

At the end of this course the successful delegate will be able to:-

• Create the Maintain the End User Layer
• Create and Maintain Business Areas
• Grant and Control User Access

Prerequisites

• Discoverer Desktop for End Users
• SQL

Course Outline

• Introduction to Discoverer Concepts
• Creating and Maintaining the EUL
• Creating Business Areas
• Managing and Developing a Business Area
• Granting Access to a Business Area
• Granting End User Privileges
• Simple, Complex and Custom Folders
• Managing Folders
• Managing Folder Items
• Importing and Exporting from the EUL
• Creating and Using Joins
• Creating and Using Calculations
• Using Custom PL/SQL Functions
• Working with Conditions
• Creating Date and Item Hierarchies
• Using Summary Folders
• Using the Automated Summary Management Feature (ASM)
• EUL Status Workbooks

Follow On Courses

• 9i Discoverer Web Administration
• PL/SQL
• SQL Advanced

Discoverer 9i: Discoverer for Administrators (2 day) / ODRA