ORACLE 10g / 11g DISCOVERER Administrator

Course:  ORDSCA
Duration:  2 Days
Level:  I
Course Summary

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.

« Hide The Details
Topics Covered In This Course

INTRODUCTION

  • Benefits of Discoverer
  • Components of Oracle Discoverer
  • Business Areas
  • The Role of the Discoverer Manager

SETTING UP THE TUTORIAL

  • Starting Oracle Discoverer Administrator
  • Grant Access Privileges to Users
  • Granting Business Area Access

CUSTOMIZING THE TUTORIAL

  • Customizing Items
  • Lists of values (LOV)
  • Alternative Sorts
  • Calculated Items
  • Modifying Content Type
  • Designing Complex Folders
  • Creating and Working with Hierarchies
  • Create Summary Folders

MANAGING THE END USER LAYER

  • Creating an EUL
  • Multiple EULs
  • Migrating Between EUL Releases
  • Setting The Default EUL
  • EUL Status Workbooks

BUILDING A NEW BUSINESS AREA

  • Building the Business Area
  • Managing a Business Area

ACCESS PRIVILEGES AND SECRITY

  • Using the Privileges Window
  • Using the Security Window

ITEM CLASSES AND LIST OF VALUES

  • Item Classes
  • Lists Of Values
  • The Item Class Wizard
  • Creating an Alternative Sort Class
  • Linking Folders For Drill-To-Detail

JOINS

  • Joins
  • Outer Joins
  • Multi-Item Joins
  • Join Properties
  • Fan Traps

CALCULATIONS

  • Choosing Items
  • Choosing SQL Functions

CONDITIONS

  • Mandatory Conditions
  • Optional Conditions
  • Choosing Items For Conditions
  • Compound/Complex Conditions

HIERARCHIES

  • Item Hierarchies
  • Date Hierarchies
  • Relating Items and Hierarchies

FOLDERS

  • Creating a Custom Folder
  • Creating a Complex Folder

SUMMARIES

  • Summary Folders
  • Summary Redirection

ADVANCED OPTIONS

  • Creating Custom PL/SQL Functions
  • Registering PL/SQL Functions
  • The Command Line Interface
  • 10gAS Discoverer Plus and Viewer
  • Registry Settings
What You Can Expect

On successfully completing this course, participants will be able 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 Should Take This Course

Oracle Discoverer Administrators, Support Staff, Analysts.

Recommended Prerequisites

Participants should have taken our Oracle Discoverer For End Users, or have equivalent experience. In addition, familiarity with Windows 98/NT/2000/XP, and understanding of Relational Databases is helpful.

Training Style

Short lecture sessions (60%) along with hands-on lab sessions (40%).

« Hide The Details
Related Courses
Code Course Title Duration Level
ORDSCD
ORACLE 10g/11g DISCOVERER DESKTOP For End Users
2 Days
I
Details
ORDSCP
ORACLE 10g / 11g BI DISCOVERER PLUS for End Users
2 Days
I
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]