Oracle Discoverer 10g: Developing An EUL
Duration: 3 Days
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
CREATING AND MANAGING BUSINESS AREAS
WORKING WITH FOLDERS AND JOINS
WORKING WITH ITEMS AND ITEM CLASSES
WRITING AND REGISTERING A PL/SQL FUNCTION
WORKING WITH CONDITIONS AND HIERARCHIES
HIERARCHICAL QUERIES (CONNECT BY PRIOR)
ADVANCED HIERARCHICAL QUERIES
SECURITY AND PRIVILEGES
DISCOVERER SUMMARIES/MATERIALIZED VIEWS
BUSINESS AREA MAINTENANCE
USING EUL STATUS WORKBOOKS
USING THE COMMAND LINE INTERFACE
ADMINISTERING DISCOVERER USING ENTERPRISE MANAGER SERVER CONTROL
DISCOVERER DEBUG TRACE
What You Can Expect
Who Should Take This Course
Business Analysts, Data Warehouse Administrators and Data Warehouse Analysts.
Students in this course should have previously completed the Oracle AS Discoverer 10g: Create Queries & Reports course.
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.
Can't find the course you want?
Call us at 800.533.3893, or
email us at email@example.com