Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

Oracle Discoverer 10g: Developing An EUL

Course:   ODISEUL
Duration:   3 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/ODISEUL.html
 
Course Summary

This course teaches 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.

Topics Covered In This Course

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
What You Can Expect
Who Should Take This Course

Business Analysts, Data Warehouse Administrators and Data Warehouse Analysts.

Recommended Prerequisites

Students in this course should have previously completed the Oracle AS Discoverer 10g: Create Queries & Reports course.

Related Courses
Code Course Title Duration Level
ODISQR
Oracle AS Discoverer 10g Create Queries and Reports
2 Days
I
Details
WLPORT
Developing WebLogic 11 Portlet Applications
4 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.