Oracle Discoverer for Administrators

     This hands-on course teaches students the purpose and capabilities of the Oracle Discoverer Administrator tool. This tool allows administrators to create an End User Layer which serves as the metalayer between the database Discoverer. Students will also learn how to create and manage business areas which hide the complexity of the database and provides a user-friendly view of the data for end users.

Topics Covered

  • Discoverer benefits, components and terminology
  • Define the Administrator's responsibilities
  • Installing the end user layer
  • Creating and managing business areas
  • Working with folders and joins
  • Working with items and item classes
  • Creating calculated items
  • Registering PL/SQL functions
  • Working with conditions
  • Complex conditions
  • Working with item hierarchies and date hierarchies
  • Creating and maintaining summaries
  • Summary tables and materialized views
  • Refreshing summaries
  • User privileges
  • Business area security
  • Setting the default end user layer


     This course is designed for Administrators of the Oracle Discoverer Desktop tool and support staff.


     Oracle Discoverer Desktop for End Users and familiarity with Oracle SQL.


     This class will present a thorough knowledge of administrating the Discoverer tool. Upon completion of this course, each student can apply this knowledge to their company's own data model.

Furnished Materials:

  • PC Workstation for use during training
  • Student Manual

Recommended Follow-On Course

  • None


  • 1 Day


  • $495

Training Dates:

Sign Up