Lesson 1 – What is Discoverer 2000
Discover 2000 features
What is a multidimensional database
Discoverer 2000 components
Practice database
LESSON 2 – CREATING THE BUSINESS AREA
Launching and loading a business are into the Administration Edition of Discoverer 2000
Creating a new business area
Editing the business area
Administration Tasks
Creating a New Business area
Editing Item Properties
Creating Joins
Creating Calculated Items
Creating Conditions
Creating Hierarchies
Creating an Item Class
Creating Folders
Creating Summary Folders
Granting Business Area Access
Customizing Names
Tab pages
End User Layer
Practice
LESSON 3 – INTRODUCTION TO DISCOVERER 2000 USER EDITION
Launching Discoverer 2000 User Edition
Creating a new workbook using the Workbook Wizard
Step - 2 Item Selection dialog
Step - 3 Item arrangement dialog box
Step - 4 Conditions dialog box
Step - 5 Sort and Page Break dialog box
Step - 6 – Calculated Items dialog box
Saving and retrieving a workbook
Practice
LESSON 4 – LAYOUTS
Table layout
Table page-detail layout
Crosstab layouts
Drilling on a crosstab layout
Crosstab Page-Detail layout
Practice
LESSON 5 – SHEETS
Creating new sheets
Creating a sheet using the Duplicate as Table options
Creating a sheet using the Duplicate as Crosstab options
Maintaining the sheets
Modifying the sheet tab names
Maintaining the sheet title
Other sheet maintenance functions
Using the Edit Sheet function
Practice
LESSON 6 – FORMATTING THE LAYOUT
The Formatting toolbar
Format menu options
The Format/Data menu selection
The Format/Headings menu option
The Format/Exceptions menu option
The Format/Columns menu selection
The Format/Sheet menu selection
Changing the column width on the sheet
Practice
LESSON 7 – THE ANALYSIS TOOLBAR
Summary value tools
Calculated Item tools
Condition tools
Practice
LESSON 8 – GRAPHS
Turning your sheet into a graph
Creating Your Initial Graph
Graph Components
Graph Styles
Other format techniques
Using Grids
Three D graphs
Format by dragging
Drilling
Practice
LESSON 9 – USING DATABASE FUNCTIONS IN CALCULATED ITEMS
Creating a Calculated Attribute
Registering the Function
Creating the Item
Practice