Oracle BI : AS Discoverer 10g: Develop an EUL

Request more details:

Description:
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.

View other Oracle Courses available
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
ADVANCED HIERARCHICAL QUERIES :
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