Oracle Olap

Oracle9i OLAP A Scalable Web-Base Business Intelligence Platform

Agenda

Mary Rehus Sales Consultant Patrick Larkin Vice President, Oracle Consulting

Ÿ Ÿ Ÿ Ÿ Ÿ

Business Intelligence Market Oracle9i OLAP Business Intelligence Beans Express Direction and Migration Questions/Answers

Oracle Corporation

Business Intelligence

Business Intelligence Market Applications

Ÿ Business Intelligence Applications are now a driving force within leading organizations – – –

A competitive necessity Data warehouses Internet

Tools

Advanced analysis and planning

Oracle Reports

Oracle Discoverer Business Intelligence Beans & JDeveloper OLAP Services - Java OLAP API

APIs

SQL OLAP Static Reporting

Ad-hoc reporting

Analysis

Predictive Analysis

Analytical Power

Page 1 1

Traditional Analytic Servers

Oracle9i Analytic Platform

OLAP Engine

Oracle9i

Data Integration Engine

Data Warehousing

Data Warehouse Engine

ETL

Mining Engine

OLAP

Data Mining

BI Application Platform Oracle JDeveloper

Oracle 9i The new platform for business intelligence applications

Supporting Enterprise Applications Ÿ Ÿ Ÿ Ÿ Ÿ Ÿ Ÿ

Oracle BI Beans

Rapid application development Analysis ready

Oracle9i OLAP Services

Java OLAP API Predictive analysis functions

Oracle9i

Scaleable data store Integrated metadata Summary management SQL analytic functions

Oracle9i OLAP Services

Improved scalability An open data store Reduce or eliminate replication A single security model A single set of management tools Availability features of the database Pure Internet

OLAP Services Java OLAP API Metadata Provider

SQL Generator

Query Processor

Multidimensional Engine

Oracle Database

OLAP Catalog

Data Warehouse Analytic Workspace

Page 2 2

Java OLAP API

Oracle Relational Database

Ÿ Designed for OLAP on the Internet

Ÿ High performance cell access

– – – – –

Java, object-oriented Multidimensional calculations Multidimensional cursors Insulates application developer from SQL Insulates application from physical data store

– – – – –

Parallel query Bitmap join indexes Grouping sets & partition pruning Automatic memory tuning OLAP Calculations

Ÿ Summary Management

Summary Management BI Beans / Client

Management Ÿ Oracle Enterprise Manager

Summary Materialized View with Grouping Sets

– – – – –

Java OLAP API SQL Generator

Data modeling Job scheduling Performance monitoring Users Security

Detail Table

Page 3 3

Business Intelligence Beans Table

Cross Tab

Chart Query Builder

Business Intelligence Beans

Calculation Builder

Query Metadata Manager Connection Oracle9i OLAP Services

Persistence Oracle9i

Beans Repository

Common UI for Oracle BI Ÿ Provides common user interface across Oracle products – – – –

Discoverer Reports Portal Etc.

Page 4 4

Page 5 5

Application Deployment

Oracle9iAS Oracle9i OLAP Services Data warehouse BI Beans Repository

Java Application or Applet

Developing with JDeveloper Ÿ Automatic code generation wizards Ÿ Live connections to Oracle9i and OLAP Services Ÿ Live connection to BI Beans repository

PC PDA Browser

Servlet

Mobile Phone

Define application objects

Edit application objects

Wizard-driven definition of objects

Designers enable editing of data-aware objects

Export to run-time repository

Java applet wizard

Deployed objects accessible to end users

Generates basic analytical application w/no coding

Open/save views Define queries Define calculations Export Format views

Page 6 6

Servlet wizard Generates simple viewer with no coding

9i OLAP vs Express

Open/save presentations Export to spreadsheet Change view type Drill/rotate Apply favorite selections

Comparison with Express Feature

Express

Express Server

Oracle 9i

Yes RAM

Native

Native

Native

SPL

SPL

Query API

SNAPI

Java

Authentication

Op. Sys

Database

Administration

Stand-alone

Integrated

Development Tools

Client-server

Internet

Relational data Multidimensional data Data manipulation language

Ÿ New versions of Express Server 6.x to be released – –

AGGREGATE enhancements Web Agent enhancements

Ÿ Express Server will maintained and supported for 4-5 years Ÿ New versions of tools and applications to be released on Express Server 6.x

Express Migration

For more information:

Ÿ Data

Ÿ www.oracle.com/

–

Keep in Analytic Workspace or load into Oracle

–

Ÿ Applications (OSA, OFA, ODP) –

–

Upgrade to Oracle Enterprise Planning & Budgeting

–

White papers and data sheets Oracle Technical Network (OTN) Oracle Learning Network (OLN)

Ÿ Express Objects –

Replace with BI Beans applications

Ÿ Web Agent –

Replace with BI Beans applications

Page 7 7

Q& A

Q U E S T I O N S A N S W E R S

Page 8 8