At a glance ...
Pages
378
Exercises
16
Sections
18
Public
On-Site
Level
1
Days
3

Course Name: Discoverer Administrator 9i

Duration:
Minimum skill level required:
On-Site course:
Public course:
Sections:
No of exercises:
No of pages in the manual:
Pre-Requisite course(s):
Suggested further course(s):
Price guide:
3 days
1 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
18
16
378
Oracle Essential SQL 9i Discoverer Desktop 9i
None
Contact us for the latest pricing

Synopsis for course

Oracle Discoverer 9i Administrator governs the environment that Discoverer Users exist and operate in.

It is used to perform mandatory tasks such as creating and granting access to Business Areas.

It is also used to perform tasks such as maintaining the End User Layer and setting default item names and table characteristics.

Course Contents

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