Audience
This course is for Oracle Discoverer Administrators.
Prerequisites
Attending our Oracle Business Intelligence Discoverer Plus for End Users course, or equivalent knowledge, is essential. Familiarity with SQL is important and some familiarity with PL/SQL would be advisable.
Duration
3 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
This class will teach delegates to create, maintain and administer the EUL (End User Layer) - the Metadata layer between the data source and Discoverer. Students will also learn how to for customise the EUL , which will hide the complexity of the data source and provide a user-friendly view of the data for reporting purposes.
Course Content
Introduction
Explaining the role of the Oracle Discoverer Administrator
Creating the End User Layer
What is the End User Layer?
Why you might require an Application EUL
Public and Private EULs
Create a Private EUL
Creating and Managing Business Areas
Creating a Business Area using the LOAD Wizard
The Work Area
Managing Business Areas
Business Area Properties
Exporting and Importing
Business Area Security
User privileges
Creating List of Values (LOVs) and Conditions
Creating and Managing LOV’s
Simple and Mandatory Conditions
Creating Calculated Items
Creating Calculated Items in the EUL
Registering PL/SQL Functions in the EUL
Working with Folders
Creating a Complex folder
Assigning items to Complex folder
Recognising when to build new Joins
Creating a Custom folder
Custom LOVs
Creating Analytical and Aggregate Items
Using Analytical Functions
Types of Calculations used in Complex Folders
Creating Drills
Creating Item Hierarchies
Designing and using a Date Template
Alternative methods for creating Date Hierarchies
Maintaining Hierarchies
Managing Scheduling
Considerations for using this option
Setting up the Scheduling option for End Users
Creating the Batch Repository (the preferred option)
Managing Scheduled Workbooks
Creating and Managing Summary Folders
Requirement for improving Query Performance
Creating a Summary based on a Materialised View
Registering External Summary Tables
What is Automated Summary Management?
Maintaining the EUL
Refreshing a Business Area
Managing a Business Area
Changing the ownership of Workbooks
Migrating from Development to Production
Administering the EUL
Creating a EUL for an new user
Multiple EULs
Installing the Sample Data