Oracle 10g Discoverer for Administrators
Course
In London-City
Description
-
Type
Course
-
Location
London-city
The Oracle Discoverer Administration training course is designed for delegates intending to set up and administer Business Areas within a Discoverer End User Layer (EUL). Understanding and efficiently utilizing the features of the Discoverer Administration tool is critical to the provision of pertinent data to End Users of Discoverer Plus or Discoverer Desktop. Skills GainedThe delegates will practise:Creating and Maintaining the Oracle Discoverer EULCreating, Managing and Developing Oracle Discoverer Business AreasManaging Simple, Complex and Custom FoldersCreating and Using JoinsCreating and Using CalculationsUsing Custom Oracle PL/SQL FunctionsWorking with ConditionsCreating Date and Item HierarchiesUsing Summary FoldersUsing the Automated Summary Management Feature (ASM)Using the Oracle Discoverer EUL Status WorkbooksUsing the Oracle Enterprise Manager Website to Configure Oracle Discoverer Plus and ViewerCreating Connections to Oracle Discoverer PlusCreating HTML links to Discoverer Viewer worksheets using Private Connections Who will the Course Benefit?Anyone who wishes to set up or maintain relevant Business Areas within an Oracle Discoverer End User Layer. Learning Objectives To provide the skills needed to manage Business Areas effectively within an Oracle Discoverer End User Layer and to learn how to use the Oracle Enterprise Manager website to configure Oracle Application Server for Discoverer Plus and Viewer.
Facilities
Location
Start date
Start date
About this course
Attendance on the pre-requisite courses or similar knowledge. Practical experience of Oracle Application Server Administration would be an advantage.
Reviews
Subjects
- Private
- Web
- Oracle 10g
- SQL
- Server
- Application Server
Course programme
Course Contents - DAY 1Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Overview
- Discoverer Components
- The Discoverer Administration Interface
- The Data Page
- The Hierarchies Page
- The Item Classes Page
- The Summaries Page
- The Discoverer Workbook Window
- Introduction
- Preparing for the use of Scheduled Workbooks
- Requirements for Summary Management
- Query Prediction
- Introduction - the Purpose of the End User Layer
- Creating an EUL
- Managing the EUL
- Deleting an EUL
- Introduction - Business Areas and their Use
- Building a New Business Area
- Building a New Business Area with the Load Wizard
- Applying security and privileges to a Business Area
- Scheduling workbooks
- Introduction - the Types of Folder
- Creating a Simple Folder
- Creating a Complex Folder
- Creating a Custom Folder
- Folder Properties
- Editing the SQL of a Custom Folder
- Sharing Folders across Business Areas
- Folder Operations
- Importing and Exporting using Discoverer Administrator
- Introduction - Items, Item Classes and their Use
- Item Properties
- Deleting an Item
- Creating and Editing Item Classes
- Using the Item Class Page to Manage Item Classes
- Introduction - the Use and Purpose of these Objects
- Joins
- Calculations
- Conditions
- Hierarchies
- Introduction - the Purpose of Summary Folders
- What is a summary Folder?
- Creating a Summary Folder
- Editing and Repairing Summary folders
- Summary Folder Properties
- Automated Summary Management
- Introduction - What are EUL Status Workbooks?
- Installing the EUL v5 Business Area
- Workbook Content
- Introduction to the Application Server
- A Simple Application Server Environment to Support Discoverer
- Oracle Application Server Installation Types
- Managing an Application Server
- The Enterprise Manager Website
- The Application Server Farm Home Page
- The Application Server Instance Home Page
- The Components' Home Pages
- Starting and Stopping Components and their Effects
- Clues to Potential Web Problems
- Introduction - Discoverer Architecture on the Web
- The Discoverer Services
- Accessing Discoverer Plus
- Accessing Discoverer Viewer
- Introduction - the Discoverer Configuration Page
- Issues Concerning Running Discoverer Plus for the First Time
- Managing Discoverer Services
- Shutting Down the Discoverer System
- Using Discoverer in a Multi-Machine Environment
- Creating Public and Private Discoverer Connections
- Discoverer and Oracle Single Sign-On
- Configuring Single Sign-On to Protect Discoverer
- Connecting to Discoverer with Single Sign-On
- Introduction - Discoverer Preferences and Oracle Web Cache
- Maintaining Oracle Discoverer Preferences
- Using Parameters in the Oracle Discoverer URLs
- Oracle Discoverer and the Oracle Web Cache
- Configuring Oracle Discoverer to use the Web Cache
Oracle 10g Discoverer for Administrators