Index of Oracle Discoverer 10g Plus Training Course
Section
Contents
Page
One
Introduction
2
- What is Discoverer?
3
- What is Discoverer 10g Plus?
4
- Understanding Discoverer Terminology
5
- Worksheet Templates (Table)
13
- Worksheet Templates (Page-Detail Table)
14
- Worksheet Templates (Crosstab)
16
- Worksheet Templates (Page Item Crosstab)
17
Two
Discoverer 10g Plus Interface
18
- Connecting to Discoverer 10g Plus
19
- Choosing a Discoverer 10g Connection
21
- Connecting without a set Connection
24
- Opening Discoverer 10g Plus
25
- Anatomy of Discoverer 10g Plus
27
- Menu Bar in Discoverer 10g Plus
28
- Shortcut Bars in Discoverer 10g Plus
29
- Toolbar in Discoverer 10g Plus
30
- Formatting Bar in Discoverer 10g Plus
32
- Analysis Bar in Discoverer 10g Plus
34
Three
Using the Workbook Wizard for Existing Workbooks
35
- Introduction
36
- Opening Workbooks in Discoverer 10g Plus
37
- Multiple EULs in Discoverer 10g Plus
42
- Re-Sizing Items in Discoverer 10g Plus
44
- Pivoting Items in Discoverer 10g Plus
46
- Pivoting Page Items in Discoverer 10g Plus
47
- Selecting Page Items in Discoverer 10g Plus
48
- Pivoting Crosstab Items in Discoverer 10g Plus
49
- Saving Workbooks in Discoverer 10g Plus
50
- Using Parameters in Discoverer 10g Plus
52
- Using Parameter LOVs in Discoverer 10g Plus
54
- Timing Out in Discoverer 10g Plus
56
- Exercise One
57
Four
Simple Workbooks in Discoverer 10g Plus
63
- Creating Workbooks in Discoverer 10g Plus
64
- Adding Items in Discoverer 10g Plus
80
- Deleting Items in Discoverer 10g Plus
83
- Altering Worksheets in Discoverer 10g Plus
86
- Duplicating Worksheets in Discoverer 10g Plus
88
- Renaming Worksheets in Discoverer 10g Plus
89
- Exercise Two
90
Five
Formatting in Discoverer 10g Plus
96
- Introduction to Formatting in Discoverer 10g Plus
97
- Formatting Data in Discoverer 10g Plus
98
- Formatting Numbers in Discoverer 10g Plus
102
- Formatting Dates in Discoverer 10g Plus
103
- Formatting Text in Discoverer 10g Plus
104
- Setting Column Headings in Discoverer 10g Plus
105
- Edit Column Headings in Discoverer 10g Plus
107
- Item Formats in Discoverer 10g Plus
108
- Creating Titles in Discoverer 10g Plus
110
- Sorting Records in Discoverer 10g Plus
116
- The Sort Dialog in Discoverer 10g Plus
123
- Group Sorting Records in Discoverer 10g Plus
123
- Page Preview in Discoverer 10g Plus
125
- Page Setup in Discoverer 10g Plus (Worksheet)
126
- Page Setup in Discoverer 10g Plus (Table)
127
- Page Setup in Discoverer 10g Plus (Margins)
128
- Page Setup in Discoverer 10g Plus (Header/Footer)
129
- Page Setup in Discoverer 10g Plus (Table)
127
Six
Conditional Formatting in Discoverer 10g Plus
130
- Introduction
131
- Accessing in Discoverer 10g Plus
132
- Using Stoplights in Discoverer 10g Plus
133
- Creating in Discoverer 10g Plus
139
- Formatting Problems in Discoverer 10g Plus
149
- Managing in Discoverer 10g Plus
151
- Exercise Three
144
Seven
Advanced Worksheets
159
- Introduction
160
- Text Areas in Discoverer 10g Plus
161
- Page Items in Discoverer 10g Plus
163
- Cross Tab Worksheets in Discoverer 10g Plus
166
- Duplicating Worksheets in Discoverer 10g Plus
167
- Creating Cross Tabs in Discoverer 10g Plus
173
- Exercise Four
174
Eight
Totalling in Discoverer 10g Plus
179
- Total Types in Discoverer 10g Plus
180
- Accessing Totals in Discoverer 10g Plus
183
- Creating Totals in Discoverer 10g Plus
185
- Creating Totals for Cross Tabs in Discoverer 10g Plus
192
Nine
Percentages in Discoverer 10g Plus
195
- Introduction to Percentages in Discoverer 10g Plus
196
- Creating Percentages in Discoverer 10g Plus
198
- Exercise Five
201
Ten
Conditions in Discoverer 10g Plus
207
- Limiting Data in Discoverer 10g Plus
208
- Creating Conditions in Discoverer 10g Plus
210
- Disabling Conditions in Discoverer 10g Plus
221
- Advanced Conditions in Discoverer 10g Plus
222
- Administrator Conditions in Discoverer 10g Plus
230
- Mandatory Administrator Conditions
232
- Exercise Six
233
Eleven
Calculations in Discoverer 10g Plus
238
- Creating Additional Items in Discoverer 10g Plus
239
- Simple Calculations in Discoverer 10g Plus
242
- Manipulating Items in Discoverer 10g Plus
245
- Oracle Functions in Discoverer 10g Plus
248
- Combining Oracle Functions in Discoverer 10g Plus
253
- Exercise Seven
254
Twelve
Parameters in Discoverer 10g Plus
262
- Parameters in Discoverer 10g Plus
263
- Creating Parameters in Discoverer 10g Plus
265
- Creating Parameters Directly in Discoverer 10g Plus
266
- Creating Parameters via Conditions
274
- Disabling Parameters in Discoverer 10g Plus
280
- Parameter Values in Discoverer 10g Plus
281
- Advanced Parameters in Discoverer 10g Plus
282
- Parameters in Titles in Discoverer 10g Plus
286
- Exercise Eight
287
Thirteen
Aggregation in Discoverer 10g Plus
292
- Aggregating Values in Discoverer 10g Plus
293
- Data Points in Discoverer 10g Plus
294
- Example of Aggregation in Discoverer 10g Plus
297
- Reversing Aggregation in Discoverer 10g Plus
300
- Date Hierarchies in Discoverer 10g Plus
301
- Exercise Nine
304
Fourteen
Drilling in Discoverer 10g Plus
308
- Drilling Through Data in Discoverer 10g Plus
309
- Hierarchies in Discoverer 10g Plus
310
- Using Drilling in Discoverer 10g Plus
311
- The Drill Dialog in Discoverer 10g Plus
314
- Drill Up/Down in Discoverer 10g Plus
315
- Drilling to a Related Item in Discoverer 10g Plus
317
- Drill to Detail in Discoverer 10g Plus
318
- Drill to Link in Discoverer 10g Plus
319
- Advanced Drilling in Discoverer 10g Plus
320
- Exercise Ten
322
Fifteen
Graphs in Discoverer 10g Plus
328
- Graphically Representing Data in Discoverer 10g Plus
329
- Incorporating Graphs in Discoverer 10g Plus
330
- Graph Placement in Discoverer 10g Plus
332
- Graph Types in Discoverer 10g Plus
338
- Edit Graph Options in Discoverer 10g Plus
350
Sixteen
Links in Discoverer 10g Plus
361
- Linking Worksheets to other Sheets and URLs
362
- Creating Links in Discoverer 10g Plus Worksheets
364
- Creating URL Links in Discoverer 10g Plus
367
- Creating Worksheet Links in Discoverer 10g Plus
369
- Exercise Eleven
375
Seventeen
Summaries in Discoverer 10g Plus
382
- Purpose of Summaries in Discoverer 10g Plus
383
Eighteen
Worksheet Options in Discoverer 10g Plus
385
- Worksheet Options in Discoverer 10g Plus
386
- General Options in Discoverer 10g Plus
387
- Query Governor in Discoverer 10g Plus
388
- Sheet Options in Discoverer 10g Plus
390
- Formats Options in Discoverer 10g Plus
391
- Advanced Options in Discoverer 10g Plus
392
- EUL Options in Discoverer 10g Plus
393
Nineteen
Additional Features of Discoverer 10g Plus
394
- Exporting Data from Discoverer 10g Plus
395
- Exporting to HTML from Discoverer 10g Plus
401
- Exporting to Excel from Discoverer 10g Plus
402
- Exporting Graphs from Discoverer 10g Plus
403
- Copy and Paste in Discoverer 10g Plus
408
- Manage Workbooks in Discoverer 10g Plus
409
- Sharing Workbooks in Discoverer 10g Plus
411
- Workbook Properties in Discoverer 10g Plus
412
- Scheduling a Workbook in Discoverer 10g Plus
413
- Opening a Scheduled Workbook in Discoverer 10g Plus
417
- Using a Scheduled Workbook in Discoverer 10g Plus
418
- Using Schedule Manager in Discoverer 10g Plus
420
Twenty
Help in Discoverer 10g Plus
422
- Introduction
423
- Help Navigator
424
- About OracleBI Discoverer
427
- Exercise Twelve
428