INTRODUCTION TO DISCOVERER DESKTOP AND WEB INTERFACES DISCOVERER END USER TOOLS

• DEVELOPING REPORTS
• WORKBOOK MAINTENANCE
• USING CONDITIONS
• DRILLING THE DATA

CREATING AND MANAGING BUSINESS AREAS

• DISCOVERER COMPONENTS
• INSTALLING THE EUL
• STARTING ORACLE10G 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

WRITING AND REGISTERING A PL/SQL FUNCTION

• THE NEED FOR PL/SQL FUNCTIONS
• WRITING THE FUNCTION
• REGISTERING THE FUNCTION
• USING THE FUNCTION

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

HIERARCHICAL QUERIES (CONNECT BY PRIOR)

• USING HIERARCHICAL RELATIONSHIPS
• ONE TO MANY (1:N) HIERARCHY
• MANY TO MANY (M:N) HIERARCHY

ADVANCED HIERARCHICAL QUERIES

• EXPANDING DISPLAYS FOR HIERARCHICAL QUERIES
• ONE TO MANY HIERARCHY - ANY LEVEL
• MANY TO MANY HIERARCHY - ANY LEVEL
• CREATING THE BOM QUERY IN DISCOVERER DESKTOP

SECURITY AND PRIVILEGES

• BUSINESS AREA SECURITY
• USER PRIVILEGES

DISCOVERER SUMMARIES/MATERIALIZED VIEWS

• SUMMARIES AND MATERIALIZED VIEWS
• CREATING AND MAINTAINING SUMMARIES
• CREATING SUMMARIES WITH THE SUMMARY WIZARD
• CREATING SUMMARIES USING QUERY PERFORMANCE STATISTICS
• 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

USING EUL STATUS WORKBOOKS

• WHAT ARE EUL STATUS WORKBOOKS?
• THE DISCOVERER V5 EUL BUSINESS AREA
• SETUP FOR EUL STATUS WORKBOOKS
• USING EUL STATUS WORKBOOKS

USING THE COMMAND LINE INTERFACE

• WHAT IS THE DISCOVERER COMMAND-LINE INTERFACE
• USING THE DISCOVERER ADMIN COMMAND-LINE INTERFACE
• USING THE DISCOVERER DESKTOP COMMAND-LINE INTEFRACE

ADMINISTERING DISCOVERER USING ENTERPRISE MANAGER SERVER CONTROL

• DISCOVERER APPLICATION SERVER ARCITECTURE/OVERVIEW
• MONITORING AS APPLICATION COMOPNENTS
• MONITORING DISCOVERER COMPONENTS
• CUSTOMIZE DISCOVERER PLUS LOOK AND FEEL
• CUSTOMIZE DISCOVERER VIEWER LOOK AND FEEL

DISCOVERER DEBUG TRACE

• REASONS FOR CREATING A DEBUG TRACE
• SETTING UP THE DEBUG TRACE
• GENERATING THE DEBUG TRACE
• ABOUT THE DEBUG TRACE LOG FILE
• USING METALINK