Oracle 10g Discoverer for Administrators培訓
Oracle 10g Discoverer for Administrators培訓
培訓大綱：
1. Introduction
Benefits of Discoverer
Components of Oracle Discoverer
Business Areas
The Role of the Discoverer Manager
2. Setting Up The Tutorial
Starting Oracle Discoverer Administrator
Grant access privileges to users
Granting business area access
3. Customizing the Tutorial
Customizing items
Lists of values (LOV)
Alternative sorts
Calculated items
Modifying content type
Designing complex folders
Creating and working with hierarchies
Create summary folders
4. Managing the End-User Layer (EUL)
Creating an EUL
Multiple EULs
Migrating between EUL releases
Setting the default EUL
EUL status workbooks
5. Building a New Business Area
Building the business area
Managing a business area
6. Access Privileges and Security
Using the privileges window
Using the security window
7. Item Classes and List of Values
Item classes
Lists of values
The Item Class Wizard
Creating an alternative sort class
Linking folders for drill-to-detail
8. Joins
Joins
Outer joins
Multi-item joins
Join properties
Fan traps
9. Calculations
Choosing items
Choosing SQL functions
10. Conditions
Mandatory conditions
Optional conditions
Choosing items for conditions
Compound/complex conditions
11. Hierarchies
Item hierarchies
Date hierarchies
Relating items and hierarchies
12. Folders
Creating a custom folder
Creating a complex folder
13. Summaries
Summary folders
Summary redirection
14. Advanced Options
Creating custom PL/SQL functions
Registering PL/SQL functions
The Command line interface
10gAS Discoverer Plus and Viewer
Registry settings
?

?

?
?

?

?