Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Structure

Related Documents

Conventions

Oracle9iAS Discoverer Navigation and Accessibility

Keyboard Navigation

Changing font sizes and colors for enhanced readability

Documentation Accessibility

1 Introducing Discoverer

Using Discoverer to support your business decisions

About the tutorial

About how the tutorial is structured

Advice on using the tutorial

About the Discoverer Plus help system

2 Lesson 1: Getting started

Prerequisites

Exercise 1: Starting Discoverer Plus

Exercise 2: Opening the tutorial workbook

Exercise 3: Saving a copy of the tutorial workbook

Lesson summary

Frequently asked questions

What is the difference between a workbook and a worksheet?

How do you navigate through pages of a worksheet?

How do you switch between worksheets in a workbook?

How do I create a Discoverer connection for accessing the tutorial database?

3 Lesson 2: Getting the data you want

Exercise 1: Specifying default settings for your worksheets

Exercise 2: Creating a new workbook

Exercise 3: Saving your workbook

Exercise 4: Creating page items

Exercise 5: Duplicating a table worksheet as a crosstab worksheet

Exercise 6: Filtering data with conditions

Exercise 7: Creating parameters for other users

Exercise 8: Adding items to the worksheet

Lesson summary

Frequently asked questions

How does changing default settings affect existing workbooks?

Where will you find the name of your workbook on the workbook itself?

What is the difference between a condition and a parameter?

How do you turn conditions on and off?

What is the difference between an item and a page item?

What is the Workbook Wizard?

4 Lesson 3: Analyzing your data

Exercise 1: Sorting rows and columns

Exercise 2: Pivoting rows and columns

Exercise 3: Drilling in and out of detail

Exercise 4: Adding totals to worksheets

Exercise 5: Adding percentages to worksheets

Exercise 6: Adding mathematical calculations to worksheets

Exercise 7: Adding a ranking calculation to a worksheet

Exercise 8: Graphing worksheet data

Lesson summary

5 Lesson 4: Sharing your data

Exercise 1: Printing a worksheet

Exercise 2: Exporting data to Microsoft Excel spreadsheet format

Exercise 3: Sharing workbooks

Lesson summary

Tutorial summary

Glossary

Index