Oracle Training : Oracle Discoverer 10g: Develop An EUL

This Oracle 10g courseware training guide book will teach how to create and customize the End User Layer, how to create business areas and folders, and define analytical facilities for end users. Students also learn about the different types of connection mechanisms supported by OracleAS Discoverer and how to control the user access to the End User Layer. Students learn how to use materialized views and automated summary management. In addition, students learn how to use Oracle Enterprise Manager 10g Application Server Control to configure OracleAS Discoverer.

Oracle Training Audience

Business Analysts
Data Warehouse Administrators
Data Warehouse Analysts

Oracle Training Prerequisites

The course Oracle AS Discoverer 10g: Create Queries & Reports

Oracle Training Suggested Next Courses

The course Oracle Reports 10g: Build Reports

Oracle Training Course Objectives

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

Oracle Training Course duration

3 Days

Oracle Training Course outline

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

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved