Oracle BI Discoverer Administrator 11g: Develop an EUL Training  

Introduction to Oracle BI Discoverer Administrator: Develop an EUL

• Oracles BI Solution
• Oracles BI Solution Components
• Oracle BI Discoverer Components
• Discoverer Administrator
• Role of the Discoverer Administrator
• Key Terminology
• Building a Business Area
• Data Model

Creating the End User Layer and Business Areas

• Discoverer Connections
• Creating the EUL
• Creating Folders and Business Areas
• Importing and Exporting the EUL
• EUL Security and Privileges

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

• Creating Item Classes
• Creating LOVs
• Creating Alternative Sorts
• Creating Conditions
• About Optional Conditions
• About Mandatory Conditions
• Creating Advanced Conditions

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

• Formatting Folders and Items
• Customizing Folder Properties
• About Indexed Item Properties
• Creating a Simple Calculation
• Creating a Complex Calculation
• About PL/SQL Functions

Creating Complex and Custom Folders

• Creating Joins
• Creating Multi-item Joins
• About Join Options
• Creating Complex Folders
• Assigning Items to Complex Folders
• Complex Folder Reach-through
• Creating a Custom Folder
• Creating Custom LOVs

Creating Analytical and Aggregate Items

• About Analytical Items
• Using Analytical Functions
• Administration Calculations
• Types of Calculations
• Derived Items
• Aggregate Calculations
• Derived Aggregate Calculations
• Nested and User-defined Aggregates

Creating Drills

• About Drill Structures
• Creating Drills
• Filtering Drills
• Designing an Item Hierarchy
• Creating Drill to Detail
• About Date Hierarchies
• Creating and Maintaining Date Hierarchies
• Nonstandard Calendars

Creating and Managing Summary Folders

• About Materialized Views
• Summary Management
• Creating Summary Folders Using EUL Items
• About Database Storage
• Creating Summary Folders Using Query Statistics
• About External Summary Tables
• Creating Summary Folders Using External Summary Tables
• Summary Combination Strategies

Automated Summary Management (ASM)

• About ASM
• ASM Process
• Executing ASM
• Running ASM After Bulk Load
• ASM Advanced Settings

Managing Batch Scheduling

• Scheduling Workbooks
• Managing Workbooks
• About the Batch Reports Process
• Creating a Batch Repository
• Managing Scheduled Workbooks

Maintaining the EUL

• Effects of Database Changes on Queries
• Refreshing the Database and Business Areas
• Managing Folders
• About Orphaned Folders
• Deleting Business Areas
• Migrating from Development to Production
• Support for Multiple Schemas
• Workbooks for EUL Analysis

Administering Multiple EULs and Automating Tasks

• Creating an EUL for a New User
• Deleting an EUL
• Installing the Sample Data
• About Multiple EULs
• Discoverer Administrator Command-line Interface
• Using a Command File
• Discoverer EUL Command-line for Java

Case Study