Professional Training

Prerequisites

Oracle Application Server 10g: Administration I

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