OracleBI Discoverer Administrator 10g: Develop an EUL

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. They also learn 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.

Learn To:

• 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

• A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

  
  

Audience

• Business Intelligence Developer
• Business Analysts

Course Topics 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 and Creating the Initial EUL
• Discoverer in Applications Mode
• Designing and Customizing a Business Area
• Creating a Business Area
• Providing Access to Business Areas
• EUL Administration Privileges
• Governing Queries

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 and Drill to detail
• Designing and creating an Item Hierarchy
• Maintaining Item Hierarchies
• Creating a Date Hierarchy
• Maintaining Date Hierarchies
• Assigning a Date Hierarchy to an Item

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 and Verifying a Default EUL
• OracleBI Discoverer Administrator Command-Line Interface

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