| |
- In House
- Public
- Computer Based
|
|
|
Further Details
Extra Course Available on Request:
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
Guide price
£1500pp - £2500pp inc admin |