Oracle AS Discoverer 10g Develop an EUL Study Guide

1-4188-1119-X © 2006 Publish date: July 26, 2005

Buy Now: $149.99

Course ID: oracle-as-disc-10g-deveul-sg

The Oracle AS Discoverer 10g Develop an EUL study guide is one of our Oracle computer training books that will teach you how to create and customize the End User Layer as well as business areas and folders, and how to define analytical facilities for end users.

By choosing this self-directed course, you will also learn about the various connection mechanisms that are supported by Oracle AS Discoverer, controlling user access to the End User Layer, using materialized views, automated summary management, and using Oracle Enterprise Manager 10g Application Server Control for configuring Oracle AS Discoverer.

The Oracle AS Discoverer 10g Develop an EUL courseware is a comprehensive manual that you can use alongside traditional training classes or as a standalone tool to master End User Layer techniques on your own. Because of its handy, portable format, you can study when and where you want. Keep the manual in your briefcase or backpack and study when time permits. You can advance your Oracle skills according to a schedule of your own design without the need for attending expensive and time-consuming classes.

Whether you complete the Oracle AS Discoverer 10g Develop an EUL courseware in a few days or over many weeks is up to you. The end result will be the same, you will have received high-quality instruction covering difficult concepts and delivering real-world skills you can put to use right away.

Course Contents

An overview of Discoverer Desktop and web interfaces Discoverer end user tools

• Generating reports
• Maintaining workbooks
• Working with conditions
• Drilling the data

Creating and managing business areas

• Discoverer's components
• How to install the EUL
• How to start Oracle10g Discoverer Administrator
• Working with the Create EUL Wizard
• How to delete an end user layer
• How to create business areas with the Load Wizard
• Exploring the work area
• Managing, opening, closing, adding, and deleting business areas
• Business area properties
• Accessing online help

Using folders and joins

• Folder basics
• How to add folders
• How to manage folders
• How to delete folders
• How to create custom folders
• How to add empty complex folders
• How to create complex folders
• Using joins
• Creating joins
• Modifying joins
• How to delete joins
• Join properties
• How to sort folders

Using items and item classes

• Using items
• Calculated items
• Modifying items
• How to delete items
• How to Sort items
• How to register PL/SQL functions
• Item classes
• Using the Item Class Wizard to create item classes
• Exploring Item Classes tab
• Item Class effects
• Modifying Item Classes
• How to delete Item Classes
• Setting Item Class properties

Writing and registering PL/SQL functions

• The need for PL/SQL functions
• How to write the function
• How to register the function
• Using the function

Using conditions and hierarchies

• Using conditions
• Creating conditions
• Modifying conditions
• Removing conditions
• Setting condition properties
• Using hierarchies
• Creating item hierarchies
• Creating date hierarchies
• Working with the hierarchies tab
• Date hierarchy effects
• Modifying hierarchies
• Removing hierarchies
• Setting hierarchy properties

Hierarchical queries 

• Working with hierarchical relationships
• One-to-many hierarchy
• Many-to-many hierarchy

Using advanced hierarchical queries

• How to expand displays for hierarchical queries
• One-to-many hierarchy (any level)
• Many-to-many hierarchy (any level)
• Working with BOM queries in Discoverer Desktop

Security and privileges

• Setting business area security
• Setting user privileges

Discoverer summaries and materialized views

• Exploring summaries and materialized views
• Working with summaries
• Using the Summary Wizard to create summaries
• Query performance statistics
• How to registering an external summary table
• Exploring the summaries tab
• How to edit and refresh summaries
• How to delete summaries
• Setting summary properties
• Automated summary management?
• Underlying materialized views

Business area maintenance

• Exporting and importing
• Managing scheduled workbooks
• How to refresh business areas
• How to set the default EUL

Working with EUL status workbooks

• An overview of EUL status workbooks
• Exploring the Discoverer v5 EUL business area
• A look at setting up EUL status workbooks
• Working with EUL status workbooks

Working with the command line interface

• An overview of the Discoverer command-line interface
• Working with the Admin command-line interface
• Working with the Desktop command-line interface

Administering Discoverer by using the Enterprise Manager Server Control

• An overview of Discoverer application server architecture
• How to monitor AS components
• How to monitor Discoverer components
• Customizing Discoverer Plus
• Customizing Discoverer Viewer

Discoverer debug trace

• Why create a debug trace?
• How to set up the debug trace
• How to generate the debug trace
• Exploring the debug trace log file
• Working with MetaLink