OR545 Oracle Discoverer for Administrators

OVERVIEW

 Oracle Business Intelligence Discoverer Plus is a web-based utility that can be used to specify queries and access data in the database according to the specifications given. BI Discoverer makes finding the data easier than it often is with other interfaces.

This course gives participants hands-on experience with administration tasks for Oracle’s Graphical User Interface (GUI) based ad hoc query and data access tool – Discoverer.  Students will build the End User Layer for Discoverer.

DURATION:  2 Days

OBJECTIVES

• Define the Administrator's Responsibilities
• Create an End User 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

INTENDED AUDIENCE

This course is designed for people who will be designing, maintaining and/or creating queries from a relational database using Oracle Discoverer, primarily Data Warehouse Administrator.

PREREQUISITES

Introduction to Relational Database, and basic SQL as well as working knowledge of the editor (Wordpad,  Notepad, or VI Edit) is required to perform the lab exercises.

FORMAT/MATERIALS

This course includes a combination of lecture, discussion and numerous computer lab exercises.  Each participant will receive a copy of the course manual, which will prove to be a valuable reference after class.

CONTENT

INTRODUCTION