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