Contents

Title and Copyright Information

Send Us Your Comments

Preface

Oracle9i Discoverer Navigation and Accessibility

Keyboard Navigation

Documentation Accessibility

Intended Audience

Structure

Before you begin

Related Documents

Conventions

1 Introducing the Discoverer Administrator tutorial

Introducing the Discoverer Administrator tutorial

2 Lesson 1: Creating a private End User Layer

Lesson 1: Creating a private End User Layer for a new tutorial database user

Exercise 1: Creating a private End User Layer for a new tutorial database user

Lesson summary

3 Lesson 2: Connecting to Discoverer Administrator, using the Load Wizard and the Workarea

Lesson 2: Connecting to Discoverer Administrator, using the Load Wizard and the
Workarea

Exercise 1: Connecting to Discoverer Administrator

Exercise 2: Creating a new business area using the Load Wizard

Exercise 3: Getting to know the Workarea

Lesson summary

4 Lesson 3: Granting access privileges

Lesson 3: Granting access privileges

Exercise 1: Using the Privileges dialog: Privileges tab

Exercise 2: Using the Privileges dialog: User/Role tab

Exercise 3: Using the Privileges dialog: Query Governor tab

Exercise 4: Using the Privileges dialog: Scheduled Workbooks tab

Exercise 5: Using the Security dialog: Business Area -> User tab

Lesson summary

5 Lesson 4: Modifying the business area

Lesson 4: Modifying the business area

Exercise 1: Adding a description to the business area

Exercise 2: Renaming and adding descriptions to folders

Exercise 3: Renaming items in the Time Information folder

Lesson summary

6 Lesson 5: Working with custom folders

Lesson 5: Working with custom folders

Exercise 1: Creating a custom folder

Exercise 2: Editing the SQL statement in a custom folder

Lesson summary

7 Lesson 6: Creating joins

Lesson 6: Creating joins

Exercise 1: Creating joins between folders in the business area

Lesson summary

8 Lesson 7: Customizing items

Lesson 7: Customizing items

Exercise 1: Hiding items in the business area

Exercise 2: Setting the display axis and display sequence for items

Exercise 3: Creating a list of values

Exercise 4: Viewing the list of values item class

What the Discoverer Plus user sees - selecting from a list of values in
Discoverer Plus

Exercise 5: Creating an alternative sort

Exercise 6: Viewing the alternative sort item class

Exercise 7: Creating a new calculated item

What the Discoverer Plus user sees - calculations in Discoverer Plus

Examples of other calculated items

Address record calculated item:

Personnel record calculated item:

Annual compensation based on monthly salary and commission
(NVL permits a zero value) calculated item:

Aggregated calculated items

Lesson summary

9 Lesson 8: Designing a complex folder

Lesson 8: Designing a complex folder

Exercise 1: Creating a complex folder

Exercise 2: Creating a condition

What the Discoverer Plus user sees - conditions displayed in Discoverer Plus

Lesson summary

10 Lesson 9: Working with hierarchies

Lesson 9: Working with hierarchies

Exercise 1: Defining a simple item hierarchy

What the Discoverer Plus user sees - navigating the hierarchy

Exercise 2: Defining a more complex item hierarchy

Exercise 3: Creating a date hierarchy template

What the Discoverer Plus user sees - navigating through levels of a hierarchy

Exercise 4: Modifying the content type of an item

What the Discoverer Plus user sees - external application icons in the worksheet

Exercise 5: Defining drill to detail data

Lesson summary

11 Lesson 10: Creating summary folders to optimize performance

Lesson 10: Creating summary folders to optimize performance

Exercise 1: Creating a summary folder using Automated Summary
Management (ASM)

Exercise 2: Manually creating a summary folder

Lesson summary

12 Lesson 11: Tasks on completion of the tutorial

Lesson 11: Tasks on completion of the tutorial

Exercise 1: Deleting summary folders from the business area

Exercise 2: Deleting the New Video Stores business area

Exercise 3: Deleting the EUL owned by the tutorial database user

Exercise 4: Deleting the tutorial database user from the database

Lesson summary

A Installing the Discoverer tutorial EUL, data, and workbook

Installing the Discoverer tutorial EUL, data, and workbook

What must exist in the database before Discoverer Administrator tutorial users can start using the tutorial lessons?

What happens when you install the Discoverer tutorial EUL, data, and workbook?

What privileges do you need to install the tutorial data?

What conditions apply when you connect to Discoverer Administrator for the first time?

Why must you create an EUL?

What steps do I follow to install the Discoverer tutorial EUL, data, and workbook?

How to create a private EUL for the tutorial

How to install the Discoverer tutorial

How to grant access privileges to the VIDEO5 database user for the tutorial EUL

How to install the tutorial business area in another End User Layer

How to uninstall the tutorial business area, tables and data

How to reinstall the tutorial data

Index