Oracle Discoverer Administrator Training

Oracle Discoverer Administrator– 2 Days

Discoverer Concepts and Components

• Discoverer benefits, components and terminology
• Define the Administrator's responsibilities

Working End User Layers

• Installing the end user layer
• Creating and managing business areas
• Working with folders and joins
• Working with items and item classes
• Creating analytical items
• Creating aggregate items
• Creating calculated items
• Registering PL/SQL functions
• Working with conditions
• Complex conditions

Working with LOV and hierarchies

• Creating Lists of Values (LOV)
• Creating Alternative Sorts
• Working with item hierarchies and date hierarchies
  

Working with Drills

• Identifying End User Drill Facilities
• Using the Hierarchy Wizard to Create an Item Hierarchy
• Using the Item Class Wizard to Create a Drill-to-Detail
• Explaining the Default Date Hierarchy

Working with Summaries for performance

• Creating and maintaining summaries
• Summary tables and materialized views
• Refreshing summaries
  

Securing the EUL

• User privileges
• Business area security
• Setting the default end user layer

Managing Batch Scheduling

• Describing Batch Reporting
• Specifying a Batch Repository Owner
• Describing Changes that Affect Batch Reports
• Setting up Scheduled Workbook Privileges