Oracle - Course Details

OraBIDA10g:DEUL OracleBI Discoverer Administrator 10g: Develop an EUL

Oracle Course Description:
This OracleBI Discoverer Administrator 10g: Develop an EUL training explores the steps needed to create and customize the End User Layer. Through a combination of lectures and hands-on exercises, you'll work with expert Oracle University instructors to expand your skill set to better leverage this solution.
Oracle Course Duration:
3 DAYS
Oracle Course Target Audience:
usiness Analysts,Business Intelligence Developer
Oracle Course Prerequisite:
Familiarity with Microsoft Windows Applications,Familiarity with Web browsers
Course Content:
  • Introduction to OracleBI Discoverer Administrator: Develop an EUL

  • Creating the End User Layer and Business Areas

    • Public and Private End User Layers
    • Security in an EUL
    • Creating the Initial EUL
    • Discoverer in Applications Mode
    • Designing a Business Area
    • Customizing a Business Area
    • Creating a Business Area
    • Exporting and Importing

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

    • Creating an LOV
    • Managing LOVs
    • Creating an Alternative Sort
    • Creating a Simple Condition
    • Creating an Advanced Condition
    • Creating item classes

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

    • Viewing Default Folder and Item Properties
    • Formatting Folders and Items
    • Customizing Folder and Item Properties
    • Calculated Items
    • Registering PL/SQL Functions

  • Creating Complex and Custom Folders

    • Creating Joins
    • Managing Join Relationships
    • Creating a Complex Folder
    • Assigning Items to Complex Folders
    • Optimizing SQL Generation
    • Creating a Custom Folder
    • Custom LOVs

  • Creating Analytical and Aggregate Items

    • Using Analytical Functions
    • Administration Calculations
    • Types of Calculations
    • User-Defined Aggregate Calculations

  • Creating Drills

    • Drill Structures and Facilities
    • Filtering Drills
    • Drill to related items
    • Drill to detail
    • Designing and creating an Item Hierarchy
    • Maintaining Item Hierarchies
    • Creating a Date Hierarchy
    • Maintaining Date Hierarchies

  • Creating and Managing Summary Folders

    • Requirements for Creating Summary Folders
    • Requirements for Using Materialized Views
    • Creating Summary
    • Estimating Storage Space
    • Registering External Summary Tables
    • Editing Summary Folders
    • Refreshing Summary Folders
    • Viewing Summary Folder Properties

  • Automated Summary Management (ASM)

    • ASM Policy
    • Executing ASM
    • Running ASM After Bulk Load
    • Advanced Settings

  • Managing Batch Scheduling

    • Scheduling Workbooks
    • Opening and Managing Scheduled Workbooks
    • Creating a Batch Repository User
    • Setting the Repository User Property
    • Managing Scheduled Workbooks
    • Editing a Scheduled Workbook
    • Viewing Scheduled Workbook Status

  • Maintaining the End User Layer

    • Effects of Database Changes on Queries
    • Refreshing the Database
    • Refreshing the Business Area
    • Managing Folders
    • Deleting a Business Area
    • Migrating from Development to Production
    • Support for Multiple Schemas

  • Administering Multiple End User Layers and Automating Tasks

    • Using the EUL Manager Wizard
    • Creating an EUL for a New User
    • Deleting an EUL
    • Installing the Sample Data
    • Uninstalling the Sample Data
    • Multiple End User Layers
    • Assigning a Default EUL
    • Verifying the Default EUL