Index of Oracle Discoverer 3.1 User Training Course
Section
Contents
Page
One
Introduction
2
- What is Discoverer 3.1
3
- What is Discoverer 3.1 User
4
- Understanding Discoverer 3.1 Terminology
5
- How to run Discoverer 3.1 User
15
Two
Discoverer 3.1 User Interface
17
- Connecting to Discoverer 3.1
18
- Anatomy of Discoverer 3.1
19
- Menu Bar
20
- Shortcut Bars
21
- Toolbar
22
- Formatting Bar
24
- Analysis Bar
26
Three
Existing Workbooks
28
- Introduction
29
- Opening Workbooks in Discoverer 3.1
31
- Write Permissions in Discoverer 3.1
33
- Using Different Accounts
34
- Missing Items in Discoverer 3.1
37
- Multiple EULs in Discoverer 3.1
39
- Running the Query in Discoverer 3.1
42
- Re-Sizing Items in Discoverer 3.1
43
- Pivoting Items in Discoverer 3.1
45
- Saving Workbooks in Discoverer 3.1
51
- Using Parameters in Discoverer 3.1
52
- Exercise One
55
Four
Simple Workbooks
62
- Creating Workbooks in Discoverer 3.1
63
- Modifying Workbooks in Discoverer 3.1
78
- Duplicating Worksheets in Discoverer 3.1
79
- Exercise Two
80
Five
Formatting
86
- Introduction to Formatting in Discoverer 3.1
87
- Formatting Data in Discoverer 3.1
88
- Formatting Numbers in Discoverer 3.1
93
- Formatting Dates in Discoverer 3.1
94
- Formatting Text in Discoverer 3.1
95
- Setting Column Headings in Discoverer 3.1
96
- Specifying Backgrounds in Discoverer 3.1
97
- Creating Titles in Discoverer 3.1
99
- Sorting Records in Discoverer 3.1
104
- Using Exceptions in Discoverer 3.1
110
- Creating Exceptions in Discoverer 3.1
116
- Managing Exceptions in Discoverer 3.1
117
- Page Setup in Discoverer 3.1
118
- Exercise Three
122
Six
Advanced Worksheets
134
- Introduction
135
- Page Items in Discoverer 3.1
136
- Cross-Tabs in Discoverer 3.1
138
- Exercise Four
143
Seven
Totals
148
- Using Totals in Discoverer 3.1
149
- Creating Totals in Discoverer 3.1
152
Eight
Percentages
157
- Introduction to Percentages in Discoverer 3.1
158
- Creating Percentages in Discoverer 3.1
160
- Exercise Five
163
Nine
Conditions
170
- Limiting Data in Discoverer 3.1
171
- Administrator Conditions
173
- Creating Conditions in Discoverer 3.1
177
- Advanced Conditions in Discoverer 3.1
187
- Exercise Six
192
Ten
Calculations
197
- Creating Additional Items in Discoverer 3.1
198
- Oracle Functions in Discoverer 3.1
204
- Exercise Seven
207
Eleven
Parameters
214
- Creating Parameters in Discoverer 3.1
215
- Disabling Parameters in Discoverer 3.1
224
- Advanced Parameters in Discoverer 3.1
225
- Exercise Eight
229
Twelve
Aggregation
233
- Totalling Values in Discoverer 3.1
234
- Example of Aggregation in Discoverer 3.1
235
- Data Points in Discoverer 3.1
239
- Date Hierarchies in Discoverer 3.1
242
- Exercise Nine
245
Thirteen
Drilling
250
- Drilling Through Data in Discoverer 3.1
251
- Using Hierarchies in Discoverer 3.1
252
- Types of Drilling in Discoverer 3.1
253
- Using Drilling in Discoverer 3.1
256
- Drill Dialog in Discoverer 3.1
258
- Drilling Up and Down in Discoverer 3.1
261
- Drilling to a Related Item in Discoverer 3.1
262
- Drill to Detail in Another Sheet in Discoverer 3.1
263
- Drill to an External Application (Hyper Drill)
264
- Exercise Ten
265
Fourteen
Graphs
270
- Graphically Representing Data in Discoverer 3.1
271
- Incorporating Graphs in Discoverer 3.1
272
- Graphs Wizard in Discoverer 3.1
273
- Graph Window in Discoverer 3.1
278
- Modifying Graphs in Discoverer 3.1
279
Fifteen
Worksheet Options
288
- Introduction
289
- General
290
- Query Governor
291
- Table
293
- Crosstab
295
- Formats
296
- Cache
297
- Advanced
298
- EUL
299
- Additional
300
Sixteen
Additional Features
301
- Exporting Data from Discoverer 3.1
302
- Copy and Paste
304
- Excel Direct
305
- Sharing Workbooks in Discoverer 3.1
306
- Deleting a Workbook in Discoverer 3.1
308
- Scheduling a Workbook in Discoverer 3.1
309
- Managing Scheduled Workbooks in Discoverer 3.1
315
Seventeen
Line Commands
321
- Using Line Commands Discoverer 3.1
322
- DOS
323
- Options
331
- Exercise Eleven
336
Eighteen
Complex Queries
337
- Creating a Worksheet Using SQL
338
- Subqueries in Discoverer 3.1
341
- Creating a Subquery in Discoverer 3.1
342
- Alternative Subquery Creation
343
Nineteen
Help
344
- Introduction
345
- Exercise Twelve
352