IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
Discoverer for Administrators

Duration: 2 days

Course Overview
This course provides a hands-on approach to Oracle’s Discoverer application for Administrators. The course begins with the considerations before implementation of the Discoverer application and shows the delegate how to create the End User Layer and Business Areas within it. Delegates will learn how to create LOVs, calculated Item, hyperdrills and many other features associated with the Oracle Discoverer Application.
There will also be a brief insight into Oracle Discoverer End User Edition to see the results of the EUL created.

Course Objectives


By the end of the course attendees will be able to:

• List the benefits of Oracle Discoverer
• Create an End User Layer
• Create Business Areas
• Build List Of Values and Alternative Sorts
• Construct conditions
• Define drills and hyperdrills
• Create summary folders
• Manage and maintain privileges and security

Prerequisites


Basic Oracle DBA skills.

Course Content


Introduction
• The purpose of Oracle Discoverer
• The Role of the Data Administrator
• Considerations Before Implementation

The End User Layer and Business Areas
• What is the EUL?
• Creating an EUL
• Deleting an EUL
• Business Areas and their Properties
• The Load Wizard
• Administration Tasklist

Conditions, LOVs and Alternative Sorts
• Creating a Simple Condition
• Creating a Complex Condition
• Using the Item Class Wizard to Create a List of Values
• Using the Item Class Wizard to Create an Alternative Sort

Calculated Items and PL/SQL Functions
• Creating Calculated Items
• How to Register a PL/SQL Function

Complex and Custom Folders
• Defining a Custom Folder from a SQL Query
• Editing a Custom Folder’s SQL
• Creating a Complex Folder

Creating Drills and Hierarchies
• Date Hierarchies
• Item Hierarchies
• Creating Hyperdrills (Drill-to-Detail)

Creating Summary Folders
• What are Summary Folders?
• Summary Redirection
• Enabling Summary Management
• The Summary Wizard
• Building a Summary Folder

Security and Privileges
• Security Dialogue Box
• Privileges
• User/Role Tab
• Query Governor
• Scheduled Workbooks

Enter your email address to register for our newsletter: