OracleBI Discoverer Administrator 10g: Develop an EUL

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 Discoverer
  • Design, create, and maintain the End User Layer
  • Design 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
Audience
 Business Analysts
Business Intelligence Developer

Prerequisites
 Familiarity with Microsoft Windows Applications
Familiarity with Web browsers
Data Warehousing Fundamentals
OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data

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