Oracle Discoverer Administrator 10g: Develop an EUL

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.

course content details

	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