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

Course Name: Discoverer User 3.1

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

Synopsis for course

Oracle Discoverer 3.1 User 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.1
3

 
- What is Discoverer 3.1 User
4

 
- Understanding Discoverer 3.1 Terminology
5

 
- How to run Discoverer 3.1 User
15

Two
Discoverer 3.1 User Interface
17

 
- Connecting to Discoverer 3.1
18

 
- Anatomy of Discoverer 3.1
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 3.1
31

 
- Write Permissions in Discoverer 3.1
33

 
- Using Different Accounts
34

 
- Missing Items in Discoverer 3.1
37

 
- Multiple EULs in Discoverer 3.1
39

 
- Running the Query in Discoverer 3.1
42

 
- Re-Sizing Items in Discoverer 3.1
43

 
- Pivoting Items in Discoverer 3.1
45

 
- Saving Workbooks in Discoverer 3.1
51

 
- Using Parameters in Discoverer 3.1
52

 
- Exercise One
55

Four
Simple Workbooks
62

 
- Creating Workbooks in Discoverer 3.1
63

 
- Modifying Workbooks in Discoverer 3.1
78

 
- Duplicating Worksheets in Discoverer 3.1
79

 
- Exercise Two
80

Five
Formatting
86

 
- Introduction to Formatting in Discoverer 3.1
87

 
- Formatting Data in Discoverer 3.1
88

 
- Formatting Numbers in Discoverer 3.1
93

 
- Formatting Dates in Discoverer 3.1
94

 
- Formatting Text in Discoverer 3.1
95

 
- Setting Column Headings in Discoverer 3.1
96

 
- Specifying Backgrounds in Discoverer 3.1
97

 
- Creating Titles in Discoverer 3.1
99

 
- Sorting Records in Discoverer 3.1
104

 
- Using Exceptions in Discoverer 3.1
110

 
- Creating Exceptions in Discoverer 3.1
116

 
- Managing Exceptions in Discoverer 3.1
117

 
- Page Setup in Discoverer 3.1
118

 
- Exercise Three
122

Six
Advanced Worksheets
134

 
- Introduction
135

 
- Page Items in Discoverer 3.1
136

 
- Cross-Tabs in Discoverer 3.1
138

 
- Exercise Four
143

Seven
Totals
148

 
- Using Totals in Discoverer 3.1
149

 
- Creating Totals in Discoverer 3.1
152

Eight
Percentages
157

 
- Introduction to Percentages in Discoverer 3.1
158

 
- Creating Percentages in Discoverer 3.1
160

 
- Exercise Five
163

Nine
Conditions
170

 
- Limiting Data in Discoverer 3.1
171

 
- Administrator Conditions
173

 
- Creating Conditions in Discoverer 3.1
177

 
- Advanced Conditions in Discoverer 3.1
187

 
- Exercise Six
192

Ten
Calculations
197

 
- Creating Additional Items in Discoverer 3.1
198

 
- Oracle Functions in Discoverer 3.1
204

 
- Exercise Seven
207

Eleven
Parameters
214

 
- Creating Parameters in Discoverer 3.1
215

 
- Disabling Parameters in Discoverer 3.1
224

 
- Advanced Parameters in Discoverer 3.1
225

 
- Exercise Eight
229

Twelve
Aggregation
233

 
- Totalling Values in Discoverer 3.1
234

 
- Example of Aggregation in Discoverer 3.1
235

 
- Data Points in Discoverer 3.1
239

 
- Date Hierarchies in Discoverer 3.1
242

 
- Exercise Nine
245

Thirteen
Drilling
250

 
- Drilling Through Data in Discoverer 3.1
251

 
- Using Hierarchies in Discoverer 3.1
252

 
- Types of Drilling in Discoverer 3.1
253

 
- Using Drilling in Discoverer 3.1
256

 
- Drill Dialog in Discoverer 3.1
258

 
- Drilling Up and Down in Discoverer 3.1
261

 
- Drilling to a Related Item in Discoverer 3.1
262

 
- Drill to Detail in Another Sheet in Discoverer 3.1
263

 
- Drill to an External Application (Hyper Drill)
264

 
- Exercise Ten
265

Fourteen
Graphs
270

 
- Graphically Representing Data in Discoverer 3.1
271

 
- Incorporating Graphs in Discoverer 3.1
272

 
- Graphs Wizard in Discoverer 3.1
273

 
- Graph Window in Discoverer 3.1
278

 
- Modifying Graphs in Discoverer 3.1
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 3.1
302

 
- Copy and Paste
304

 
- Excel Direct
305

 
- Sharing Workbooks in Discoverer 3.1
306

 
- Deleting a Workbook in Discoverer 3.1
308

 
- Scheduling a Workbook in Discoverer 3.1
309

 
- Managing Scheduled Workbooks in Discoverer 3.1
315

Seventeen
Line Commands
321

 
- Using Line Commands Discoverer 3.1
322

 
- DOS
323

 
- Options
331

 
- Exercise Eleven
336

Eighteen
Complex Queries
337

 
- Creating a Worksheet Using SQL
338

 
- Subqueries in Discoverer 3.1
341

 
- Creating a Subquery in Discoverer 3.1
342

 
- Alternative Subquery Creation
343

Nineteen
Help
344

 
- Introduction
345

 
- Exercise Twelve
352