slide1
Download
Skip this Video
Download Presentation
Richard Byrom

Loading in 2 Seconds...

play fullscreen
1 / 46

Richard Byrom - PowerPoint PPT Presentation


  • 134 Views
  • Uploaded on

Richard Byrom. Consultant RPC Data 9 th 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?.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Richard Byrom' - rhoslyn


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1
Richard Byrom

Consultant

RPC Data

9th June 2002

presentation purpose
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
What is Discoverer?

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

what does it do
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
Discoverer Strengths
  • Ease of Use
  • Analytical Power
  • Scalability and Performance
  • Ease of Administration
  • Integration and Customization
business view of database information hiding the complexity
cl_addr1||','||

cl_addr2|','||

cl_addr3||', '||

cl_twn||', '||

cl_zipcode

sum(nvl(qty*

unit_price,0))

Business View of Database InformationHiding the complexity

Database

User’s View

strong focus on customer usability
One Click Operations
  • Wizard Driven
  • Tutorials
  • Reduced Learning Curve

Drag & Drop Layout

Interactive Dialogs

Strong Focus on Customer Usability
slide10
Single User Interface

Discoverer for Windows

Discoverer 3i User Edition

Discoverer 3i Viewer

Desktop Edition (c/s)

Plus (java)

Viewer (HTML)

drill everywhere
Drill Everywhere

Europe

  • Drill Down

France

Paris

drill everywhere12
Europe

France

  • Drill Out

Paris

External

Data

Drill Everywhere
  • Drill Down
power and simplicity you demand
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
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
Empower your users

Ratios

Rank

Subtotals

nesting analytic power
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)

slide19
internet

Discoverer Architecture

Clients

ApplicationServer(s)

DatabaseServer(s)

DMZ

Oracle9i

Application

Server

Oracle9i

Application

Server

Oracle9i

Web

Cache

EUL Metadata

Database

Oracle9i

Application

Server

Internet users

Metadata

in DB

Firewall

Support

Load Balancing

Multiple Servers

slide20
EUL

Cubic Client CachePerformance

Client

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

Oracle9i Application Server

Discoverer

Services

Client Session

Database

slide21
?

EUL

Cubic Client CachePerformance

Client

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

Oracle9i Application Server

Discoverer

Services

Client Session

Database

slide22
Predicts time a query takes before execution
  • Does not waste valuable resources!

Advanced Query Prediction

Performance

Reactive Query Governor

  • Stops queries after a pre-set time
  • Uses the resources without showing results!

Predictive Query Governor

slide23
Batch Scheduling
  • Wizard Driven
  • User friendly scheduling
  • Easy management
  • Automatic notice when result set is ready or to expire
slide24
Select Store, Period, Product, sum(video_sales)

From video_details

Group by Store, Period, Product

  • Slow Table Scans
  • Machine Intensive Aggregation

Summary Redirection

Detail Rows

Summary Table

slide25
Select Store, Period, Product, Sales

Fromvideo_summary

Summary Redirection

Automatic!!

Detail Rows

Summary Table

slide26
Ease of

Administration

discoverer administrator easy end user layer management
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
administrative reporting
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

Application

Browser

Java

Oracle9iAS Discoverer Services

Browser

Simplified Deployment

Application

Application

X

Application

Database

Application

centralized metadata
Reports

Metadata

Reports

Metadata

Reports

Metadata

Reports

Metadata

Database

Oracle9iAS Discoverer Services

Centralized Metadata

Reports

X

Metadata

slide31
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.
slide32
DiscovererAutomated Summary Management

: automated - summary policies

: don’t need to be a DBA

: the algorithm - tune for different policies

: performance gain estimate

  • 100%
  • Easy to use
  • Customize
  • Graphical
slide33
Customization &

Integration

slide34
Discoverer Viewer

Custom Look and Feel

Custom

Standard

complete and integrated bi
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
Discoverer integration with Portal

Worksheet Portlet: Graph

Worksheet Portlet: Crosstab

List of Workbooks Portlet

oracle e business suite business intelligence solution
Discoverer EUL

Business Views

Logical Data Model

Application

Product

Tables

Oracle e-Business Suite Business Intelligence Solution

Query/Reporting Tools

Financial

Applications

OLAP

Applications

Business

Intelligence

System

Manufacturing

Applications

out of the box oracle e business suite integration
“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
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

benefits
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

demonstration query
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
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
Demonstration - Reporting

Show how you can export the data to excel and express

slide46
Q

&

Q U E S T I O N S

A N S W E R S

A

ad