Oracle Discoverer for Administrators

AUDIENCE: This course is for Oracle Administrators supporting Discoverer.
PREREQUISITES: Attending Verhoef''s Oracle SQL Part 1 or equivalent knowledge is essential.
DURATION: 3 days. Hands on.
OBJECTIVES: This class will teach students the purpose of, capabilities and 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. Students 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.
COURSE CONTENT:
Module
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 the analytic functions (optional)

Creating and Managing Business Areas
Discovering components
Installing the EUL
Starting Oracle Discoverer Administrator
Using the CREATE EUL Wizard
Deleting and 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 on 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 with 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
Managed Scheduled Workbooks
Refreshing a Business Area
Setting the Default EUL
Command Line Options

Using EUL Status Workbooks