Index of Oracle Discoverer 9i Administrator Training Course
Section
Contents
Page
One
Introduction to Discoverer Administration
2
- What is Oracle Discoverer?
3
- What is Discoverer Administration ?
4
- How to run Discoverer Administration
6
- Who can perform the Administrator role?
8
- Understanding Discoverer Terminology
9
- Exercise One
18
Two
Discoverer Administrator Interface
30
- Connecting to Discoverer Administrator
31
- Discoverer Administrator Topography
34
- Discoverer Work Area
35
- Work Area Tabs
36
- Menu Bar
37
- Shortcut Bar
38
- Administration Task list
39
Three
The Discoverer End User Layer
40
- Introduction
41
- Privileges needed by the Discoverer Administrator
43
- Maintaining a Discoverer End User Layer
44
- Types of Discoverer End User Layers
45
- Discoverer End User Layer Gateway
47
- Creating Discoverer End User Layers
48
- Creating Discoverer Additional End User Layers
53
- Exercise Two
54
Four
Discoverer Business Areas
57
- Introduction to Discoverer Business Areas
58
- Creating Business Areas in Discoverer
60
- Attributes of Business Areas in Discoverer
69
- Description Attributes in Discoverer
70
- Viewing Business Areas in Discoverer
72
- Opening Business Areas in Administrator
73
- Business Area Properties
75
Five
Exporting and Importing
76
- Exporting in Discoverer Administrator
77
- Exporting the EUL
76
- Exporting Selected Business Areas
81
- Exporting Selected Objects
84
- Importing Export Files into Administrator
86
- Exercise Three
91
Six
Simple Folders
93
- Introduction
94
- Creating Additional Folders in Discoverer
95
- Simple Folder Properties
96
- Exercise Four
100
Seven
Security and Privileges
101
- Introduction
102
- Discoverer Security
103
- Using Roles in Discoverer Administrator
104
- Granting Access to Desktop Users
105
- Discoverer Administrator Privileges
108
- Granting Privileges to Desktop Users
109
- Types of Privileges in Discoverer Administrator
110
- Administration Privileges
111
- User Edition Privileges
112
- Query Governor in Discoverer
114
- Scheduled Workbooks in Discoverer
117
- Exercise Five
118
Eight
Item Properties
120
- Items in Discoverer Administrator
121
- Data Types in Discoverer Administrator
122
- Varchar2
123
- Number
125
- Date
126
- Float
127
- Long
128
- Large Objects
129
- Attributes
131
- Exercise Six
138
Nine
Developing Folders
142
- Adding Value to Discoverer Folders
143
- Creating Conditions in Discoverer
144
- Optional and Mandatory Conditions
146
- Creating Conditions in Administrator
147
- Viewing Conditions in Administrator
154
- Viewing Conditions in Desktop
155
- Properties of Conditions
157
- Calculations in Discoverer
160
- Derived Items in Discoverer
162
- Aggregate Calculations in Discoverer
163
- Derived Aggregates in Discoverer
164
- Creating Calculations in Discoverer
165
- Viewing Calculations in Discoverer
169
- Properties in Discoverer
170
- Exercise Seven
171
- Item Classes in Discoverer Administrator
176
- Creating LOVs in Discoverer Administrator
180
- Viewing LOVs in Discoverer Administrator
183
- Exercise Eight
185
Ten
Joins
186
- Joining Folders in Discoverer Administrator
187
- Types of Joins
189
- Creating Joins in Discoverer Administrator
191
- Join Options in Discoverer Administrator
193
- Viewing Joins in Discoverer Administrator
197
- Join Properties in Discoverer Administrator
198
- Fan Traps in Discoverer Administrator
199
- Multiple Join Path Detection in Discoverer Desktop
203
- Exercise Nine
204
Eleven
Complex Folders
208
- Creating Complex Folders in Discoverer
209
- Properties of Complex Folders
212
- Viewing Complex Folders in Discoverer
213
- Exercise Ten
214
Twelve
Custom Folders
219
- Custom Folders in Discoverer
220
- Creating Custom Folders in Discoverer
221
- Viewing Custom Folders
223
- Properties of Custom Folders
224
- Developing Custom Folders
225
- Labelling Selected Folders
226
- Joining Tables in an SQL Statement
229
- Problems with Joining Tables in SQL
234
- Methods of Joining Tables in SQL
236
- Using Ansi SQL/86 to Join Tables
237
- Ansi SQL/86 and Outer Joins
238
- Ansi SQL/92 Standards (Natural Joins)
241
- Ansi SQL/92 Standards (Cross Joins)
242
- Ansi SQL/92 Standards (Joins/Using)
243
- Ansi SQL/92 Standards (On)
244
- Ansi SQL/92 Standards (Multiple On)
245
- Ansi SQL/92 Standards (Left Outer Joins)
246
- Ansi SQL/92 Standards (Right Outer Joins)
247
- Ansi SQL/92 Standards (Full Outer Joins)
248
- Merging Tables in SQL
249
- Using Union to Merge Tables in SQL
250
- Using Union all to Merge Tables in SQL
251
- Using Intersect to Merge Tables in SQL
252
- Using Minus to Merge Tables in SQL
253
- Knowledge Check
254
- Using the Merge Syntax in SQL
259
- Using Metadata in the End User Layer
260
- Using the Merge Syntax in SQL
259
- Tree Walking in Discoverer
262
- Syntax for Tree Walking in Discoverer
264
- Example of Tree Walking in Discoverer
265
- Ordering Siblings in Tree Walks
266
- Using Sys_Connect_By_Path
268
- Exercise Eleven
270
Thirteen
Alternative Sorts
278
- Alternative Sorting in Discoverer
279
- Creating Alternative Sorts
282
- Using Alternative Sorts
291
- Sorting on the Same Table
292
- Exercise Twelve
293
Fourteen
Aggregation
296
- Aggregating Data in Discoverer
297
- Data Points in Discoverer
302
- Aggregating Dates in Discoverer
305
Fifteen
Drilling and Hierarchies
308
- Drilling Data in Discoverer
309
- Creating Hierarchies in Discoverer
313
- Date Hierarchies in Discoverer
314
- Creating Date Hierarchies in Discoverer
316
- Viewing Date Hierarchies in Discoverer
320
- Creating Item Hierarchies in Discoverer
321
- Viewing Item Hierarchies in Discoverer
325
- Editing Item Hierarchies in Discoverer
326
- Using Item Hierarchies in Discoverer
327
- Creating Hyperdrills in Discoverer
328
- Editing Hyperdrills in Discoverer
333
- Using Hyperdrills in Discoverer Desktop
334
- Setting Hyperdrills in Discoverer
335
- Exercise Thirteen
336
Sixteen
Scheduling
340
- Administrating Scheduling in Discoverer
341
- Specifying Scheduled Workbook Limits
345
- Processing
347
- Scheduling a Workbook
349
- Scheduling Manager
350
- Exercise Fourteen
352
Seventeen
Summaries
353
- Summary Creation in Discoverer
354
- ASM Creating in Discoverer
358
- Creating Manual Summaries in Discoverer
361
- Creating Summaries based on EUL Items
362
- Creating Summaries based on Query Statistics
369
- Using External Summary Tables in Discoverer
371
- Viewing Summary Folders in Discoverer
375
- Refreshing Summary Folders in Discoverer
376
- Editing Summary Folders in Discoverer
377
- Viewing Redirection in Discoverer Desktop
378
- Summary Redirection in Discoverer
379
- Potential Error
381
Eighteen
Materialized Views
382
- An Alternative to Summaries
383
- Syntax for Creating Materialized Views
384
- Refreshing Materialized Views
386
- Building Materialized Views
392
- Removing Materialized Views
394
- Miscellaneous
395
- Exercise Fifteen
396
Nineteen
Maintaining the EUL
399
- Refreshing the End User Layer
400
- Folder Maintenance in Discoverer
407
- Deleting Folders in Discoverer
409
- Deleting Business Areas in Discoverer
410
- Using the Command Line
411
- Using a Shortcut to Run Discoverer
432
- Exercise Sixteen
434
Twenty
Miscellaneous Discoverer Usage
435
- Registering PL/SQL Functions in Discoverer
436
- Importing PL/SQL Functions in Discoverer
438
- Registering PL/SQL Functions Manually
442
- PL/SQL Functions Rules
444
- Registering Packages in Discoverer
445
- 8i Objects in Discoverer Administrator
447
Twenty One
Help Facility
448
- Exercise Thirteen
455
