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
