OracleBI Discoverer Administrator 10g: Develop an EUL

 Oracle University provides a downloadable eKit containing the training materials for this course.

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

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Instruction Language
View Schedule	Instructor-Led Training	US$ 1,800	3 Days	English	English
View Schedule	Live Virtual Class	US$ 1,800	3 Days	English

 

Note: To have a more personalized experience, we invite you to: Log In!

Audience:

• Business Intelligence Developer
• Business Analysts

Prerequisites:

Required Prerequisites:

• Familiarity with Microsoft Windows Applications
• Familiarity with Web browsers
• OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data
• Oracle Database 10g: Introduction to SQL
• Oracle Database 10g: SQL Fundamentals I

Suggested Prerequisites:

• Oracle Database 10g: PL/SQL Fundamentals
• Data Warehousing Fundamentals

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