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 and 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.

Class Agenda:

• 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

Prerequisites:

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

Audience:

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

Course Benefits:

• 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.

Materials Furnished:

• Student Manual

Course Length: One Day

List Price: $495