Oracle Discoverer Administration

Duration 3 days
Delivered by iWareLogic’s team of expert Oracle BI instructor and consultants, this course covers the following topics:

 

  • Oracle's Business Intelligence Tools
  • Discoverer Architecture
  • Key Terminology
  • The Role of the Data Administrator
  • The Training Business Areas and Data Models
  • 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
  • Item Classes
  • Creating List of Values
  • Creating an Alternative Sort
  • Creating Conditions
  • Customizing Folder Properties
  • Customizing Item Properties
  • Creating Simple and Complex Calculated Items
  • Registering and Importing PL/SQL Functions
  • Creating Joins
  • Join Options
  • Creating Complex Folders
  • Creating Custom Folders
  • Custom LOV
  • Requirement for Analytical Functions
  • Categories of Analytical Functions
  • Creating Items with Analytical Functions
  • 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
  • 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 Wizard
  • Analyzing Folders
  • Setting Properties
  • Allocating Space and Viewing Performance
  • 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
  • Effects of Database Changes
  • Refreshing the Business Area
  • Deleting Folders
  • Deleting a Business Area
  • Migrating fro Development to Production
  • Analyzing the End User Layer
  • 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
  • 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
  • Overview of Single Sign-On
  • Registering the Discoverer Portlet Provider
  • Adding Discoverer Portlets to a Portal Page
  • Customizing Portlets


The course includes slides and delegate notes, and can be delivered on-site or through partner organizations. Quotations can be provided for custom versions of this course, or to include additional areas not covered in the regular agenda.


To book this course for you or your organization, or for more information, contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it

 
 
Moving Stones Technologies