Discoverer 10g: Discoverer for Administrators (3 day)

Course Overview

This course is designed for personnel responsible for the configuration and management of Oracle Discoverer with a relational datasource.

Audience

Personnel responsible for the configuration and management of Oracle Discoverer

Skills Gained

By 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
• Understand the relationship between Application Server and Discoverer Components
• Configure Discoverer for the Web

Examinations

N/A

Prerequisites

Attendance on the Pre-Requisite courses or similar knowledge. Practical experience of Oracle Application Server Administration would be an advantage.

Prerequisite Courses

• 10g Discoverer Plus for End Users
• SQL

Course Outline

Topics Covered:

• 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
• Introduction to Application Server and Discoverer
• Starting and Stopping Discoverer Services
• Managing Discoverer Connections
• Monitoring Discoverer
• Discoverer and Oracle Web Cache
• Managing Discoverer Preferences
• Discoverer URL Parameters
• Security and Discoverer

Establishing a Multiple Machine Environment

Follow On Courses

• Oracle 10g Application Server Administration
• PL/SQL
• SQL Advanced

Discoverer 10g: Discoverer for Administrators (3 day) / ODM