Richard Byrom
Download
1 / 46

Richard Byrom - PowerPoint PPT Presentation


  • 132 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 l.jpg

Richard Byrom

Consultant

RPC Data

9th June 2002



Presentation purpose l.jpg
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 l.jpg
What is Discoverer?

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


What does it do l.jpg
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 l.jpg
Discoverer Strengths

  • Ease of Use

  • Analytical Power

  • Scalability and Performance

  • Ease of Administration

  • Integration and Customization



Business view of database information hiding the complexity l.jpg

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 l.jpg

One Click Operations

  • Wizard Driven

  • Tutorials

  • Reduced Learning Curve

Drag & Drop Layout

Interactive Dialogs

Strong Focus on Customer Usability


Slide10 l.jpg

Single User Interface

Discoverer for Windows

Discoverer 3i User Edition

Discoverer 3i Viewer

Desktop Edition (c/s)

Plus (java)

Viewer (HTML)


Drill everywhere l.jpg
Drill Everywhere

Europe

  • Drill Down

France

Paris


Drill everywhere12 l.jpg

Europe

France

  • Drill Out

Paris

External

Data

Drill Everywhere

  • Drill Down



Power and simplicity you demand l.jpg
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 l.jpg
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 l.jpg
Empower your users

Ratios

Rank

Subtotals


Nesting analytic power l.jpg
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 l.jpg

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 l.jpg

EUL

Cubic Client CachePerformance

Client

  • Re-using cache

  • OLAP type access

  • Rapid drill & rotate

Oracle9i Application Server

Discoverer

Services

Client Session

Database


Slide21 l.jpg

?

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 l.jpg

  • 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 l.jpg

Batch Scheduling

  • Wizard Driven

  • User friendly scheduling

  • Easy management

  • Automatic notice when result set is ready or to expire


Slide24 l.jpg

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 l.jpg

Select Store, Period, Product, Sales

Fromvideo_summary

Summary Redirection

Automatic!!

Detail Rows

Summary Table


Slide26 l.jpg

Ease of

Administration


Discoverer administrator easy end user layer management l.jpg
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 l.jpg
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 l.jpg

Application

Application

Application

Application

Browser

Java

Oracle9iAS Discoverer Services

Browser

Simplified Deployment

Application

Application

X

Application

Database

Application


Centralized metadata l.jpg

Reports

Metadata

Reports

Metadata

Reports

Metadata

Reports

Metadata

Database

Oracle9iAS Discoverer Services

Centralized Metadata

Reports

X

Metadata


Slide31 l.jpg

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 l.jpg

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 l.jpg

Customization &

Integration


Slide34 l.jpg

Discoverer Viewer

Custom Look and Feel

Custom

Standard


Complete and integrated bi l.jpg
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 l.jpg
Discoverer integration with Portal

Worksheet Portlet: Graph

Worksheet Portlet: Crosstab

List of Workbooks Portlet


Oracle e business suite business intelligence solution l.jpg

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 l.jpg
“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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
Demonstration - Reporting

Show how you can export the data to excel and express


Slide46 l.jpg

Q

&

Q U E S T I O N S

A N S W E R S

A


ad