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