By using our website you agree to our use of cookies.

Oracle Discoverer for Administrators

3 Day Course
Code ODM

Book Now - 1 Delivery Method Available:

Scheduled Virtual Onsite

Overview

This course is designed for delegates intending to set up and administer the Discoverer End User.  The efficient creation of an End User Layer is critical to the provision of pertinent data to the End User of Discoverer.

The delegates will practise:

  • Creating and Maintaining the EUL
  • Creating, Managing and Developing Business Areas
  • Managing Simple, Complex and Custom Folders
  • 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)
  • Using the EUL Status Workbooks
  • Using the Oracle Enterprise Manager Website to Configure Discoverer Plus and Viewer
  • Starting and Stopping the Discoverer Services
  • Creating Public Connections to Discoverer Plus
  • Enabling Private Connections to Discoverer Viewer
  • Maintaining Discoverer Preferences and the Use of the Web Cache
View detailed Course Modules

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.

Modules

Hide all

What is Oracle Discoverer (8 topics)

  • Overview
  • Discoverer Components
  • The Discoverer Administration Interface
  • The Data Page
  • The Hierarchies Page
  • The Item Classes Page
  • The Summaries Page
  • The Discoverer Workbook Window

Database Requirements for Using Discoverer (4 topics)

  • Introduction
  • Preparing for the use of Scheduled Workbooks
  • Requirements for Summary Management
  • Query Prediction

The End User Layer (4 topics)

  • Introduction - the Purpose of the End User Layer
  • Creating an EUL
  • Managing the EUL
  • Deleting an EUL

Business Area Management (5 topics)

  • Introduction - Business Areas and their Use
  • Building a New Business Area
  • Building a New Business Area with the Load Wizard
  • Applying security and privileges to a Business Area
  • Scheduling workbooks

Folder Management (9 topics)

  • Introduction - the Types of Folder
  • Creating a Simple Folder
  • Creating a Complex Folder
  • Creating a Custom Folder
  • Folder Properties
  • Editing the SQL of a Custom Folder
  • Sharing Folders across Business Areas
  • Folder Operations
  • Importing and Exporting using Discoverer Administrator

Management Items and Item Classes (5 topics)

  • Introduction - Items, Item Classes and their Use
  • Item Properties
  • Deleting an Item
  • Creating and Editing Item Classes
  • Using the Item Class Page to Manage Item Classes

Joins, Calculations, Conditions and Hierarchies (5 topics)

  • Introduction - the Use and Purpose of these Objects
  • Joins
  • Calculations
  • Conditions
  • Hierarchies

Summary Folders (6 topics)

  • Introduction - the Purpose of Summary Folders
  • What is a summary Folder?
  • Creating a Summary Folder
  • Editing and Repairing Summary folders
  • Summary Folder Properties
  • Automated Summary Management

EUL Status Workbooks (3 topics)

  • Introduction - What are EUL Status Workbooks?
  • Installing the EUL v5 Business Area
  • Workbook Content

Introduction to Application Server (10 topics)

  • Introduction to the Application Server
  • A Simple Application Server Environment to Support Discoverer
  • Oracle Application Server Installation Types
  • Managing an Application Server
  • The Enterprise Manager Website
  • The Application Server Farm Home Page
  • The Application Server Instance Home Page
  • The Components' Home Pages
  • Starting and Stopping Components and their Effects
  • Clues to Potential Web Problems

Discoverer Architecture (4 topics)

  • Introduction - Discoverer Architecture on the Web
  • The Discoverer Services
  • Accessing Discoverer Plus
  • Accessing Discoverer Viewer

Configuring Discoverer for the Web (9 topics)

  • Introduction - the Discoverer Configuration Page
  • Issues Concerning Running Discoverer Plus for the First Time
  • Managing Discoverer Services
  • Shutting Down the Discoverer System
  • Using Discoverer in a Multi-Machine Environment
  • Creating Public and Private Discoverer Connections
  • Discoverer and Oracle Single Sign-On
  • Configuring Single Sign-On to Protect Discoverer
  • Connecting to Discoverer with Single Sign-On

Influencing Discoverer Behaviour (5 topics)

  • Introduction - Discoverer Preferences and Oracle Web Cache
  • Maintaining Discoverer Preferences
  • Using Parameters in the Discoverer URLs
  • Discoverer and the Oracle Web Cache
  • Configuring Discoverer to use the Web Cache

Prerequisites

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

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

  • Oracle Discoverer Desktop for End Users

    A 2-day Training Course on Discoverer for End Users; Create Discoverer Workbooks; View, Create, Modify & Run ad hoc queries; Chart & analyse data.

    2 Day Course Course Code ODE
    Scheduled Virtual Onsite
  • PL/SQL

    A 2-day Training Course on PL/SQL; Designed for those who need to write program scripts using Oracle's Procedure Language; corresponds to exam 1Z0-001

    2 Day Course Hands On Training Next Date January 20th in London 22 Scheduled Dates in 7 Locations Course Code OPI
    Scheduled Virtual Onsite
Oracle DBA Training Courses

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections