Oracle Business Intelligence Discoverer Plus for End Users

Audience

This course introduces the querying capabilities of Oracle Business Intelligence Discoverer Plus for end users and those planning to create an EUL.

Prerequisites

Delegates should be familiar with Web browsers.

Duration

2 days. Hands on.

Course Objectives

On completion of the course delegates will be able to:

• Create, modify and run ad hoc queries.
• Create conditions and parameterised reports.
• Create calculations. -Schedule reports.
• Share workbooks with other users and export reports.

Course Content

Introduction
Identifying the concepts and components of Discoverer
Explaining the role of the Oracle Discoverer Administrator
Connecting to Oracle Discoverer Plus
Creating a New Workbook and changing the layout

Managing Queries
Viewing Workbook and Worksheet Properties
Managing Workbooks and Worksheets
Formatting Worksheets
Sharing a Workbook
Exporting Reports
Working with optional settings

Conditions and using Parameters
Creating and Applying Conditions
Creating parameterised conditions

Creating Totals and Percentages
Adding Totals and Subtotals
Creating percentages

Creating Calculated Items
Creating calculations
Using calculations in a condition
Passing parameters to calculations

Analysing Data Graphically
Working with different graphs types
Drilling within graphs

Analysing Data With Drills
Types of Drilling
Using Filtered and Unfiltered Drills
Drilling to a Link

Scheduling
Scheduling a Workbook
Sharing Scheduled Workbooks

Discoverer Viewer
Experiencing the capabilities of Discoverer Viewer