Display data graphically. Filter data by using conditions and create parameterized reports. Schedule reports in batch mode. Share workbooks with other users. Export workbooks to other applications. Open a workbook and analyze data using Oracle Discoverer Viewer. Use and customize Discoverer Portlets in Oracle Portal. Analyze data by using totals, percentages, and advanced calculations. Generate reports and ad hoc queries. Select default worksheet format options. Format data, headings and background in a worksheet
Introducing Oracle Discoverer 10g
Business Intelligence Tools
Discoverer Components
Connecting to Discoverer Plus
Data Warehouse Versus Transactional Systems
Using Discoverer with a Data Warehouse
Online Help and Key Terminology
The Discoverer Administrator
The Training Database
Creating Ad-hoc Queries
Creating a Query: Workflow
Using the Workbook Wizard
Editing a Query
Managing Queries
Building and Executing Queries
Controlling Query Execution
Managing Worksheets
Managing Workbooks
Setting Query Management Options
Customizing Display Properties
Result Set Display Options
Setting Default Worksheet Display Options
Customizing Display Properties for The Current Worksheet
Applying Conditions and Using Parameters
Selecting and Applying Predefined Conditions
Selecting and Applying User-Defined Conditions
Creating a New Condition
Nesting Conditions
Using Parameters
Creating Parameterized Conditions
Creating Group Sorts and Applying Summary Functions
Sorting Output: Overview
Sorting and Grouping Data in Tables
Sorting Data in Crosstabs
Creating Totals and SubTotals
Creating and Displaying Percentages
Creating Calculated Items
Identifying Types of Calculations
Creating a Simple Calculation
Building a Complex Calculation
Using the Analytic Calculations Templates
Creating Analysis Calculations
Using Calculations in a Condition
Passing a Parameter to a Calculation
Scheduling and Managing Reports in Batch Mode
Scheduling Workbooks Using Discoverer Plus
The Scheduling Manager Window
Analyzing Data with Drills
Identifying the Drill Types
Drill Up or Down
Drilling to an External Application
Analyzing Data Graphically
Displaying Data Graphically
Creating a New Graph
Editing Graphs
Customizing Graphs
Using Pie Charts
Exporting a Worksheet to Other Applications and Printing a Worksheet
Exporting a Worksheet into Other Applications
Exporting to
Excel or HTML
Exporting an Worksheet to an Excel Pivot Table
Exporting to Oracle Reports in
XML Format
Printing a Worksheet Using the Print Wizard
Introducing Oracle9i Discoverer Viewer
Connecting to Oracle9i Discoverer Viewer
Using the Main Features of Discoverer Viewer
Setting Query Execution Options
Setting Presentation Options
Creating a Bookmark to a Worksheet Using Discoverer Viewer
Introducing Oracle Discoverer Viewer
Connecting to Oracle9i Discoverer Viewer
Discoverer Portlets
Customizing Discoverer Portlets
