Discoverer 10g: Develop an EUL

Show more Oracle Discoverer Training Courses

About this class

This class is applicable to Oracle 9iAS Discoverer users.

This course introduces students to Oracle Discoverer Administrator 10g. As Discoverer managers, students learn how to create and customize the End User Layer, how to create business areas and folders, and define analytical facilities for end users. Students also learn about the different types of connection mechanisms supported by OracleAS Discoverer and how to control the user access to the End User Layer. Students learn how to use materialized views and automated summary management. In addition, students learn how to use Oracle Enterprise Manager 10g Application Server Control to configure OracleAS Discoverer.

Who will the lesson benefit?

• Business Analysts
• Data Warehouse Administrator
• Data Warehouse Analyst

What prerequisites are required

• OracleAS Discoverer 10 g : Create Queries and Reports

What delegates will learn

• Design, create, and maintain the End User Layer
• Implement and administer Discoverer
• Control user access to the End User Layer
• Customize the End User Layer
• Optimize query performance, using summaries
• Manage and configure Discoverer, using Application Server Control
• Describe the Single Sign On Option supported by Discoverer
• Register Discoverer as a portlet provider with OracleAS Portal
• Add Discoverer portlets to a portal page

Contents of this class

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
• 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

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

Discoverer 10g: Develop an EUL / D17015GC10

(C) AquinasTraining.co.uk - Contact Us