Oracle Discover 4i Administration

Request more details:

submit request
Description:
This course gives participants hands-on experience with administration tasks for Oralce`s Graphical User Interface (GUI) based ad hoc query and data access tool - Discoverer.

View other Oracle Courses available
Prerequisites:
Oracle Discoverer 4i Desktop, familiarality with Windows 95/98 or Windows NT. Understanding of Relational Databases helpful.
Introduction:
Benefits of Discoverer
Components of Oracle Discoverer
Business Areas
The role of the discoverer administrator
Setting up the Tutorial:
Starting Oracle Discoverer Administration edition
Grant access privileges to the users
Granting business area access
Customise Items
Lists of values (LOV)
Alternative sorts
Calculated items
Designing complex folders
Creating and working with Hierarchies
Create summary folders
Content type
Building a New Business Area:
Building the business area
Managing a business area
Access Privilages and Secrity:
Using the privileges window
Database Security
Item Classes and List of Values:
Item Classes
Joins:
Joins
Fan traps
Calculations:
Calculations
Conditions:
Conditions
Compound/complex conditions
Hierarchies:
Item Hierarchies
Date Hierarchies
Summaries:
Summary tables
Advanced Options:
Registering PL/SQL functions
Command line options