Discoverer Overview

1
Richard Byrom
Consultant RPC Data 9th June 2002
2
Discoverer Overview
3
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.

4
What is Discoverer?

• Market leading end-user ad hoc query, analysis
  and reporting tool that is also web enabled.

5
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.

6
Discoverer Strengths

• Ease of Use
• Analytical Power
• Scalability and Performance
• Ease of Administration
• Integration and Customization

7
Ease of Use
8
Business View of Database Information Hiding the
complexity
Database
Users View
9
Strong Focus on Customer Usability
10
Single User Interface
Discoverer for Windows
Discoverer 3i User Edition
Discoverer 3i Viewer
Desktop Edition (c/s)
Plus (java)
Viewer (HTML)
11
Drill Everywhere
Europe

• Drill Down

France
Paris
12
Drill Everywhere

• Drill Down

13
Analytic Power
14
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?

15
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

16
Empower your users
Ratios
Rank
Subtotals
17
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)
18
Performance Scalability
19
Discoverer Architecture
ApplicationServer(s)
Clients
DatabaseServer(s)
DMZ
Oracle9i Application Server
Oracle9i Application Server
Oracle9i Web Cache
EUL Metadata
Database
Oracle9i Application Server
Internet users
Metadata in DB
Load Balancing
Firewall Support
Multiple Servers
20
Cubic Client CachePerformance
Client

• Re-using cache
• OLAP type access
• Rapid drill rotate

Oracle9i Application Server
Discoverer Services
Client Session
Database
21
Cubic Client CachePerformance
Client

• Re-using cache
• OLAP type access
• Rapid drill rotate
• Incremental Drill

Oracle9i Application Server
Discoverer Services
Client Session
Database
22
Advanced Query Prediction Performance
Reactive Query Governor

• Stops queries after a pre-set time

• Uses the resources without showing results!

Predictive Query Governor
23
Batch Scheduling

• Wizard Driven
• User friendly scheduling

• Easy management
• Automatic notice when result set is ready or to
  expire

24
Summary Redirection
Detail Rows
Summary Table
25
Summary Redirection
Automatic!!
Detail Rows
Summary Table
26
Ease of Administration
27
Discoverer AdministratorEasy End User Layer
Management
Easy Administration Bulk Load Wizard EUL
Management Wizard Tutorial Installation

• Oracle9i Discoverer Administrator
• Populate Business Area
• Hierarchies
• Joins
• Default Aggregates
• LOVs
• Create/Delete EULs
• Sample schema and EUL for
• training

28
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?

29
Simplified Deployment
Application
Application
X
Application
Database
Application
30
Centralized Metadata
Reports
X
Metadata
31
DiscovererAutomated 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.

32
DiscovererAutomated Summary Management
automated - summary policies dont need to be
a DBA the algorithm - tune for different
policies performance gain estimate

• 100
• Easy to use
• Customize
• Graphical

33
Customization Integration
34
Discoverer Viewer Custom Look and Feel
Custom
Standard
35
(No Transcript)
36
(No Transcript)
37
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

38
Discoverer integration with Portal
Worksheet Portlet Graph
Worksheet Portlet Crosstab
List of Workbooks Portlet
39
Oracle e-Business Suite Business Intelligence
Solution
Query/Reporting Tools
Financial Applications
OLAP Applications
Business Intelligence System
Manufacturing Applications
40
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

41
Meeting Requirements...
Requirements Ease of Use Analytic Power
Central Administration Security
Integration Customization Price
Oracle9iAS Discoverer Single UI Instant Web
Deployment Free SQL Analytics Centralized
Metadata Single Sign On (SSO) Database, OWB,
Reports, Portal, Web Cache, SSO, e-Business
Suite XSL Style Sheet 4 Times Less
42
Benefits...
Benefits Empowered Users Reduced Administrative
Costs Reduced Deployment Costs Reduced IT
Dependency Competitive Advantage Better Decision
Making
Oracle9iAS Discoverer
Yes
Yes
Yes
Yes
Yes
Yes
43
Demonstration - Query

• Description of how to build an end user layer
  specific to user requirements and security
  specifications different views for different
  people

44
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

45
Demonstration - Reporting

• Show how you can export the data to excel and
  express

46
A