• Optimize query performance, using summaries
• Manage and configure Discoverer, using Application Server Control
• Describe the Single Sign On Option supported by Discoverer
• Register Discoverer as a portlet provider with OracleAS Portal
• Add Discoverer portlets to a portal page
• Design, create, and maintain the End User Layer
• Implement and administer Discoverer
• Control user access to and Customize the End User Layer

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