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.
This course is available on site only. Please call for details.
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
- 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