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

Course Name: Discoverer Desktop 9i

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

Synopsis for course

Oracle Discoverer 9i Desktop 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 9i?
3

 
- What is Discoverer 9i Desktop?
4

 
- Understanding Discoverer 9i Terminology
5

 
- How to run Discoverer 9i
15

Two
Discoverer 9i Desktop Interface
17

 
- Connecting to Discoverer 9i
18

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

 
- Write Permissions in Discoverer 9i
33

 
- Using Different Accounts
34

 
- Missing Items in Discoverer 9i
37

 
- Multiple EULs in Discoverer 9i
39

 
- Running the Query in Discoverer 9i
42

 
- Re- Sizing Items in Discoverer 9i
43

 
- Pivoting Items in Discoverer 9i
45

 
- Saving Workbooks in Discoverer 9i
51

 
- Using Parameters in Discoverer 9i
52

 
- Exercise One
55

Four
Simple Workbooks
62

 
- Creating Workbooks in Discoverer 9i
63

 
- Modifying Workbooks in Discoverer 9i
78

 
- Duplicating Worksheets in Discoverer 9i
79

 
- Counting Records in Discoverer 9i
80

 
- Exercise Two
81

Five
Formatting
87

 
- Introduction to Formatting in Discoverer 9i
88

 
- Formatting Data in Discoverer 9i
89

 
- Formatting Numbers in Discoverer 9i
94

 
- Formatting Dates in Discoverer 9i
95

 
- Formatting Text in Discoverer 9i
96

 
- Setting Column Headings in Discoverer 9i
97

 
- Specifying Backgrounds in Discoverer 9i
98

 
- Creating Titles in Discoverer 9i
100

 
- Sorting Records in Discoverer 9i
105

 
- Using Exceptions in Discoverer 9i
111

 
- Creating Exceptions in Discoverer 9i
117

 
- Managing Exceptions in Discoverer 9i
118

 
- Page Setup in Discoverer 9i
119

 
- Exercise Three
123

Six
Advanced Worksheets
135

 
- Introduction
136

 
- Page Items in Discoverer 9i
137

 
- Cross- Tabs in Discoverer 9i
139

 
- Exercise Four
144

Seven
Totals
149

 
- Using Totals in Discoverer 9i
150

 
- Creating Totals in Discoverer 9i
153

Eight
Percentages
158

 
- Introduction to Percentages in Discoverer 9i
159

 
- Creating Percentages in Discoverer 9i
161

 
- Exercise Five
164

Nine
Conditions
171

 
- Limiting Data in Discoverer 9i
172

 
- Administrator Conditions
174

 
- Creating Conditions in Discoverer 9i
178

 
- Advanced Conditions in Discoverer 9i
188

 
- Exercise Six
193

Ten
Calculations
198

 
- Creating Additional Items in Discoverer 9i
199

 
- Oracle Functions in Discoverer 9i
205

 
- Exercise Seven
150

Eleven
Parameters
215

 
- Creating Parameters in Discoverer 9i
216

 
- Disabling Parameters in Discoverer 9i
225

 
- Advanced Parameters in Discoverer 9i
226

 
- Exercise Eight
230

Twelve
Aggregation
234

 
- Totalling Values in Discoverer 9i
235

 
- Example of Aggregation in Discoverer 9i
236

 
- Data Points in Discoverer 9i
240

 
- Date Hierarchies in Discoverer 9i
243

 
- Exercise Nine
246

Thirteen
Drilling
251

 
- Drilling Through Data in Discoverer 9i
252

 
- Using Hierarchies in Discoverer 9i
253

 
- Types of Drilling in Discoverer 9i
254

 
- Using Drilling in Discoverer 9i
257

 
- Drill Dialog in Discoverer 9i
259

 
- Drilling Up and Down in Discoverer 9i
262

 
- Drilling to a Related Item in Discoverer 9i
263

 
- Drill to Detail in Another Sheet in Discoverer 9i
264

 
- Drill to an External Application (Hyper Drill)
265

 
- Exercise Ten
266

Fourteen
Graphs
271

 
- Graphically Representing Data in Discoverer 9i
272

 
- Incorporating Graphs in Discoverer 9i
273

 
- Graphs Wizard in Discoverer 9i
274

 
- Graph Window in Discoverer 9i
279

 
- Modifying Graphs in Discoverer 9i
259

Fifteen
Summaries
289

 
- Purpose of Summaries in Discoverer 9i
290

Sixteen
Worksheet Options
292

 
- Introduction
293

 
- General
294

 
- Query Governor
295

 
- Table
297

 
- Crosstab
299

 
- Aggregation
300

 
- Formats
301

 
- Cache
302

 
- Connection
303

 
- Advanced
304

 
- EUL
305

 
- Additional
306

Seventeen
Additional Features
307

 
- Exporting Data from Discoverer 9i
308

 
- Copy and Paste
310

 
- Excel Direct
311

 
- Sharing Workbooks in Discoverer 9i
312

 
- Deleting a Workbook in Discoverer 9i
314

 
- Scheduling a Workbook in Discoverer 9i
315

 
- Managing a Workbook in Discoverer 9i
321

Eighteen
Line Commands
327

 
- Using Line Commands Discoverer 9i
328

 
- DOS
329

 
- Options
337

 
- Exercise Eleven
342

Nineteen
Complex Queries
343

 
- Creating a Worksheet Using SQL
344

 
- Subqueries in Discoverer 9i
347

 
- Creating a Subquery in Discoverer 9i
348

 
- Alternative Subquery Creation
349

Twenty
Help
350

 
- Introduction
351

 
- Help Topics
352

 
- Using Help
353

 
- About Discoverer 9i
354

 
- Exercise Twelve
355