SCREEN SHOTS ORACLE BI

Enterprise Business Model Administration

Physical Layer – “Intelligent Request Generation”Reads in system catalog

Multiple sources

Optimized SQL generation

Regardless of Schema

Function ship to appropriate data sources/Compensation

DB2Supply Chain

DM

TeradataOLAP

OracleERP.

XML DataSource

SQL ServerAcxiom

SiebelOperational

Enterprise Business Model AdministrationBusiness Model Layer – “Calculation Engine”

Physical complexity converted to logical subject areas

Drill-Paths

Complex/Derived Measures (Level-based, time series, dimension-specific, nested)

Aggregate/Fragment Aware

Enterprise Business Model Administration

Presentation Layer

Role-based, in context, personalized presentation – Oracle Answers

Oracle BI ServerPowerful, Scalable Intelligence Across Sources

Open SQL Interface

Oracle BI EE Presentation Services

Other 3rd Party Tools

• Oracle BI Server

Native RDBMS• Oracle• SQL Server• DB2• Teradata

ODBC

Multi-dimensional• XMLA• Oracle OLAP Option• MS Analysis Services• SAP BW

Other• XML,• Excel• Text

• Simplified Business View• Unified Metadata• Intelligent Caching• Advanced calculations• Aggregate navigation & creation• Federated query and integration • Optimized SQL / function shipping

Simplified business model view

Advanced calculation & integration engine

Intelligent request generation and optimized, distributed data access

Mission critical scalability and performance

Foundation for all OBIEE presentation services

Oracle BI Suite Enterprise EditionUnified Business Intelligence Infrastructure

Ad-hoc Analysis

ProactiveDetectionand Alerts

MS OfficePlug-in

Reporting & Publishing

Interactive Dashboards

DisconnectedAnalytics

OracleBI Server

OLTP & ODSSystems

Data WarehouseData Mart

SAP, OraclePeopleSoft, Siebel,

Custom Apps

FilesExcelXML

BusinessProcess

Multidimensional Calculation and Integration Engine

Intelligent Caching Services

Intelligent Request Generation and Optimized Data Access Services

WebServices

Common Enterprise Information Model

Complete Insight Delivery Capabilities Designed for Pervasive Intelligence

• Live, intuitive, personalized dashboards• Powerful dashboard to dashboard navigation and

dynamic, event-driven guided analytics• Simple yet powerful intelligence for anyone

Oracle InteractiveDashboards

Oracle Delivers

• Automated detection & alerts for proactive insight• Content deliver to any device in multiple formats• Multi-step analysis and analytic workflows

Oracle Answers

• Powerful ad-hoc analysis via 100% Web UI• Create & modify charts, pivots and dashboards • True business user self sufficiency via intuitive,

simplified business model

Complete Insight Delivery Capabilities Designed for Pervasive Intelligence

• True “pixel-perfect” reporting and publishing • Report layout using familiar tools (e.g. Word, Adobe)• Single product for all document needs – invoices,

checks, financial statements, government forms, etc.

Oracle BI Publisher

Oracle MS Office Plug-in

• Interactive Excel and PowerPoint add-ins• Enable use of BIEE data, business model, and

report catalog within key Office applications• No fragmentation of data in local spreadsheets

Oracle Disconnected Analytics

• Full analytics for the mobile professional• Same experience whether offline or connected• Full and incremental data synchronization enables

rapid updates with minimal data set size

Guided AnalyticsLeading Users from Discovery to ActionThis is no longer about a stack of reports. Guided Analytics drives alignment and

actions through the organization by modeling and making accessible discovery and decision making best practices.

Sense and RespondReal-Time Proactive Monitoring and Response

Delivers/Analytic Agents provides true real-time in context sense and respond capabilities across systems tailored for any user on any device.

Sense and RespondProactive Monitoring Driving Business Process

BI can also be embedded directly within the business processes. All BI Content can be exposed as a set of services that are callable by SOA enabled

technologies and applications.

Tailored and Personalized InteractionsTransparent Business Intelligence

Oracle Disconnected AnalyticsFull-Featured Disconnected Client

The user experience is identical to the connected user. Dashboard and Answers functionality will act identically as if the user were connected to the server.

OracleOracleDisconnectedDisconnected

DataData

• Business ModelDisconnected BI Server • Server Cache

• Calculations Web CatalogPresentationMetadata

The bottom of every Dashboard page has an

“Add to Briefing Book” Link that automatically builds an

electronic briefing book that you carry with you.

Bring along an electronic “Briefing Book” which is a collection of your most important dashboards. Briefing Books are extremely small, and can be delivered daily for

enterprise collaboration.

Oracle Briefing Books“Pack & Go”

BI Publisher High-Fidelity ReportingOne Solution for All Document Needs

Employee Forms

Order Forms

Invoices

Operational Reports

Correspondence

Financial Statements

Checks

Purchase Orders

Labels / Bar Codes

Collateral

Government Forms

BI Publisher Author, Manage & Deliver to any destination

Layout Templates EDI

EFT

Printer

Fax

WebDAV

e-Commerce

Output Destinations

Oracle, SQL Server

PeopleSoft, SAP, Siebel

Java, C++, Pearl, etc

Data Source

WordExcelAcrobat

XSL

Layout Tools

PDF

RTF

HTML

Excel

XML SpyJDeveloperScriptura

Email

Web Services

XML

Multiple document output formats

Report layouts developed and maintained using familiar desktop applications·

Reduced costs and complexity by eliminating custom or third party solutions

BI OfficeBuild Your Own DashboardsInsert BI views

as native Office charts

Insert BI views as refreshable

images

Select from all available views

Combine BI data with Office formating