Discoverer for Administrators

 Click here

Course Overview

This course introduces Oracle Discoverer Administrator. As Discoverer administrators, students learn how to install, maintain and customize the End User Layer, how to create business areas and folders (simple, custom and complex), and define analytical facilities for end users. Students also learn about the different types of connection mechanisms and end user layers supported by Discoverer and how to control and secure the user access to the End User Layer. Students learn how to use materialized views and automated summary management to facilitate high performance reporting. Students learn how to use Oracle Enterprise Manager Application Server Control to configure OracleAS Discoverer.

Course Goals

• Design, install, customize and maintain the End User Layer
• Implement and administer Discoverer
• Control and secure user access to the End User Layer
• Optimize query performance, using summaries and materialized views
• Manage and configure Discoverer, using Application Server Control
• Single Sign On Option supported by Discoverer
• Discoverer as a portlet provider with OracleAS Portal
• Discoverer portlets to a portal page

Prerequisites

• Discoverer for End Users

Who Should Attend?

• IT Staff Maintaining Discoverer
• Data Warehouse Administrators
• Technical Business Analysts
• Data Warehouse Analysts

Course Materials

• Discoverer for Administrators Course Notes
• Discoverer Reference Book

Duration

• Three (3) days

Course Outline

• Discoverer Administration Introduction
  • This lesson introduces Oracle Discoverer Administration Edition concepts
  • Past and current versions of Discoverer including their uses and technology
• End User Layers
  • Creating a standard EUL
  • Creating an Application mode EUL
  • Creating and designing a Business Area
  • Business Area customizations
• Conditions, List of Values, and Alternative Sorts
  • Item Classes to support LOV
  • Creating Conditions and Advanced Sorts
• Properties, Calculations, and Registering PL/SQL Functions
  • Customizing Folder and Item Properties
  • Calculated items, SQL Functions, and PL/SQL Functions
• Complex and Custom Folders
  • Creating Joins, Complex and Custom Folders
• Hierarchies to Support Drills
  • Using the Hierarchy Wizzard to create an Item Hiearchy
• Summary Folders
  • Discoverer Summary Tables and Folders
  • Use the Summary Management Wizzard to Automate
• Batch Scheduling
  • Batch Scheduling Workbooks that take a long time to run or must be run at regular intervals
  • View and manage scheduled workbooks
• End User Layer Maintenance
  • Deleting Folders and Business Areas
  • Refreshing a BA to see a database change
• Discoverer Command Line Interface
  • How to create and run a command file
• Using Discoverer with Oracle Applications and Discoverer Based Business Intelligence
  • The difference between Standard and Application security
  • Overview of the Discoverer based Business Intelligence BIS
• Discoverer Advanced Topics
  • Registry settings, predicting query performance, EUL status workbooks, Oracle Application Server, and upgrading
  • Managing Discoverer middle tier with Oracle Enterprise Manager
  • Using Oracle Discoverer with Oracle AS Reports, Web Cache, Login Server, Portal and Warehouse Builder