PLEASE READ THE NOTES!

 Important information and instructions are provided in the Notes section of the slides.

Speaker Name

Speaker Title Speaker Title Oracle Corporation

Oracle Discoverer

Drake Release Preview

Essential . Insight . Now

Agenda

      Information Consolidation Discover Business Insights Complete Solution Innovative OLAP Next Steps Q&A

Information Consolidation

Getting More Value for Less Effort

Information & Data Consolidation

Relational OLAP

Information & Data Consolidation

Relational & OLAP Databases Unite

Information & Data Consolidation

Relational & OLAP Tools Unite Relational & OLAP Databases Unite

Discover Business Insights

Informed Decision Making

What is OracleAS Discoverer?

Discoverer enables business users to easily access and share essential information to make smart decisions.

#1 in Business Intelligence

Improving Your Bottom Line

WIFAS

Woolwich Independent Financial Advisory Services Limited

Custom Analytic Applications “

We needed a 360-degree view of the customer, our relationship, and a full transaction history, rather than a partial view of the customer. This would allow us to analyze customer profitability and identify opportunities for maximizing individual customer worth.

“ Alan Keegan, Commercial Development Director

Henkel Henkel Saves More Than $1 Million and Builds Competitive Edge With Oracle9

i

Business Intelligence and 1.7 Terabyte Data Warehouse “

We achieved ROI in just over a year. Every year after

that has gone right to the bottom line.“

Matt Rhoades, Manager for Shared Data Warehouse Services

Complete Solution

Query, Analysis, Reporting, Publishing, Personalization and Administration

Access anywhere, anytime Easy-to-Use Tools for Business Users Flexible Deployment & Scalability Intuitive Management OLTP DW OLAP

Typical Analysis Needs

 What are my top selling products?

 How have margins changed month-to-month over the past year?

 Which channel has the highest growth rate year over year?

 What products have the most sales opportunities over the next twenty four months by geography?

Easily Create Reports

• Point & Click Simplicity • Drag & Drop Layout • Interactive Hints • Right-Click For Useful Options • Wizards For Multi-step Tasks

Get Information at Any Level

 Powerful ‘drilling’ feature goes from aggregated data…    To any level you define… All the way to the detailed records Even drill from OLAP to OLTP!

Create New Business Indicators Access the full power of the Oracle database Users are guided through options – No need to learn complex syntax!

Reporting Your Insights

 Need to inform others?      Publish to Oracle Portal Email to your team Save it in Excel Print to Adobe PDF Or access it from any web browser!

Create Personalized Portals

Users can personalize worksheets accessed via Portal:      Stoplighting Drills Page items Parameters Graph type

Integrate Into Dashboards Link Portlets To Shared Controls Publish Worksheets With Both Data and Graphs Launch Your Favorite Reports From One Place

Discoverer Viewer- Anywhere, Anytime

   Zero footprint, pure HTML “LIVE” analysis anywhere on the Internet Create your own view – – – – – – Drill up – down – out Change parameters Stoplight formatting Stoplight formatting Change graph types Save it to the database

Integrated Management

  Oracle EM – Centralized access – Configuration, security and performance Oracle Single Sign On – Multiple logins per user – Works with other SSO applications – SSO userid passed in database connections

Using Oracle Warehouse Builder

Design and automatically generate all metadata from a single tool

Innovative OLAP

Tapping Into Pure Analytic Power

Limited OLAP Solutions



Other vendors in the market…

–

Provide completely different products for relational and OLAP analysis – or –

–

Provide limited OLAP support through existing relational products

–

Require additional metadata mappings

Innovative OLAP Analysis

• The first truly unified analysis tool for both relational and OLAP data • Extensive support for OLAP functionality • Leverages the OLAP catalog no duplication of metadata!

OLTP DW OLAP

Discoverer for OLAP Analysis

Complete OLAP Integration Create OLAP Worksheets Publish OLAP Portlets View OLAP Worksheets In Pure HTML

D E M O N S T R A T I O N

Discoverer Plus OLAP Preview

Summary & Next Steps

Get Ready for the Next Generation of BI

Summary

 Oracle Discoverer - The Complete Solution – – – – –

Unified Tool for Relational + OLAP

Powerful Analytics Flexible Reporting and Publishing Easy to Customize and Personalize Integrated Administration  Only Oracle consolidates both data and tools for a complete and simple BI solution

Analysts’ View of Oracle BI

strong

Contenders Strong Performers Leaders Oracle

Current offering

weak weak

Strategy

strong

“Business Intelligence Platform” Forrester Research, May 2003

Discoverer Preview for OLAP

    Demonstration Release – Available Today!

Runs on OracleAS 10

g

Supports OLAP in Oracle DB 9.2 (v 9.2.0.4.1) Release information coming soon!