Table of Contents Image Oracle9iAS Discoverer Plus Tutorial
Version 9.0.2

Part Number A90880-01
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Index
Index

Go to next page

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


Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Index
Index