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

Course Name: Discoverer Plus 4i

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
360
None
Discoverer Administrator 9i Oracle Essential SQL 9i
Contact us for the latest pricing

Synopsis for course

Oracle Discoverer 4i 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 4i
3

 
- What is Discoverer 4i User
4

 
- Understanding Discoverer 4i Terminology
5

 
- How to run Discoverer 4i User
15

Two
Discoverer 4i User Interface
17

 
- Connecting to Discoverer 4i
18

 
- Anatomy of Discoverer 4i
19

 
- Menu Bar
20

 
- Shortcut Bars
21

 
- Toolbar
22

 
- Formatting Bar
24

 
- Analysis Bar
26

Three
Existing Workbooks
28

 
- Introduction
29

 
- Opening Workbooks in Discoverer 4i
31

 
- Write Permissions in Discoverer 4i
33

 
- Using Different Accounts
34

 
- Missing Items in Discoverer 4i
37

 
- Multiple EULs in Discoverer 4i
39

 
- Running the Query in Discoverer 4i
42

 
- Re-Sizing Items in Discoverer 4i
43

 
- Pivoting Items in Discoverer 4i
45

 
- Saving Workbooks in Discoverer 4i
51

 
- Using Parameters in Discoverer 4i
52

 
- Exercise One
55

Four
Simple Workbooks
62

 
- Creating Workbooks in Discoverer 4i
63

 
- Modifying Workbooks in Discoverer 4i
78

 
- Duplicating Worksheets in Discoverer 4i
79

 
- Exercise Two
80

Five
Formatting
86

 
- Introduction to Formatting in Discoverer 4i
87

 
- Formatting Data in Discoverer 4i
88

 
- Formatting Numbers in Discoverer 4i
93

 
- Formatting Dates in Discoverer 4i
94

 
- Formatting Text in Discoverer 4i
95

 
- Setting Column Headings in Discoverer 4i
96

 
- Specifying Backgrounds in Discoverer 4i
97

 
- Creating Titles in Discoverer 4i
99

 
- Sorting Records in Discoverer 4i
104

 
- Using Exceptions in Discoverer 4i
110

 
- Creating Exceptions in Discoverer 4i
116

 
- Managing Exceptions in Discoverer 4i
117

 
- Page Setup in Discoverer 4i
118

 
- Exercise Three
122

Six
Advanced Worksheets
134

 
- Introduction
135

 
- Page Items in Discoverer 4i
136

 
- Cross-Tabs in Discoverer 4i
138

 
- Exercise Four
143

Seven
Totals
148

 
- Using Totals in Discoverer 4i
149

 
- Creating Totals in Discoverer 4i
152

Eight
Percentages
157

 
- Introduction to Percentages in Discoverer 4i
158

 
- Creating Percentages in Discoverer 4i
160

 
- Exercise Five
163

Nine
Conditions
170

 
- Limiting Data in Discoverer 4i
171

 
- Administrator Conditions
173

 
- Creating Conditions in Discoverer 4i
177

 
- Advanced Conditions in Discoverer 4i
187

 
- Exercise Six
192

Ten
Calculations
197

 
- Creating Additional Items in Discoverer 4i
198

 
- Oracle Functions in Discoverer 4i
204

 
- Exercise Seven
207

Eleven
Parameters
214

 
- Creating Parameters in Discoverer 4i
215

 
- Disabling Parameters in Discoverer 4i
224

 
- Advanced Parameters in Discoverer 4i
225

 
- Exercise Eight
229

Twelve
Aggregation
233

 
- Totalling Values in Discoverer 4i
234

 
- Example of Aggregation in Discoverer 4i
235

 
- Data Points in Discoverer 4i
239

 
- Date Hierarchies in Discoverer 4i
242

 
- Exercise Nine
245

Thirteen
Drilling
250

 
- Drilling Through Data in Discoverer 4i
251

 
- Using Hierarchies in Discoverer 4i
252

 
- Types of Drilling in Discoverer 4i
253

 
- Using Drilling in Discoverer 4i
256

 
- Drill Dialog in Discoverer 4i
258

 
- Drilling Up and Down in Discoverer 4i
261

 
- Drilling to a Related Item in Discoverer 4i
262

 
- Drill to Detail in Another Sheet in Discoverer 4i
263

 
- Drill to an External Application (Hyper Drill)
264

 
- Exercise Ten
265

Fourteen
Graphs
270

 
- Graphically Representing Data in Discoverer 4i
271

 
- Incorporating Graphs in Discoverer 4i
272

 
- Graphs Wizard in Discoverer 4i
273

 
- Graph Window in Discoverer 4i
278

 
- Modifying Graphs in Discoverer 4i
279

Fifteen
Worksheet Options
288

 
- Introduction
289

 
- General
290

 
- Query Governor
291

 
- Table
293

 
- Crosstab
295

 
- Formats
296

 
- Cache
297

 
- Advanced
298

 
- EUL
299

 
- Additional
300

Sixteen
Additional Features
301

 
- Exporting Data from Discoverer 4i
302

 
- Copy and Paste
304

 
- Excel Direct
305

 
- Sharing Workbooks in Discoverer 4i
306

 
- Deleting a Workbook in Discoverer 4i
308

 
- Scheduling a Workbook in Discoverer 4i
309

 
- Managing Scheduled Workbooks in Discoverer 4i
315

Seventeen
Line Commands
321

 
- Using Line Commands Discoverer 4i
322

 
- DOS
323

 
- Options
331

 
- Exercise Eleven
336

Eighteen
Complex Queries
337

 
- Creating a Worksheet Using SQL
338

 
- Subqueries in Discoverer 4i
341

 
- Creating a Subquery in Discoverer 4i
342

 
- Alternative Subquery Creation
343

Nineteen
Help
344

 
- Introduction
345

 
- Exercise Twelve
352