Oracle - Course Details

OraBIDA11g:DEUL Oracle BI Discoverer Administrator 11g: Develop an EUL

Oracle Course Description:
This Oracle BI Discoverer Administrator 11g: Develop an EUL training teaches Discoverer managers (business or data administrators) to create, maintain and administer data in the End User Layer (EUL). Expert Oracle University instructors will teach you how to define analytical facilities for end users, implement and administer Discoverer, design, create and maintain the EUL and more.
Oracle Course Duration:
3 DAYS
Oracle Course Target Audience:
Administrator,Business Intelligence Developer,Data Warehouse,Analyst Developer
Oracle Course Prerequisite:
NONE
Course Content:
  • Introduction to Oracle BI Discoverer Administrator: Develop an EUL

    • Oracle's BI Solution
    • Oracle's 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