Oracle Discoverer 4i
Discoverer is an all-in-one information tool from Oracle. Discoverer gives you sophisticated ad hoc query, analysis, reporting and web publishing capabilities.
Administration Edition Is an application that database administrators use to prepare the data so users' exploration can be easy and productive. User Edition Enables business professionals to explore and analyze the data that's important to them -- while avoiding complex database structures and procedures.
Administration Edition
The Administration Edition is the tool you'll use to maximize these benefits for your users Because most databases are designed for efficient data storage, not for ease of use. Discoverer User Edition makes data in databases easy to use by presenting it with familiar business-like names, organized to serve users' needs.
To help users get the most from Discoverer User Edition, we need to perform a series of tasks. •7 Step Process
7 Step Process • • • • • • •
Perform Business Analysis of User requirements Mapping User needs to Database Structures Create End User Layer (EUL) Create Business Areas Refine Business Areas to fit User needs Use Admin Edition to maintain Business Areas Privileges to Users/Roles
End User Layer The End User Layer lies between the User Edition and the database. It shields users from the complexity of database tables, views, columns, joins, and SQL.
Business Area
A business area is a logical grouping of information from database tables or views. Within a business area, you create: Folders -- based on tables and views. Items -- based on columns.
Business areas are stored in the End User Layer.
The structure and names that you choose for the business areas, folders, and items can make the data easier for users to query and analyze.
Admin Edition Components
End User Layer Business Area Folder Items Joins
Using Admin Edition •
Providing Data Access
• •
Query and Report Formatting Drilling Through Data
Features and Benefits
Ease of use • • • • • • • •
Bulk load Automatic Join Creation List of Values Automatic drill creation Custom Folders Mandatory Stored Conditions Centralized Repository Command-line Interface
Features and Benefits
(contd...)
Enhancing User Productivity • • •
Calculated items Complex folders Item Hierarchy creation
Performance • • • •
Query Prediction Batch Controls Defining summaries from query statistics Automatic summary table maintenance
Features and Benefits
(contd...)
Openness • • • •
Integrated security Designer/2000 repository integration EUL Gateway ODBC support
User Edition With Discoverer we can: Rapidly query a relational database, data warehouse or data mart. Intuitively drill down and analyze data by simply clicking and dragging. Produce high-impact reports, presentations, and Web pages from your results. Access non-Oracle databases using ODBC. Send reports to other users via MAPI-compliant e-mail. Schedule reports to be run at a later date and time using Discoverer's batch facility.
Steps for Creating Workbook Create new workbook / Open an existing workbook Choose the type of layout • Table • Crosstab • Page-Detail table • Page-Detail crosstab Choose the Business Area Choose the required columns from folders Define conditions Define sorting options Define Calculations (Formula’s)
Features
•
Data filtering conditions
•
Sorting conditions
•
Total’s (group totals/ summary totals)
•
Percentages
•
Calculations
•
Parameters
•
Query Governing
Benefits
•
Importing SQL Query
•
Exporting SQL Query
•
Export Report data
•
Schedule workbook
•
Share Workbook
•
Send workbook as a mail
THANK YOU