Oracle9i Discoverer For Administrators Course

This class will teach participants the purpose and capabilities of the Discoverer 9i Administrator tool. This class teaches participants how to use the Discoverer Administrator tool. This tool allows users to create an End User Layer, which serves as a metalayer between the data source and Discoverer. Participants will also learn how to create and manage business areas, which will hide the complexity of the data source and provide a user-friendly view of the data for end users.

This class will present a thorough knowledge of the Discoverer tool.  Thereafter each user can learn to apply this knowledge to the company's internal data model. Data administrators are in the best position to explain the company's data model. This course can only be sold in conjunction with the Oracle9i Discoverer For Desktop Users (Volume I) since it is a prerequisite.

This course is designed for Administrators using Discoverer on the desktop.

Upon completion of this course, the participant will be able to:
> Create Queries
> Create and Manage Business Areas
> Work with Folders and Joins
> Work With Conditions And Hierarchies

Volume I – Day 1-2:
Creating Queries
Query Management
Modifying The Display
Working With Conditions And Parameters
Working With Exceptions And Calculations
Working With Sorts, Totals, Percentages
Drilling The Data
Graphing Data
Workbook Maintenance
Working With SQL And Setting Options
Using SQL Functions In Discoverer
Introduction To Analytic Functions (Optional)

Volume II – Day 3:
Creating And Managing Business Areas
Discoverer Components
Installing The EUL
Starting Oracle9i Discoverer Administrator
Using The Create EUL Wizard
Deleting An End User Layer
Creating A Business Area Using The Load Wizard
The Work Area
Managing Business Areas
Opening A Business Area
Closing Business Areas
Adding Business Areas
Deleting Business Areas
Business Area Properties
Online Help
Working With Folders And Joins
Working With Folders
Adding Folders With The Load Wizard
Managing Folders
Deleting Folders
Creating Custom Folders
Adding An Empty Complex Folder
Creating Complex Folders
Working With Joins
Creating Joins
Editing Joins
Deleting Joins
Join Properties
Sorting Folders
Working With Items And Item Classes
Working With Items
Creating Calculated Items
Editing Items
Deleting Items
Sorting Items
Registering Pl/SQL Functions
Item Classes
Creating Item Classes With The Item Class Wizard
The Item Classes Tab
The Effect Of The Item Class
Editing Item Classes
Deleting Item Classes
Item Class Properties

Working With Conditions And Hierarchies
Working With Conditions
Creating Conditions
Editing Conditions
Deleting Conditions
Condition Properties
Working With Hierarchies
Creating Item Hierarchies With The Hierarchy Wizard
Creating Date Hierarchies With The Hierarchy Wizard
The Hierarchies Tab
The Effect Of The Date Hierarchy
Editing Hierarchies
Deleting Hierarchies
Hierarchy Properties
Security, Privileges, And Summaries
Business Area Security
User Privileges
Summaries And Materialized Views
Creating And Maintaining Summaries
Registering An External Summary Table
The Summaries Tab
Editing And Refreshing Summaries
Deleting Summaries
Summary Properties
What Is Automated Summary Management?
Accessing The Underlying Materialized View
Business Area Maintenance
Exporting, Importing
Manage Scheduled Workbooks
Refreshing A Business Area
Setting The Default EUL
Command Line Options

Using EUL Status Workbooks

Oracle9i SQL (RT 262)
Oracle9i Discoverer for Desktop Users (RT 280)