Oracle Discoverer Administrator 10g: Develop an EUL

3 Day Course
Hands On
Official Oracle Curriculum

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite


This course introduces students to Oracle Discoverer Administrator 10g. As Discoverer managers, students learn how to create and customize the End User Layer, how to create business areas and folders, and define analytical facilities for end users. Students also learn about the different types of connection mechanisms supported by OracleAS Discoverer and how to control the user access to the End User Layer. Students learn how to use materialized views and automated summary management. In addition, students learn how to use Oracle Enterprise Manager 10g Application Server Control to configure OracleAS Discoverer.

Course Objectives

On completing the course, you will be able to:

- Design, create, and maintain the End User Layer
- Implement and administer Discoverer
- Control user access to the End User Layer
- Customize the End User Layer
- Optimize query performance, using summaries
- Manage and configure Discoverer, using Application Server Control
- Describe the Single Sign On Option supported by Discoverer
- Register Discoverer as a portlet provider with OracleAS Portal
- Add Discoverer portlets to a portal page

Who Should Attend

- Data Warehouse Administrators
- Business Analysts
- Data Warehouse Analysts

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Introduction to Oracle Discoverer Administrator (6 topics)

  • Discoverer in Oracle Platform
  • Oracle's Business Intelligence Tools
  • Discoverer Architecture
  • Key Terminology
  • The Role of the Data Administrator
  • The Training Business Areas and Data Models

Creating the End User Layer and Business Areas (8 topics)

  • Discoverer Connections
  • Creating and Editing Public and Private Connections
  • Creating the Initial EUL
  • Creating an Applications Mode EUL
  • Designing Business Areas and Identifying and Selecting Objects to Load
  • Creating a Business Area and Loading meta data
  • Viewing Folder and Item Properties
  • Exporting and Importing

Creating Conditions, List of Values, and Alternative Sorts (4 topics)

  • Item Classes
  • Creating List of Values
  • Creating an Alternative Sort
  • Creating Conditions

Customizing Properties, Creating Calculated Items and Registering PL/SQL Functions (4 topics)

  • Customizing Folder Properties
  • Customizing Item Properties
  • Creating Simple and Complex Calculated Items
  • Registering and Importing PL/SQL

Creating Complex and Custom Folders (5 topics)

  • Creating Joins
  • Join Options
  • Creating Complex Folders
  • Creating Custom Folders
  • Custom LOV

Creating Analytical and Aggregate Items (4 topics)

  • Requirement for Analytical Functions
  • Categories of Analytical Functions
  • Creating Items with Analytical Functions
  • Creating Aggregate Calculations

Creating Drills (6 topics)

  • Identifying end user drill facilities
  • Creating an Item hierarchy by using Hierarchy Wizard
  • Setting up a Hyperdrill Plug-in
  • About Default Date Hierarchy
  • Creating a Custom Date Hierarchy
  • Creating a Non-standard Calendar

Materialized Views and Summary Management (8 topics)

  • Summary Tables and Folders
  • Discoverer Summaries
  • Materialized Views
  • Uses of Materialized Views
  • Requirements for Creating Summaries
  • Methods for Creating Summary Folders
  • Managing Summary Folders
  • Summary Combination Strategies

Automated Summary Management (4 topics)

  • Automated Summary Management Wizard
  • Analyzing Folders
  • Setting Properties
  • Allocating Space and Viewing Performance

Managing Batch Scheduling (6 topics)

  • How Batch Reports Works?
  • Batch Repository User Versus Private User
  • Changes that affect Batch Reports
  • Setting up Scheduled Workbook Privileges
  • Managing Scheduled Workbooks in Discoverer Administrator
  • Unscheduling a Workbook

Maintaining the End User Layer (6 topics)

  • Effects of Database Changes
  • Refreshing the Business Area
  • Deleting Folders
  • Deleting a Business Area
  • Migrating from Development to Production
  • Analyzing the End User Layer

Administering Multiple End User Layers and Automating Tasks (6 topics)

  • Multiple EULs
  • Creating an EUL for a New User
  • Assigning a Default EUL
  • Automating Tasks through the Command Line Interface
  • Using the Oracle Discoverer EUL Command Line for Java
  • Creating an EUL through the Command Line Interface

Configuring Discoverer (6 topics)

  • Overview of Oracle Application Server Architecture
  • OracleAS Discoverer Architecture
  • Customizing the Discoverer Viewer Look and Feel
  • Managing the Discoverer Server Service Using the Application Server Control
  • Configuring Discoverer through Application Server Control
  • Web Cache Integration

Portal Integration and Single Sign-On (4 topics)

  • Overview of Single Sign-On
  • Registering the Discoverer Portlet Provider
  • Adding Discoverer Portlets to a Portal Page
  • Customizing Portlets

or call:408-759-5074

Course PDF


Share this Course


Recommend this Course