Download our latest
Android and iPhone apps ...
At a glance ...
Pages
435
Exercises
12
Sections
20
Public
On-Site
Level
1
Days
2

Course Name: Discoverer Plus 10g

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 10g Oracle Essential SQL 10g
Contact us for the latest pricing

Synopsis for course

Oracle Discoverer 10g Plus is an easy to use business intelligence tool that gives end users with no SQL knowledge the ability to create ad hoc database queries, analyse information, produce reports and publish information on the web.

Course Contents

Section
Contents
Page


One
Introduction
2

 
- What is Discoverer?
3

 
- What is Discoverer 10g 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 10g Plus Interface
18

 
- Connecting to Discoverer 10g Plus
19

 
- Choosing a Discoverer 10g Connection
21

 
- Connecting without a set Connection
24

 
- Opening Discoverer 10g Plus
25

 
- Anatomy of Discoverer 10g Plus
27

 
- Menu Bar in Discoverer 10g Plus
28

 
- Shortcut Bars in Discoverer 10g Plus
29

 
- Toolbar in Discoverer 10g Plus
30

 
- Formatting Bar in Discoverer 10g Plus
32

 
- Analysis Bar in Discoverer 10g Plus
34

Three
Using the Workbook Wizard for Existing Workbooks
35

 
- Introduction
36

 
- Opening Workbooks in Discoverer 10g Plus
37

 
- Multiple EULs in Discoverer 10g Plus
42

 
- Re-Sizing Items in Discoverer 10g Plus
44

 
- Pivoting Items in Discoverer 10g Plus
46

 
- Pivoting Page Items in Discoverer 10g Plus
47

 
- Selecting Page Items in Discoverer 10g Plus
48

 
- Pivoting Crosstab Items in Discoverer 10g Plus
49

 
- Saving Workbooks in Discoverer 10g Plus
50

 
- Using Parameters in Discoverer 10g Plus
52

 
- Using Parameter LOVs in Discoverer 10g Plus
54

 
- Timing Out in Discoverer 10g Plus
56

 
- Exercise One
57

Four
Simple Workbooks in Discoverer 10g Plus
63

 
- Creating Workbooks in Discoverer 10g Plus
64

 
- Adding Items in Discoverer 10g Plus
80

 
- Deleting Items in Discoverer 10g Plus
83

 
- Altering Worksheets in Discoverer 10g Plus
86

 
- Duplicating Worksheets in Discoverer 10g Plus
88

 
- Renaming Worksheets in Discoverer 10g Plus
89

 
- Exercise Two
90

Five
Formatting in Discoverer 10g Plus
96

 
- Introduction to Formatting in Discoverer 10g Plus
97

 
- Formatting Data in Discoverer 10g Plus
98

 
- Formatting Numbers in Discoverer 10g Plus
102

 
- Formatting Dates in Discoverer 10g Plus
103

 
- Formatting Text in Discoverer 10g Plus
104

 
- Setting Column Headings in Discoverer 10g Plus
105

 
- Edit Column Headings in Discoverer 10g Plus
107

 
- Item Formats in Discoverer 10g Plus
108

 
- Creating Titles in Discoverer 10g Plus
110

 
- Sorting Records in Discoverer 10g Plus
116

 
- The Sort Dialog in Discoverer 10g Plus
123

 
- Group Sorting Records in Discoverer 10g Plus
123

 
- Page Preview in Discoverer 10g Plus
125

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

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

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

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

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

Six
Conditional Formatting in Discoverer 10g Plus
130

 
- Introduction
131

 
- Accessing in Discoverer 10g Plus
132

 
- Using Stoplights in Discoverer 10g Plus
133

 
- Creating in Discoverer 10g Plus
139

 
- Formatting Problems in Discoverer 10g Plus
149

 
- Managing in Discoverer 10g Plus
151

 
- Exercise Three
144

Seven
Advanced Worksheets
159

 
- Introduction
160

 
- Text Areas in Discoverer 10g Plus
161

 
- Page Items in Discoverer 10g Plus
163

 
- Cross Tab Worksheets in Discoverer 10g Plus
166

 
- Duplicating Worksheets in Discoverer 10g Plus
167

 
- Creating Cross Tabs in Discoverer 10g Plus
173

 
- Exercise Four
174

Eight
Totalling in Discoverer 10g Plus
179

 
- Total Types in Discoverer 10g Plus
180

 
- Accessing Totals in Discoverer 10g Plus
183

 
- Creating Totals in Discoverer 10g Plus
185

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

Nine
Percentages in Discoverer 10g Plus
195

 
- Introduction to Percentages in Discoverer 10g Plus
196

 
- Creating Percentages in Discoverer 10g Plus
198

 
- Exercise Five
201

Ten
Conditions in Discoverer 10g Plus
207

 
- Limiting Data in Discoverer 10g Plus
208

 
- Creating Conditions in Discoverer 10g Plus
210

 
- Disabling Conditions in Discoverer 10g Plus
221

 
- Advanced Conditions in Discoverer 10g Plus
222

 
- Administrator Conditions in Discoverer 10g Plus
230

 
- Mandatory Administrator Conditions
232

 
- Exercise Six
233

Eleven
Calculations in Discoverer 10g Plus
238

 
- Creating Additional Items in Discoverer 10g Plus
239

 
- Simple Calculations in Discoverer 10g Plus
242

 
- Manipulating Items in Discoverer 10g Plus
245

 
- Oracle Functions in Discoverer 10g Plus
248

 
- Combining Oracle Functions in Discoverer 10g Plus
253

 
- Exercise Seven
254

Twelve
Parameters in Discoverer 10g Plus
262

 
- Parameters in Discoverer 10g Plus
263

 
- Creating Parameters in Discoverer 10g Plus
265

 
- Creating Parameters Directly in Discoverer 10g Plus
266

 
- Creating Parameters via Conditions
274

 
- Disabling Parameters in Discoverer 10g Plus
280

 
- Parameter Values in Discoverer 10g Plus
281

 
- Advanced Parameters in Discoverer 10g Plus
282

 
- Parameters in Titles in Discoverer 10g Plus
286

 
- Exercise Eight
287

Thirteen
Aggregation in Discoverer 10g Plus
292

 
- Aggregating Values in Discoverer 10g Plus
293

 
- Data Points in Discoverer 10g Plus
294

 
- Example of Aggregation in Discoverer 10g Plus
297

 
- Reversing Aggregation in Discoverer 10g Plus
300

 
- Date Hierarchies in Discoverer 10g Plus
301

 
- Exercise Nine
304

Fourteen
Drilling in Discoverer 10g Plus
308

 
- Drilling Through Data in Discoverer 10g Plus
309

 
- Hierarchies in Discoverer 10g Plus
310

 
- Using Drilling in Discoverer 10g Plus
311

 
- The Drill Dialog in Discoverer 10g Plus
314

 
- Drill Up/Down in Discoverer 10g Plus
315

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

 
- Drill to Detail in Discoverer 10g Plus
318

 
- Drill to Link in Discoverer 10g Plus
319

 
- Advanced Drilling in Discoverer 10g Plus
320

 
- Exercise Ten
322

Fifteen
Graphs in Discoverer 10g Plus
328

 
- Graphically Representing Data in Discoverer 10g Plus
329

 
- Incorporating Graphs in Discoverer 10g Plus
330

 
- Graph Placement in Discoverer 10g Plus
332

 
- Graph Types in Discoverer 10g Plus
338

 
- Edit Graph Options in Discoverer 10g Plus
350

Sixteen
Links in Discoverer 10g Plus
361

 
- Linking Worksheets to other Sheets and URLs
362

 
- Creating Links in Discoverer 10g Plus Worksheets
364

 
- Creating URL Links in Discoverer 10g Plus
367

 
- Creating Worksheet Links in Discoverer 10g Plus
369

 
- Exercise Eleven
375

Seventeen
Summaries in Discoverer 10g Plus
382

 
- Purpose of Summaries in Discoverer 10g Plus
383

Eighteen
Worksheet Options in Discoverer 10g Plus
385

 
- Worksheet Options in Discoverer 10g Plus
386

 
- General Options in Discoverer 10g Plus
387

 
- Query Governor in Discoverer 10g Plus
388

 
- Sheet Options in Discoverer 10g Plus
390

 
- Formats Options in Discoverer 10g Plus
391

 
- Advanced Options in Discoverer 10g Plus
392

 
- EUL Options in Discoverer 10g Plus
393

Nineteen
Additional Features of Discoverer 10g Plus
394

 
- Exporting Data from Discoverer 10g Plus
395

 
- Exporting to HTML from Discoverer 10g Plus
401

 
- Exporting to Excel from Discoverer 10g Plus
402

 
- Exporting Graphs from Discoverer 10g Plus
403

 
- Copy and Paste in Discoverer 10g Plus
408

 
- Manage Workbooks in Discoverer 10g Plus
409

 
- Sharing Workbooks in Discoverer 10g Plus
411

 
- Workbook Properties in Discoverer 10g Plus
412

 
- Scheduling a Workbook in Discoverer 10g Plus
413

 
- Opening a Scheduled Workbook in Discoverer 10g Plus
417

 
- Using a Scheduled Workbook in Discoverer 10g Plus
418

 
- Using Schedule Manager in Discoverer 10g Plus
420

Twenty
Help in Discoverer 10g Plus
422

 
- Introduction
423

 
- Help Navigator
424

 
- About OracleBI Discoverer
427

 
- Exercise Twelve
428