Top
Email
Bottom
Discoverer Administrator 11g
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

Download our latest
Android and iPhone apps ...
Click on whichever one of our Apps you are interested in

Discoverer Administrator 11g course at a glance

Pages
536No of slides in the Manual
Exercises
17Total No of Exercises
Sections
21No of main topics, see index below
Public
NoPublic course in the UK and Ireland
On-Site
YesWe can come to your venue
Level
11 - Beginners
2 - Intermediate
3 - Advanced
Days
3Week days but we can put on weekend courses
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
21
17
536
Oracle Essential SQL 11g Discoverer Desktop 11g
None
Contact us for the latest pricing

Index of Oracle Discoverer 11g 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 Administrator
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 Tasklist
39

Three
The Discoverer End User Layer
40

 
- Introduction to the Discoverer EUL
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
56

 
- Exercise Two
57

Four
Discoverer Business Areas
60

 
- Introduction to Discoverer Business Areas
61

 
- Creating Business Areas in Discoverer
63

 
- Attributes of Business Areas in Discoverer
72

 
- Description Attributes in Discoverer
73

 
- Viewing Business Areas in Discoverer
75

 
- Opening Business Areas in Administrator
77

 
- Business Area Properties
79

 
- New Business Areas Without Folders
80

Five
Exporting and Importing
82

 
- Exporting in Discoverer Administrator
83

 
- Exporting the EUL
84

 
- Exporting Selected Business Areas
88

 
- Exporting Selected Objects
90

 
- Importing Export Files into Administrator
92

 
- Exercise Three
102

Six
Simple Folders
112

 
- Introduction
113

 
- Creating Additional Folders in Discoverer
114

 
- Simple Folder Properties
116

 
- Simple Folder Items
119

 
- Exercise Four
120

Seven
Security and Privileges
124

 
- Discoverer Access
125

 
- Discoverer Security
126

 
- Using Roles in Discoverer Administrator
127

 
- Granting Access to Desktop Users
128

 
- Discoverer Administrator Privileges
132

 
- Granting Privileges to Desktop Users
133

 
- Granting Users to Privileges
136

 
- Administration Privileges
137

 
- User Edition Privileges
138

 
- Query Governor in Discoverer Administrator
140

 
- Scheduled Workbooks in Discoverer
143

 
- Exercise Five
145

Eight
Item Properties
148

 
- Items in Discoverer Administrator
149

 
- Data Types in Discoverer Administrator
150

 
- Varchar2
151

 
- Number
152

 
- Date
153

 
- Long
154

 
- Large Objects
155

 
- Attributes
157

 
- Exercise Six
169

Nine
Developing Folders
173

 
- Adding Value to Discoverer Folders
174

 
- Creating Conditions in Discoverer
175

 
- Viewing Conditions in Administrator
185

 
- Viewing Conditions in Desktop
186

 
- Properties of Conditions
188

 
- Calculations in Discoverer
192

 
- Creating Calculations in Discoverer
194

 
- Viewing Calculations in Discoverer
198

 
- Properties of Calculations
199

 
- Calculations in Discoverer Desktop
200

 
- Exercise Seven
201

 
- Item Classes in Discoverer Administrator
206

 
- Creating LOVs in Discoverer Administrator
207

 
- Viewing LOVs in Discoverer Administrator
217

 
- Viewing LOVs in Discoverer Desktop
220

 
- Editing LOVs in Administrator
224

 
- Exercise Eight
227

Ten
Joins
229

 
- Joining Folders in Discoverer Administrator
230

 
- Types of Joins in Discoverer Administrator
232

 
- Creating Joins in Discoverer Administrator
233

 
- Viewing Joins in Discoverer Administrator
241

 
- Fan Traps in Discoverer Administrator
244

 
- Multiple Join Path Detection in Discoverer Desktop
249

 
- Exercise Nine
250

Eleven
Complex Folders
254

 
- Creating Complex Folders in Discoverer
255

 
- Using Reach-Through in Discoverer
259

 
- Exercise Ten
263

Twelve
Custom Folders
268

 
- Creating Custom Folders in Discoverer
269

 
- Viewing Custom Folders in Discoverer
272

 
- Properties of Custom Folders
273

 
- Using Aliases in Custom Folders
274

 
- Joining Tables in an SQL Statement
278

 
- Problems with Joining Tables in SQL
283

 
- Using Ansi SQL/86 to Join Tables
286

 
- Ansi SQL/86 and Outer Joins
287

 
- Ansi SQL/92 Standards (Natural Joins)
290

 
- Ansi SQL/92 Standards (Cross Joins)
291

 
- Ansi SQL/92 Standards (Joins/Using)
292

 
- Ansi SQL/92 Standards (On)
293

 
- Ansi SQL/92 Standards (Multiple On)
294

 
- Ansi SQL/92 Standards (Left Outer Joins)
295

 
- Ansi SQL/92 Standards (Right Outer Joins)
296

 
- Ansi SQL/92 Standards (Full Outer Joins)
297

 
- Merging Tables in SQL
298

 
- Using Union to Merge Tables in SQL
299

 
- Using Union all to Merge Tables in SQL
300

 
- Using Intersect to Merge Tables in SQL
301

 
- Using Minus to Merge Tables in SQL
302

 
- Knowledge Check
303

 
- Using the Merge Syntax in SQL
308

 
- Using Metadata in the End User Layer
309

 
- Tree Walking in Discoverer
311

 
- Syntax for Tree Walking in Discoverer
313

 
- Example of Tree Walking in Discoverer
314

 
- Ordering Siblings in Tree Walks
315

 
- Using Sys_Connect_By_Path
317

 
- Exercise Eleven
319

Thirteen
Alternative Sorts
327

 
- Alternative Sorting in Discoverer
328

 
- Creating Alternative Sorts
330

 
- Using Alternative Sorts in Desktop
335

 
- An Alternative Way of Sorting
336

 
- Exercise Twelve
343

Fourteen
Aggregation
346

 
- Aggregating Data in Discoverer
347

 
- Data Points in Discoverer
352

 
- Aggregating Dates in Discoverer
355

Fifteen
Drilling and Hierarchies
358

 
- Drilling Data in Discoverer
359

 
- Creating Hierarchies in Discoverer
363

 
- Default Date Hierarchies in Discoverer
364

 
- Creating Date Hierarchies in Discoverer
366

 
- Viewing Date Hierarchies in Discoverer
371

 
- Editing Date Hierarchies
372

 
- Creating Item Hierarchies in Discoverer
373

 
- Viewing Item Hierarchies in Discoverer
377

 
- Editing Item Hierarchies in Discoverer
378

 
- Using Item Hierarchies in Discoverer
379

 
- Creating Drill to Detail in Discoverer
380

 
- Using Drill to Detail in Discoverer Desktop
385

 
- Hyper Drill Plug-ins
387

 
- Exercise Thirteen
390

Sixteen
Scheduling
394

 
- Administrating Scheduling in Discoverer
395

 
- Specifying Scheduled Workbook Limits
399

 
- Processing Scheduled Workbooks
401

 
- Scheduling a Workbook in Desktop
403

 
- Scheduling Manager in Administrator
404

 
- Exercise Fourteen
406

Seventeen
Summaries
407

 
- Summary Creation in Discoverer
408

 
- Using ASM in Discoverer
412

 
- Creating Manual Summaries in Discoverer
421

 
- Using Query Performance Statistics
422

 
- From Items in the End User Layer
429

 
- Registering an External Summary Table
432

 
- Viewing Summary Folders in Discoverer
437

 
- Editing Summary Folders in Discoverer
438

 
- Refreshing Summary Folders in Discoverer
440

 
- Redirection in Discoverer Desktop
441

Eighteen
Materialized Views
443

 
- An Alternative to Summaries
444

 
- Syntax for Creating Materialized Views
445

 
- Refreshing Materialized Views
447

 
- Building Materialized Views
453

 
- Removing Materialized Views
455

 
- Access Keys
456

 
- Logs
457

 
- Refresh Groups
458

 
- Creating Refresh Groups
459

 
- Deleting Refresh Groups
462

 
- Amending Refresh Groups
463

 
- Amending Refresh Group Members
464

 
- Refresh Group Metadata
465

 
- Miscellaneous
466

 
- Exercise Fifteen
467

Nineteen
Maintaining the EUL
471

 
- Refreshing the End User Layer
472

 
- Folder Maintenance in Discoverer
478

 
- Deleting Folders in Discoverer
482

 
- Deleting Business Areas in Discoverer
483

 
- Using the Command Line
484

 
- Using a Shortcut to Run Discoverer
505

 
- Exercise Sixteen
505

Twenty
Miscellaneous Discoverer Usage
508

 
- Registering PL/SQL Functions in Discoverer
509

 
- Importing PL/SQL Functions in Discoverer
511

 
- Registering PL/SQL Functions Manually
516

 
- PL/SQL Functions Rules
518

 
- Registering Packages in Discoverer
519

 
- Oops Objects in Discoverer Administrator
521

Twenty One
Help Facility
522

 
- Help Topics in Discoverer Administrator
523

 
- Using Help in Discoverer Administrator
525

 
- Discoverer Administrator Manuals
526

 
- Discoverer Database Information
527

 
- About OracleBI Discoverer
528

 
- Exercise Seventeen
529

 
 
 

Sections of Oracle Discoverer 11g Administrator course

One
Introduction to Discoverer Administration

Two
Discoverer Administrator Interface

Three
The Discoverer End User Layer

Four
Discoverer Business Areas

Five
Exporting and Importing

Six
Simple Folders

Seven
Security and Privileges

Eight
Item Properties

Nine
Developing Folders

Ten
Joins

Eleven
Complex Folders

Twelve
Custom Folders

Thirteen
Alternative Sorts

Fourteen
Aggregation

Fifteen
Drilling and Hierarchies

Sixteen
Scheduling

Seventeen
Summaries

Eighteen
Materialized Views

Nineteen
Maintaining the EUL

Twenty
Miscellaneous Discoverer Usage

Twenty One
Help Facility

Synopsis for Oracle Discoverer 11g Administrator Training Course

Do you know how many times I've typed Discoverer? even as a touch typist it seems like a difficult word to type, first I typed Discover, then Discovery then Evoque!! I almost typed in the entire Range Rover range!

So what is Discoverer? Oracle Discoverer has been around for many years, it is a GUI interface with an Oracle Database to provide Users access to information without needing an Oracle Developer to produce a report or an extract for them.

There are essentially two parts to Oracle Discoverer, the Administration and the User part. The User side of Administrator splits into two products, identical in their output except one is based within a browser (Discoverer Plus) and the other is installed on the client (Discoverer Desktop).

Discoverer Administrator is client based and installed on a PC, this course assumes that the Delegates have had either the Discoverer Desktop or Plus courses so that they can appreciate what the 'front end' looks like to the Users, it's like designing a car, if you can drive, you appreciate better the needs of an automobile driver. This version is the 11g but we can also supply training in any of the older versions of Discoverer, use our Menu system to navigate to the version you require.

The purpose of Discoverer Administrator is to create the link between the User and the Database, the link is termed the End User Layer and this can be made a quite simple and rudimentary affair but the thing is, the cruder the EUL the harder the User will need to work in order to get the information they require from the Oracle Database. We therefore preach the gospel of excellent EUL creation, throughout the course we develop a series of techniques in each option so that the Administrator creates an End User Layer which is easier to use for the Discoverer User.

So who makes a good Discoverer Administrator? It a lot of ways someone who knows what the Business requires for Information, the structure of the tables can be obtained from a Database Developer, the technique is knowing how to present the data to the User, in some cases a fledgling Administrator would benefit from one of our Essential Oracle 18c SQL training course so that they can understand how tables and indexes are structured. We would also recommend the Delegate attend the Discoverer Desktop course before taking this one so that they understand the front end being used by the User.

The course is a three day event, the Desktop or Plus course is two day, therefore they could both be completed in the same week, not necessarily by all the people attending the first two days but certainly it makes sense to do the courses over the same week.

The Discoverer courses like all one hundred of our courses are available onsite at your venue or we can arrange a suitable location close to your place of work or you can come to us, when we present this course we bring all of the equipment needed for the duration, we don’t need to access your Database or Network, we don’t even need Wi-Fi connection.

All of our courses start at 9am or at a time suitable for your Delegates, you tell us … you can even pick the start date, there are no minimum or maximum numbers for delegates and we can even offer one on one training if you just need to get a new member of the team up to speed.

Our contact details are plastered all over these pages, get in touch, our training advisors will be happy to advise and give you a no obligation free quotation.

Request for detailsClick for the contact form for the Discoverer Administrator 11g training course
Public Courses
Oracle Essential SQL 21c
Days
2
Pages
340
Exercises
8
Sections
15
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 21c
Days
3
Pages
384
Exercises
13
Sections
25
Public
Yes
On-Site
Yes
Public Courses
Using SQL with Oracle SQL Developer 19.2
Days
4
Pages
884
Exercises
18
Sections
37
Public
Yes
On-Site
Yes
Public Courses
Essential JavaScript
Days
4
Pages
660
Exercises
16
Sections
31
Public
Yes
On-Site
Yes
Public Courses
Essential CSS 3
Days
4
Pages
800
Exercises
15
Sections
30
Public
Yes
On-Site
Yes
Public Courses
Essential SQLite 3
Days
3
Pages
550
Exercises
12
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential MySQL 8
Days
4
Pages
533
Exercises
16
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential Python 3
Days
5
Pages
955
Exercises
17
Sections
41
Public
Yes
On-Site
Yes
Public Courses
Oracle Application Express 20
Days
0
Pages
0
Exercises
0
Sections
0
Public
Yes
On-Site
Yes
Public Courses
PHP 8 and MySQL 8
Days
5
Pages
870
Exercises
23
Sections
38
Public
Yes
On-Site
Yes
Public Courses
Java 17 Programming with Eclipse 2021-12
Days
5
Pages
788
Exercises
23
Sections
44
Public
Yes
On-Site
Yes
Public Courses
Java 17 Swing with Eclipse 2021-12
Days
5
Pages
756
Exercises
19
Sections
35
Public
Yes
On-Site
Yes
Click on the course name to see full details, left and right to view other courses