Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Getting Started

Introducing Discoverer 4i Plus

New Discoverer Features

Using Discoverer to support your business decisions

Working with Discoverer

Getting the data you want

Analyzing your data

Sharing your data with others

Key concepts and terminology

Looking at the work area

Workbook Wizard

Menu bar and Tool bar

Learning more about Discoverer

2 Getting the Data You Want

Opening an Existing Workbook

Opening Workbooks in a Non-Oracle Database

Viewing Scheduled Workbooks

Viewing Scheduled Workbooks when connected as an Oracle Applications User

Finding Specific Data When a Workbook Opens

Parameters

Creating Parameters

Conditions

Creating a New Workbook

Editing a Worksheet

Adding and Deleting Items on a Worksheet

Changing a Worksheet's Layout

Formatting Text, Numbers, and Dates

Saving a Workbook

Refreshing Data in a Workbook

Looking at a Workbook's Properties

Deleting a Workbook

3 Analyzing Data

Sorting Data

Simple Table Sorting

Group Sorting

About the Sort Order

Sorting Data on Crosstabs

Pivoting Data

Drilling Into and Out of the Data

Collapsing Drilled Items

Duplicating Tables and Crosstabs

Adding Calculations to Worksheets

Creating and Editing Calculations

Totaling Numeric Data

Displaying Existing Totals

Creating a New Total

Editing a Totals Definition

Calculating Percentages

Creating a New Percentage

Graphing Your Data

Notes on creating Graphs

Creating a Graph

Choosing Font Options

Positioning Your Graph with Your Worksheet

Using the Graph Toolbar

Saving Your Graph

Deleting Your Graph

4 Sharing Results with Others

Printing Worksheets and Graphs

Exporting Data to Other Application Formats

Exporting to Microsoft Excel and HTML Formats

Sharing Workbooks

5 Changing Default Settings

Setting General Options

Setting Query Governor Options

Setting Sheet Format Options

Setting Default Format Options

Resetting the Default Formats

Setting Advanced Options

Setting EUL Options

Using SQL

Looking at the SQL Statements for Worksheets

Using the Discoverer Execution Plan

Looking at an SQL Execution Plan

Viewing the SQL and Execution Plan with an 8.1.6+ database

A Calculation Examples

Getting More Information

About the examples in this chapter

Additional formatting

Simple Calculation Examples

Analytic Function Examples

Analytic Function Categories

Calculations and Drilling Into and out of data

About The Analytic Function Template

Ranking Function Examples

Banding Function Examples

Windowing Function Examples

Reporting Function Examples

Lag/Lead Function Examples

Statistical Function Examples

More about the Analytic Function Template

Analytic Functions and Sequencing

B Oracle Applications Support

Oracle Applications Support

Supported Features

Prerequisites

Connect dialog settings for Oracle Applications Users

Before you start

Connecting to Discoverer as an Oracle Applications User