Objectives

  • urs 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

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

Founded and headquartered in Anaheim, California, New Horizons Learning Centers was named the world's largest independent training company by IDC.

The Company is both an operator and franchisor of training centers that offer a broad range of Technical Training, Desktop Application, Business Skills and English Language courses for all levels of users in multiple delivery methods and formats.

New Horizons provides approximately three million student days of instruction annually with location around the globe.

New Horizons sets the pace of innovative training programs that meet the changing needs of the industry. With 2400 qualified instructors in over 2100 classrooms at 300 centers in 60 counters around the world.

New Horizons offers more courses, at more times, in more delivery methods than any other training company.

See all New Horizons Egypt courses

Contact information not available.

Courses you can instantly connect with...
Oracle Database 11g: Introduction to SQL New Horizons Egypt Oracle Database 11g: Administration Workshop I Release 2 New Horizons Egypt Oracle Database 11g: Data Guard Administration Release 2 New Horizons Egypt

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or