Transcript Discoverer Overview

Richard Byrom
Consultant
RPC Data
9th June 2002
Discoverer Overview
Presentation Purpose
• Provide you with an understanding of what
Oracle Discover is and what it is capable of.
• Demonstrate the capabilities of the product on
a test system.
What is Discoverer?
Market leading end-user ad
hoc query, analysis and
reporting tool that is also web
enabled.
What does it do?
 Enables users at any level in an organization to gain
rapid access to information stored in their
transactional databases, data warehouses or data
marts.
 Provides powerful navigation and analytical
capabilities such as pivoting, drilling, aggregations
and calculations.
 In an Oracle Applications environment, it provides and
intuitive way for non technical end users (like execs
and business analysts) to get rapid answers to
business questions.
Discoverer Strengths
 Ease of Use
 Analytical Power
 Scalability and Performance
 Ease of Administration
 Integration and Customization
Ease of Use
Business View of Database
Information Hiding the complexity
Database
cl_addr1||','||
cl_addr2|','||
cl_addr3||', '||
cl_twn||', '||
cl_zipcode
sum(nvl(qty*
unit_price,0))
User’s View
Strong Focus on Customer
Usability
One Click Operations
Wizard Driven
•
•
Tutorials
Reduced Learning Curve
Drag & Drop Layout
Interactive Dialogs
Single User Interface
Discoverer for
Windows
Desktop Edition (c/s)
Discoverer 3i
User Edition
Plus (java)
Discoverer 3i
Viewer
Viewer (HTML)
Drill Everywhere
Europe
 Drill Down
France
Paris
Drill Everywhere
Europe
 Drill Down
France
 Drill Out
Paris
External
Data
Analytic Power
Power and Simplicity
You Demand
Answers to Analytical Questions
 “What are my top ten products...”
 “What is the 3 month moving average ...”
 “What is the cumulative sum of my sales by Region...”
 “What is the ranking of my sales this year compared
to sales last year?”
Analytical Power at your
fingertips !...

Calculator functions (+ - * / )

Intelligent (Sub)Totals & Percentages

SQL functions: Financial, Arithmetic, Logical, Analytic

Enhanced Data Aggregation

Custom functions - PL/SQL registered

Leverage Analytical Calculations: use with
Conditions, Sort, Pivot and nesting
Empower your users
Ratios
Rank
Subtotals
Nesting Analytic Power
Nested Calculations:
1 sales yr ago
: lag(sales, 4)
2 growth
: sales yr ago/sales this yr
3 rank growth
: rank(growth)
Performance & Scalability
Discoverer Architecture
Clients
Application
Server(s)
Database
Server(s)
DMZ
Oracle9i
Application
Server
internet
Oracle9i
Web
Cache
Oracle9i
Application
Server
Oracle9i
Application
Server
Internet
users
Firewall
Support
Load
Balancing
Multiple
Servers
EUL Metadata
Database
Metadata
in DB
Cubic Client Cache
Performance
Client
Oracle9i Application
Server
• Re-using cache
• OLAP type access
• Rapid drill & rotate
Client
Session
Discoverer
Services
EUL
Database
Cubic Client Cache
Performance
Client
Oracle9i Application
Server
Client
Session
Discoverer
Services
• Re-using cache
• OLAP type access
• Rapid drill & rotate
• Incremental Drill
?
EUL
Database
Advanced Query Prediction
Performance
Reactive Query Governor
•
Stops queries after a pre-set time
•
Uses the resources without
showing results!
Predictive Query Governor
•
Predicts time a query takes
before execution
•
Does not waste valuable
resources!
Batch Scheduling
• Wizard Driven
• Easy management
• User friendly scheduling • Automatic notice when
result set is ready or to expire
Summary Redirection
Select Store, Period, Product, sum(video_sales)
From video_details
Group by Store, Period, Product
• Slow Table Scans
• Machine Intensive
Aggregation
Detail Rows
Summary Table
Summary Redirection
Select Store, Period, Product, Sales
From video_summary
Automatic!!
Detail Rows
Summary Table
Ease of
Administration
Discoverer Administrator
Easy End User Layer Management
Easy Administration
Oracle9i Discoverer Administrator
Bulk Load Wizard
Populate Business Area
• Hierarchies
• Joins
• Default Aggregates
• LOVs
EUL Management Wizard Create/Delete EULs
Tutorial Installation
Sample schema and EUL for
training
Administrative Reporting
• Which Folders are users querying most? Which Items?
• Where are my long running queries?
• Who owns what workbooks? When were they last used?
• What are my users privileges?
Simplified Deployment
Application
Application
Application
X
Application
Database
Application
Application
Browser
Java
Browser
Oracle9iAS
Discoverer Services
Centralized Metadata
Reports
Metadata
Reports
Metadata
Reports
Reports
Metadata
Metadata
X
Reports
Metadata
Database
Oracle9iAS
Discoverer Services
Discoverer
Automated Summary Management
Evolutionary solution for
optimizing query performance!
•Discoverer Summary Wizard
• recommends summary policies,
• create summary tables with a single click,
• allow users to view and fine tune policies as needed.
Discoverer
Automated Summary Management
•
•
•
•
100%
: automated - summary policies
Easy to use
: don’t need to be a DBA
Customize
: the algorithm - tune for different policies
Graphical
: performance gain estimate
Customization &
Integration
Discoverer Viewer
Custom Look and Feel
Custom
Standard
Complete and Integrated BI





Oracle9iAS OEM
Oracle9iAS Reports
Oracle9iAS Portal
Oracle9iAS Web Cache
Oracle Single Sign On Server
–
Oracle Internet Directory
 Oracle9i Warehouse Builder
 Oracle e-Business Suite
Discoverer integration with
Portal
Worksheet
Portlet: Graph
Worksheet
Portlet: Crosstab
List of
Workbooks
Portlet
Oracle e-Business Suite
Business Intelligence Solution
Financial
Applications
Discoverer EUL
Query/Reporting
Tools
Business Views
Logical Data Model
Application
Product
Tables
Manufacturing
Applications
OLAP
Applications
Business
Intelligence
System
“Out of the Box”
Oracle e-Business Suite
Integration
 Native Oracle Application Security
–
–
–
–
Respecting 100% Apps user accounts /responsibilities
No extra setup
The same level of multi-org access control
Reporting on cross organizations w/ users Apps grants
 Applications Key and Descriptive Flexfields
–
Reporting on full apps data inc. customized flexfields
Meeting Requirements...
Requirements
Oracle9iAS Discoverer
Ease of Use
Single UI
Instant Web Deployment
Analytic Power
Free SQL Analytics
Central Administration
&
Security
Centralized Metadata
Single Sign On (SSO)
Integration
Database, OWB, Reports,
Portal, Web Cache, SSO,
e-Business Suite
XSL Style Sheet
Customization
4 Times Less
Price
Benefits...
Benefits
Oracle9iAS
Discoverer
Empowered Users
Yes
Reduced Administrative Costs
Yes
Reduced Deployment Costs
Yes
Reduced IT Dependency
Yes
Competitive Advantage
Yes
Better Decision Making
Yes
Demonstration - Query
Description of how to build an end user layer
specific to user requirements and security
specifications – different views for different
people
Demonstration - Analysis
 Tables, page detail reports and cross tabs
 Show the use of conditions, exceptions and
calculations and drag and drop
 Show a graph with a drill through
Demonstration - Reporting
Show how you can export the data to excel
and express
Q U E S T I O N S
A N S W E R S