Index of Oracle Discoverer 10g Desktop Training Course
Section
Contents
Page
One
Introduction
2
- What is Discoverer 10g?
3
- What is Discoverer 10g Desktop?
4
- Understanding Discoverer 10g Terminology
5
- How to run Discoverer 10g
15
Two
Discoverer 10g Desktop Interface
17
- Connecting to Discoverer 10g
18
- Anatomy of Discoverer 10g
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 10g
31
- Write Permissions in Discoverer 10g
33
- Using Different Accounts
34
- Missing Items in Discoverer 10g
37
- Multiple EULs in Discoverer 10g
39
- Running the Query in Discoverer 10g
42
- Re- Sizing Items in Discoverer 10g
43
- Pivoting Items in Discoverer 10g
45
- Saving Workbooks in Discoverer 10g
51
- Using Parameters in Discoverer 10g
52
- Exercise One
55
Four
Simple Workbooks
62
- Creating Workbooks in Discoverer 10g
63
- Modifying Workbooks in Discoverer 10g
78
- Duplicating Worksheets in Discoverer 10g
79
- Counting Records in Discoverer 10g
80
- Exercise Two
81
Five
Formatting
87
- Introduction to Formatting in Discoverer 10g
88
- Formatting Data in Discoverer 10g
89
- Formatting Numbers in Discoverer 10g
94
- Formatting Dates in Discoverer 10g
95
- Formatting Text in Discoverer 10g
96
- Setting Column Headings in Discoverer 10g
97
- Specifying Backgrounds in Discoverer 10g
98
- Creating Titles in Discoverer 10g
100
- Sorting Records in Discoverer 10g
105
- Using Exceptions in Discoverer 10g
111
- Creating Exceptions in Discoverer 10g
117
- Managing Exceptions in Discoverer 10g
118
- Page Setup in Discoverer 10g
119
- Exercise Three
123
Six
Advanced Worksheets
135
- Introduction
136
- Page Items in Discoverer 10g
137
- Cross- Tabs in Discoverer 10g
139
- Exercise Four
144
Seven
Totals
149
- Using Totals in Discoverer 10g
150
- Creating Totals in Discoverer 10g
153
Eight
Percentages
158
- Introduction to Percentages in Discoverer 10g
159
- Creating Percentages in Discoverer 10g
161
- Exercise Five
164
Nine
Conditions
171
- Limiting Data in Discoverer 10g
172
- Administrator Conditions
174
- Creating Conditions in Discoverer 10g
178
- Advanced Conditions in Discoverer 10g
188
- Exercise Six
193
Ten
Calculations
198
- Creating Additional Items in Discoverer 10g
199
- Oracle Functions in Discoverer 10g
205
- Exercise Seven
150
Eleven
Parameters
215
- Creating Parameters in Discoverer 10g
216
- Disabling Parameters in Discoverer 10g
225
- Advanced Parameters in Discoverer 10g
226
- Exercise Eight
230
Twelve
Aggregation
234
- Totalling Values in Discoverer 10g
235
- Example of Aggregation in Discoverer 10g
236
- Data Points in Discoverer 10g
240
- Date Hierarchies in Discoverer 10g
243
- Exercise Nine
246
Thirteen
Drilling
251
- Drilling Through Data in Discoverer 10g
252
- Using Hierarchies in Discoverer 10g
253
- Types of Drilling in Discoverer 10g
254
- Using Drilling in Discoverer 10g
257
- Drill Dialog in Discoverer 10g
259
- Drilling Up and Down in Discoverer 10g
262
- Drilling to a Related Item in Discoverer 10g
263
- Drill to Detail in Another Sheet in Discoverer 10g
264
- Drill to an External Application (Hyper Drill)
265
- Exercise Ten
266
Fourteen
Graphs
271
- Graphically Representing Data in Discoverer 10g
272
- Incorporating Graphs in Discoverer 10g
273
- Graphs Wizard in Discoverer 10g
274
- Graph Window in Discoverer 10g
279
- Modifying Graphs in Discoverer 10g
259
Fifteen
Summaries
289
- Purpose of Summaries in Discoverer 10g
290
Sixteen
Worksheet Options
292
- Introduction
293
- General
294
- Query Governor
295
- Table
297
- Crosstab
299
- Aggregation
300
- Formats
301
- Cache
302
- Connection
303
- Advanced
304
- EUL
305
- Additional
306
Seventeen
Additional Features
307
- Exporting Data from Discoverer 10g
308
- Copy and Paste
310
- Excel Direct
311
- Sharing Workbooks in Discoverer 10g
312
- Deleting a Workbook in Discoverer 10g
314
- Scheduling a Workbook in Discoverer 10g
315
- Managing a Workbook in Discoverer 10g
321
Eighteen
Line Commands
327
- Using Line Commands Discoverer 10g
328
- DOS
329
- Options
337
- Exercise Eleven
342
Nineteen
Complex Queries
343
- Creating a Worksheet Using SQL
344
- Subqueries in Discoverer 10g
347
- Creating a Subquery in Discoverer 10g
348
- Alternative Subquery Creation
349
Twenty
Help
350
- Introduction
351
- Help Topics
352
- Using Help
353
- About Discoverer 10g
354
- Exercise Twelve
355