back to Course Categories | back | print
Oracle Discoverer for Administrators          

Duration: 2 days

Description 
This course gives students hands-on experience with setting up Oracle Discoverer. Students will practice administrative tasks using Discoverer’s Administration Edition tool. Students will learn to create an End User Layer and create and manage business areas. They will learn how to hide the complexity of the data source and provide a user-friendly view of the data for end users.

Topics

  • Understand the benefits of using Discoverer
  • Create and Manage an EUL (End User Layer)
  • Create and Manage Business Areas
  • Create Custom Folders
  • Create Complex Folders
  • Pre-define Joins
  • Pre-define Conditions
  • Create Date Hierarchies and Data Hierarchies
  • Refresh a Business Area
  • Import and Export Business Areas
  • Manage Security and Privileges
  • What is Discoverer?
  • Discoverer Concepts and Components
  • Benefits of Using Discoverer
  • The ‘Big’ Picture
  • Discoverer Terminology
  • The End User Layer
  • Definition
  • The Workbook Wizard
  • Installing an EUL
  • Using the Create EUL Wizard
  • Rules Concerning EULs
  • Building and Managing Business Areas
  • Purpose of a Business Area
  • Creating a Business Area
  • Maintaining, Opening and Closing a Business Area
  • Adding an Empty Business Area
  • Loading a Business Area
  • Need to Refresh
  • The Business Area Task List
  • Working with Folders
  • Adding Folders
  • Custom Folders vs. Complex Folders
  • Join Theory
  • Creating Joins
  • Join Options
  • Creating Custom Folders
  • Creating Complex Folders
  • Item Classes, Lists of Values and Alternate Sort Items
  • Items
  • Managing Items
  • Creating Item Classes
  • Item Class Attributes
  • Creating LOVs
  • Creating Alternate Sort Items
  • Creating Conditions and Calculations
  • Reasons for Predefining Conditions and Calculations
  • Creating Conditions
  • Condition Properties
  • Compound and Complex Conditions
  • Conditions with Parameters
  • Creating Calculations
  • Creating Hierarchies
  • Creating Date Hierarchies
  • Creating Item Hierarchies
  • Modifying Hierarchies
  • Registering PL/SQL Functions
  • Where Functions are Created
  • Registering a User-Defined PL/SQL Function
  • Managing Worksheets and Workbooks
  • Exporting Discoverer Output
  • Viewing, Importing and Exporting SQL
  • Business Area Security
  • Access Privileges
  • Users and Roles
  • Security
  • Setting Query Limits
  • Setting Scheduling Limits
  • The Role of the Administrator
  • Users vs. Super-Users

Prerequisites

  • Oracle 9i SQL (including Oracle SQL Functions)
  • Oracle Discoverer for End Users (Desktop Version)
  • Familiarity with Microsoft Windows


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design