Top
Email
Bottom
Discoverer Plus 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 Plus 11g course at a glance

Pages
435No of slides in the Manual
Exercises
12Total No of Exercises
Sections
20No 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
2Week 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:
2 days
1 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
20
12
435
None
Discoverer Administrator 11g Oracle Essential SQL 11g
Contact us for the latest pricing

Index of Oracle Discoverer 11g Plus Training Course

Section
Contents
Page


One
Introduction
2

 
- What is Discoverer?
3

 
- What is Discoverer 11g Plus?
4

 
- Understanding Discoverer Terminology
5

 
- Worksheet Templates (Table)
13

 
- Worksheet Templates (Page-Detail Table)
14

 
- Worksheet Templates (Crosstab)
16

 
- Worksheet Templates (Page Item Crosstab)
17

Two
Discoverer 11g Plus Interface
18

 
- Connecting to Discoverer 11g Plus
19

 
- Choosing a Discoverer 11g Connection
21

 
- Connecting without a set Connection
24

 
- Opening Discoverer 11g Plus
25

 
- Anatomy of Discoverer 11g Plus
27

 
- Menu Bar in Discoverer 11g Plus
28

 
- Shortcut Bars in Discoverer 11g Plus
29

 
- Toolbar in Discoverer 11g Plus
30

 
- Formatting Bar in Discoverer 11g Plus
32

 
- Analysis Bar in Discoverer 11g Plus
34

Three
Using the Workbook Wizard for Existing Workbooks
35

 
- Introduction
36

 
- Opening Workbooks in Discoverer 11g Plus
37

 
- Multiple EULs in Discoverer 11g Plus
42

 
- Re-Sizing Items in Discoverer 11g Plus
44

 
- Pivoting Items in Discoverer 11g Plus
46

 
- Pivoting Page Items in Discoverer 11g Plus
47

 
- Selecting Page Items in Discoverer 11g Plus
48

 
- Pivoting Crosstab Items in Discoverer 11g Plus
49

 
- Saving Workbooks in Discoverer 11g Plus
50

 
- Using Parameters in Discoverer 11g Plus
52

 
- Using Parameter LOVs in Discoverer 11g Plus
54

 
- Timing Out in Discoverer 11g Plus
56

 
- Exercise One
57

Four
Simple Workbooks in Discoverer 11g Plus
63

 
- Creating Workbooks in Discoverer 11g Plus
64

 
- Adding Items in Discoverer 11g Plus
80

 
- Deleting Items in Discoverer 11g Plus
83

 
- Altering Worksheets in Discoverer 11g Plus
86

 
- Duplicating Worksheets in Discoverer 11g Plus
88

 
- Renaming Worksheets in Discoverer 11g Plus
89

 
- Exercise Two
90

Five
Formatting in Discoverer 11g Plus
96

 
- Introduction to Formatting in Discoverer 11g Plus
97

 
- Formatting Data in Discoverer 11g Plus
98

 
- Formatting Numbers in Discoverer 11g Plus
102

 
- Formatting Dates in Discoverer 11g Plus
103

 
- Formatting Text in Discoverer 11g Plus
104

 
- Setting Column Headings in Discoverer 11g Plus
105

 
- Edit Column Headings in Discoverer 11g Plus
107

 
- Item Formats in Discoverer 11g Plus
108

 
- Creating Titles in Discoverer 11g Plus
110

 
- Sorting Records in Discoverer 11g Plus
116

 
- The Sort Dialog in Discoverer 11g Plus
123

 
- Group Sorting Records in Discoverer 11g Plus
123

 
- Page Preview in Discoverer 11g Plus
125

 
- Page Setup in Discoverer 11g Plus (Worksheet)
126

 
- Page Setup in Discoverer 11g Plus (Table)
127

 
- Page Setup in Discoverer 11g Plus (Margins)
128

 
- Page Setup in Discoverer 11g Plus (Header/Footer)
129

 
- Page Setup in Discoverer 11g Plus (Table)
127

Six
Conditional Formatting in Discoverer 11g Plus
130

 
- Introduction
131

 
- Accessing in Discoverer 11g Plus
132

 
- Using Stoplights in Discoverer 11g Plus
133

 
- Creating in Discoverer 11g Plus
139

 
- Formatting Problems in Discoverer 11g Plus
149

 
- Managing in Discoverer 11g Plus
151

 
- Exercise Three
144

Seven
Advanced Worksheets
159

 
- Introduction
160

 
- Text Areas in Discoverer 11g Plus
161

 
- Page Items in Discoverer 11g Plus
163

 
- Cross Tab Worksheets in Discoverer 11g Plus
166

 
- Duplicating Worksheets in Discoverer 11g Plus
167

 
- Creating Cross Tabs in Discoverer 11g Plus
173

 
- Exercise Four
174

Eight
Totalling in Discoverer 11g Plus
179

 
- Total Types in Discoverer 11g Plus
180

 
- Accessing Totals in Discoverer 11g Plus
183

 
- Creating Totals in Discoverer 11g Plus
185

 
- Creating Totals for Cross Tabs in Discoverer 11g Plus
192

Nine
Percentages in Discoverer 11g Plus
195

 
- Introduction to Percentages in Discoverer 11g Plus
196

 
- Creating Percentages in Discoverer 11g Plus
198

 
- Exercise Five
201

Ten
Conditions in Discoverer 11g Plus
207

 
- Limiting Data in Discoverer 11g Plus
208

 
- Creating Conditions in Discoverer 11g Plus
210

 
- Disabling Conditions in Discoverer 11g Plus
221

 
- Advanced Conditions in Discoverer 11g Plus
222

 
- Administrator Conditions in Discoverer 11g Plus
230

 
- Mandatory Administrator Conditions
232

 
- Exercise Six
233

Eleven
Calculations in Discoverer 11g Plus
238

 
- Creating Additional Items in Discoverer 11g Plus
239

 
- Simple Calculations in Discoverer 11g Plus
242

 
- Manipulating Items in Discoverer 11g Plus
245

 
- Oracle Functions in Discoverer 11g Plus
248

 
- Combining Oracle Functions in Discoverer 11g Plus
253

 
- Exercise Seven
254

Twelve
Parameters in Discoverer 11g Plus
262

 
- Parameters in Discoverer 11g Plus
263

 
- Creating Parameters in Discoverer 11g Plus
265

 
- Creating Parameters Directly in Discoverer 11g Plus
266

 
- Creating Parameters via Conditions
274

 
- Disabling Parameters in Discoverer 11g Plus
280

 
- Parameter Values in Discoverer 11g Plus
281

 
- Advanced Parameters in Discoverer 11g Plus
282

 
- Parameters in Titles in Discoverer 11g Plus
286

 
- Exercise Eight
287

Thirteen
Aggregation in Discoverer 11g Plus
292

 
- Aggregating Values in Discoverer 11g Plus
293

 
- Data Points in Discoverer 11g Plus
294

 
- Example of Aggregation in Discoverer 11g Plus
297

 
- Reversing Aggregation in Discoverer 11g Plus
300

 
- Date Hierarchies in Discoverer 11g Plus
301

 
- Exercise Nine
304

Fourteen
Drilling in Discoverer 11g Plus
308

 
- Drilling Through Data in Discoverer 11g Plus
309

 
- Hierarchies in Discoverer 11g Plus
310

 
- Using Drilling in Discoverer 11g Plus
311

 
- The Drill Dialog in Discoverer 11g Plus
314

 
- Drill Up/Down in Discoverer 11g Plus
315

 
- Drilling to a Related Item in Discoverer 11g Plus
317

 
- Drill to Detail in Discoverer 11g Plus
318

 
- Drill to Link in Discoverer 11g Plus
319

 
- Advanced Drilling in Discoverer 11g Plus
320

 
- Exercise Ten
322

Fifteen
Graphs in Discoverer 11g Plus
328

 
- Graphically Representing Data in Discoverer 11g Plus
329

 
- Incorporating Graphs in Discoverer 11g Plus
330

 
- Graph Placement in Discoverer 11g Plus
332

 
- Graph Types in Discoverer 11g Plus
338

 
- Edit Graph Options in Discoverer 11g Plus
350

Sixteen
Links in Discoverer 11g Plus
361

 
- Linking Worksheets to other Sheets and URLs
362

 
- Creating Links in Discoverer 11g Plus Worksheets
364

 
- Creating URL Links in Discoverer 11g Plus
367

 
- Creating Worksheet Links in Discoverer 11g Plus
369

 
- Exercise Eleven
375

Seventeen
Summaries in Discoverer 11g Plus
382

 
- Purpose of Summaries in Discoverer 11g Plus
383

Eighteen
Worksheet Options in Discoverer 11g Plus
385

 
- Worksheet Options in Discoverer 11g Plus
386

 
- General Options in Discoverer 11g Plus
387

 
- Query Governor in Discoverer 11g Plus
388

 
- Sheet Options in Discoverer 11g Plus
390

 
- Formats Options in Discoverer 11g Plus
391

 
- Advanced Options in Discoverer 11g Plus
392

 
- EUL Options in Discoverer 11g Plus
393

Nineteen
Additional Features of Discoverer 11g Plus
394

 
- Exporting Data from Discoverer 11g Plus
395

 
- Exporting to HTML from Discoverer 11g Plus
401

 
- Exporting to Excel from Discoverer 11g Plus
402

 
- Exporting Graphs from Discoverer 11g Plus
403

 
- Copy and Paste in Discoverer 11g Plus
408

 
- Manage Workbooks in Discoverer 11g Plus
409

 
- Sharing Workbooks in Discoverer 11g Plus
411

 
- Workbook Properties in Discoverer 11g Plus
412

 
- Scheduling a Workbook in Discoverer 11g Plus
413

 
- Opening a Scheduled Workbook in Discoverer 11g Plus
417

 
- Using a Scheduled Workbook in Discoverer 11g Plus
418

 
- Using Schedule Manager in Discoverer 11g Plus
420

Twenty
Help in Discoverer 11g Plus
422

 
- Introduction
423

 
- Help Navigator
424

 
- About OracleBI Discoverer
427

 
- Exercise Twelve
428

 
 
 

Sections of Oracle Discoverer 11g Plus course

One
Introduction

Two
Discoverer 11g Plus Interface

Three
Using the Workbook Wizard for Existing Workbooks

Four
Simple Workbooks in Discoverer 11g Plus

Five
Formatting in Discoverer 11g Plus

Six
Conditional Formatting in Discoverer 11g Plus

Seven
Advanced Worksheets

Eight
Totalling in Discoverer 11g Plus

Nine
Percentages in Discoverer 11g Plus

Ten
Conditions in Discoverer 11g Plus

Eleven
Calculations in Discoverer 11g Plus

Twelve
Parameters in Discoverer 11g Plus

Thirteen
Aggregation in Discoverer 11g Plus

Fourteen
Drilling in Discoverer 11g Plus

Fifteen
Graphs in Discoverer 11g Plus

Sixteen
Links in Discoverer 11g Plus

Seventeen
Summaries in Discoverer 11g Plus

Eighteen
Worksheet Options in Discoverer 11g Plus

Nineteen
Additional Features of Discoverer 11g Plus

Twenty
Help in Discoverer 11g Plus



Synopsis for Oracle Discoverer 11g Plus Training Course

There are two flavours to the Oracle Discoverer front end, the Desktop and the Plus versions, whichever version you choose to plump for, you will undoubtedly be able to use the other version, there are a small number of differences in their usage and our very experienced Training Consultant will point there out as the course progresses, it's up to you to decide which one to take but that will be dictated by what version you have installed at your Company.

Although this webpage is primarily about the Discoverer Plus version all of the comments made will apply to the Desktop version as well (mostly). Plus is accessed via a browser, this means that the Application System software will need to be installed and typically this is put on a middle tier server, AS forms the gateway between the browser and the Oracle Database, as a result of using the browser access to the filesystem is not as easy as it is with Discoverer Desktop, as a result the workbooks cannot be saved to folder system, they need to be saved internally to the Database.

One of the key components to Discoverer usage is the End User Layer, this is set up and maintained by the Discoverer Administrator, the Administrator controls the access to the Database via Discoverer as well as set up the 'shape' of the data being presented.

This course is two days duration, and during those two days the entire usability of the product is discussed, demonstrated and then the User is given an exercise to practice the technique. There are plenty of exercises during the course at these points we encourage delegates (after they have completed the tasks) to have a walk round, grab a drink and chill.

This webpage contains the index of the course so that you can view the contents, you will see we cover everything, the manual for the course is given to each Delegate at the start of the training and it is theirs to make notes on and to keep as a useful reference well after the course has ended.

The course is available as an on-site course, a come to our office course and a one to one course, in all circumstances the start date is yours to choose, the start time is negotiable but normally we start at 9am and finish at 4.15pm, however we can be flexible to fit in with your business's needs, in fact we have on occasion presented this course over a weekend. All delegates get an individual workstation for the duration of the course plus our Consultant is on hand to assist during the course and to give advice regarding the construction of Workbooks when the Delegates return to their desks.

Seer Computing also offer Discoverer consultancy to Companies who have already had training or need additional advice, we can help build the End User Layer, create a set of initial Workbooks or analyse the current system with a comprehensive report and recommendations.

Contact our training advisers they will be glad to assist with your requirements.

Request for detailsClick for the contact form for the Discoverer Plus 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