This class will teach students the purpose and capabilities of the Discoverer 9i Administrator tool. This class teaches students 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. This course can only be sold in conjunction with the Oracle9i Discoverer For Desktop Users since it is a prerequisite.
Oracle Training Prerequisites
- The course Introduction To Oracle9i SQL
- The course Oracle9i Discoverer For Desktop Users
Oracle Training Audience
Data Administrators of the Discoverer tool
Suggested Next Courses
The course Oracle 9i Discoverer For Administrators
Oracle Training Course duration
1 Day
Oracle Training Course outline
CREATING AND MANAGING BUSINESS AREAS - DISCOVERER COMPONENTS
- INSTALLING THE EUL
- STARTING ORACLE 9I 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
