Discoverer for administrators - Training

home
about us
people
products
investors
training
conferences
news
contact us

[training] [gaborone] [lusaka]

Discoverer for administrators

Class times are from 9 A.M. to 5 P.M

This course introduces students to administering Discoverer 4.1, which is a part of Oracle 9i Developer Suite. As a Discoverer administrator, students learn to create and customize the End User Layer, to create business areas and folders, and to define analytical facilities for end users. Students also learn to grant and control user access to the End User Layer, and use Oracle 8i materialized views and automated summary management in Discoverer 4.1. In addition, students become familiar with the architecture of Discoverer 4i Plus and the Discoverer 4i Viewer.

Course Info

Course ID: D10822
Duration: 3 Days

Audience

Data Warehouse Administrator
Business Analysts

Required Prerequisites

Oracle Discoverer 3.1: Data Exploration
Introduction to Oracle: SQL and PL/SQL
Discoverer 3.1 for End Users

Suggested Prerequisites

Administering the Oracle9i Application Server
Oracle9i AS Technical Overview

Course Objectives

Design, create, maintain, and control user access to the End User Layer (EUL)
Customize the End User Layer
Optimize query performance
Discuss the architecture of Oracle Discoverer for the Web
Implement and administer Oracle Discoverer 4.1

Course Topics

Introduction to Oracle Discoverer 4.1 Administration

Positioning Discoverer in Oracle¹s Internet Platform
Differentiating Data Warehouse and OLTP systems
Using Oracle Discoverer with Data Warehouses
Integrating Oracle Discoverer with Business Intelligence Tools
Describing Discoverer Components
Discussing Discoverer for Windows and the Web
Defining Key Terminology
Outlining the Role of the Data Administrator

Creating the End User Layer and Business Areas

Creating the Initial EUL
Designing a Business Area
Identifying and Selecting Objects to Import
Creating and loading Meta Data into a Business Area
Customizing a Business Area
Exporting and Importing
Granting User Access to a Business Area
Controlling User Privileges and Properties

Creating LOVs, Alternative Sorts, and Conditions

Discussing Item Classes
Creating Lists of Values
Creating an Alternative Sort
Creating Optional or Mandatory Simple and Advanced Conditions

Creating Calculated Items and Registering PL/SQL Functions

Customizing Item and Folder Properties
Creating Simple Calculated Items
Registering and Importing PL/SQL Functions

Creating Complex and Custom Folders

Creating Joins
Discussing Join Options
Creating Complex and Custom Folders

Creating Analytical and Aggregate Items

Creating Analytical Items
Creating Aggregate Items

Creating Drills

Identifying End User Drill Facilities
Using the Hierarchy Wizard to Create an Item Hierarchy
Using the Item Class Wizard to Create a Drill-to-Detail
Defining and Setting up a Hyperdrill Plug-in
Explaining the Default Date Hierarchy
Creating a Custom Date Hierarchy and a Non-Standard Calendar
Using Binary Large Objects

Creating and Managing Summary Folders

Discussing Different Types of Summary Management
Discussing Oracle Discoverer Summaries
Discussing Oracle 8i Materialized Views
Comparing Discoverer Summaries with Materialized Views
Creating Summary Folders On Your Own
Discussing Summary Combination Strategies

Automated Summary Management

Using the Automated Summary Management Wizard
Using the Graphical Interface to Change Space for Summary Tables
Changing the Default Automated Summary Management Policies

Managing Batch Scheduling

Describing Batch Reporting
Specifying a Batch Repository Owner
Describing Changes that Affect Batch Reports
Setting up Scheduled Workbook Privileges
Managing Scheduled Workbooks in the Admin Edition

Maintaining the End User Layer

Describing the Effect of Database Changes
Refreshing the Business Area
Deleting Folders or Business Areas
Migrating from Development to a Production Environment
Supporting Multiple Schema
Analyzing the EUL

Administering Multiple End User Layers and Automating Tasks

Discussing Multiple EULs
Creating an EUL for a New User
Assigning a Default EUL
Automating Tasks Through the Command Line Interface

Configuring Discoverer for the Web

Discussing the Benefits of Discoverer for the Web
Using Discoverer 4i Plus
Discussing Oracle9i Application Server Architecture
Outlining Discoverer 4i Plus Architecture
Discussing Administrative Tasks
Opening a Workbook Automatically from a URL
Discussing Discoverer 4i Viewer Architecture
Customizing the Look and Feel of the Discoverer 4i Viewer

- top -

[home] [about us] [people] [products] [investors] [training] [conferences] [news] [contact us]