OracleBI Discoverer Administrator 10g: Develop an EUL

Oracle University |


OracleBI Discoverer Administrator 10g: Develop an EUL


3 Days

 What you will learn

OracleBI Discoverer Administrator is a component used by Discoverer managers (business or data administrators) to

create, maintain, and administer data in the End User Layer, and to define how users interact with that data. All the

administrative tasks for the EUL objects (such as folders, business areas, summaries, and so on) can be performed

using Discoverer Administrator.

As the Discoverer Manager, students learn how to create and customize the End User Layer, how to create business

areas and folders, and to define analytical facilities for end users. Students also learn how to control the user access to

the End User Layer. Students learn how to use materialized views and automated summary management.Implement

and administer DiscovererDesign, create, and maintain the End User LayerDesign effective business areas Control user

access to the End User Layer, and business areas Customize the End User Layer

Optimize query performance by using summaries


Business Analysts

Business Intelligence Developer


Required Prerequisites

Data Warehousing Fundamentals

OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data

Suggested Prerequisites

Familiarity with Microsoft Windows Applications

Familiarity with Web browsers

Course Objectives

Design, create, and maintain the End User Layer (EUL)

Customize the EUL

Design effective business areas

Control user access to EUL, and business areas

Export/ Import EUL, and business areas

Create item classes

Create analytical and aggregate items

Create drills

Create summaries to improve query performance

Manage batch scheduling

Manage multiple EULs

Course Topics

Introduction to OracleBI Discoverer Administrator: Develop an EUL

Creating the End User Layer and Business Areas

Creating Lists of Values (LOVs), Alternative Sorts, and Conditions

Customizing Properties, Creating Calculated Items, and Registering PL/SQL Functions

Creating Complex and Custom Folders

Creating Analytical and Aggregate Items

Creating Drills

Creating and Managing Summary Folders

Automated Summary Management (ASM)

Managing Batch Scheduling

Maintaining the End User Layer

Administering Multiple End User Layers and Automating Tasks





pearson vueISO 9001