Oracle Discoverer Administrator 10g: Develop an EUL

What you will learn
 This class is applicable to Oracle 9iAS Discoverer users.

This course introduces students to Oracle Discoverer Administrator 10g. As Discoverer managers, students learn 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.



Audience
 Business Analysts
Data Warehouse Administrator
Data Warehouse Analyst

Prerequisites
 OracleAS Discoverer 10g: Create Queries and Reports

Course Objectives
 Design, create, and maintain the End User Layer
Implement and administer Discoverer
Control user access to the End User Layer
Customize the End User Layer
Optimize query performance, using summaries
Manage and configure Discoverer, using Application Server Control
Describe the Single Sign On Option supported by Discoverer
Register Discoverer as a portlet provider with OracleAS Portal
Add Discoverer portlets to a portal page

Course Topics
Introduction to Oracle Discoverer Administrator
 Discoverer in Oracle Platform
Oracle's Business Intelligence Tools
Discoverer Architecture
Key Terminology
The Role of the Data Administrator
The Training Business Areas and Data Models

Creating the End User Layer and Business Areas
 Discoverer Connections
Creating and Editing Public and Private Connections
Creating the Initial EUL
Creating an Applications Mode EUL
Designing Business Areas and Identifying and Selecting Objects to Load
Creating a Business Area and Loading meta data
Viewing Folder and Item Properties
Exporting and Importing

Creating Conditions, List of Values, and Alternative Sorts
 Item Classes
Creating List of Values
Creating an Alternative Sort
Creating Conditions

Customizing Properties, Creating Calculated Items and Registering PL/SQL Functions
 Customizing Folder Properties
Customizing Item Properties
Creating Simple and Complex Calculated Items
Registering and Importing PL/SQL Functions

Creating Complex and Custom Folders
 Creating Joins
Join Options
Creating Complex Folders
Creating Custom Folders
Custom LOV

Creating Analytical and Aggregate Items
 Requirement for Analytical Functions
Categories of Analytical Functions
Creating Items with Analytical Functions
Creating Aggregate Calculations

Creating Drills
 Identifying end user drill facilities
Creating an Item hierarchy by using Hierarchy Wizard
Setting up a Hyperdrill Plug-in
About Default Date Hierarchy
Creating a Custom Date Hierarchy
Creating a Non-standard Calendar

Materialized Views and Summary Management
 Summary Tables and Folders
Discoverer Summaries
Materialized Views
Uses of Materialized Views
Requirements for Creating Summaries
Methods for Creating Summary Folders
Managing Summary Folders
Summary Combination Strategies

Automated Summary Management
 Automated Summary Management Wizard
Analyzing Folders
Setting Properties
Allocating Space and Viewing Performance

Managing Batch Scheduling
 How Batch Reports Works?
Batch Repository User Versus Private User
Changes that affect Batch Reports
Setting up Scheduled Workbook Privileges
Managing Scheduled Workbooks in Discoverer Administrator
Unscheduling a Workbook

Maintaining the End User Layer
 Effects of Database Changes
Refreshing the Business Area
Deleting Folders
Deleting a Business Area
Migrating fro Development to Production
Analyzing the End User Layer

Administering Multiple End User Layers and Automating Tasks
 Multiple EULs
Creating an EUL for a New User
Assigning a Default EUL
Automating Tasks through the Command Line Interface
Using the Oracle Discoverer EUL Command Line for Java
Creating an EUL through the Command Line Interface

Configuring Discoverer
 Overview of Oracle Application Server Architecture
OracleAS Discoverer Architecture
Customizing the Discoverer Viewer Look and Feel
Managing the Discoverer Server Service Using the Application Server Control
Configuring Discoverer through Application Server Control
Web Cache Integration

Portal Integration and Single Sign-On
 Overview of Single Sign-On
Registering the Discoverer Portlet Provider
Adding Discoverer Portlets to a Portal Page
Customizing Portlets

Related Courses
 OracleBI Discoverer 10g: Analyze and Develop an EUL Self-Study CD