Transcript OBIEE sent. ppt - Greater Cincinnati Oracle Users Group

Creating a Single
Enterprise View of Your
Organization Through BI –
Regardless of Data Source
Rob Tenhundfeld
Business Intelligence Solution Specialist
Let’s start with a (not so)
simple question….
“How is my new brand doing?”
More specifically, “How much have I sold,
how is it impacting my support operations
and what percentage of my total revenue is
it generating?”
BI Challenges Today
•
•
•
•
•
•
Siloed
Fragmented
Inconsistent
Report-centric
Restricted
Unintuitive
Hasn’t the promise of BI
been there for the past
decade?
The Evolving Role of BI
From:
To:
Analysts
Pervasive use
Historical data
Real-time, predictive data
Fragmented view
Unified, enterprise view
Reporting results
Insight-driven business
process optimization
Unified infrastructure &
prebuilt analytic solutions
Analytic tools
Separate BI, CPM
Integrated Performance Mgmt
Oracle Business Intelligence
Comprehensive, Integrated, Best-of-Breed BI Solutions
Oracle
BI Applications
Enterprise-wide, Industry-Specific
Analytic Applications
Oracle
BI Suite
Best-of-Breed, Next Generation BI
platform
Oracle
Data Warehousing
Complete data warehousing
solution
Oracle is the Worldwide Leader
in Business Analytics
Oracle
BI Applications
Oracle
BI Suite
Oracle
Data Warehousing
Sources: IDC and Gartner
#1 in Analytic Applications
- IDC
“One of the most comprehensive and
innovative BI platforms…”
Leader’s Quadrant- Gartner
#1 in DW Tools
- IDC
Oracle’s Answer To Silo BI:
Oracle BI Enterprise Edition
Oracle BI Suite Enterprise Edition
• Foundation for BI in Fusion
• Based on technology from Siebel, Hyperion and Oracle
• Siebel was fastest growing BI vendor, averaging 50%+ annual
growth over the last 5 years
• Comprehensive, next-generation BI platform
• Pervasive intelligence for all users
• Integrated and Hot-Pluggable architecture
“With the acquisition of Siebel, Oracle find themselves as the owners of
one of the most exciting BI solutions available at present.”
– Bloor Research
Oracle BI Suite Enterprise Edition
Interactive
Dashboards
Ad hoc
Analysis
Proactive
Detection
and Alerts
Microsoft
Office
Reporting
&
Publishing
Common Enterprise Information Model
Oracle BI Server
OLTP & ODS
Systems
Data
Warehouse
Data Mart
SAP, Oracle
PeopleSoft, Siebel,
Custom Apps
Files
Excel
XML
Business
Process
Advantages:
Consolidate and
standardize BI tools
Unified BI metadata
and infrastructure
Seamless BI user
experience
Primary BI EE End User Options
Complete Range of Insight Delivery Capabilities
Oracle
Interactive
Dashboards
• Guided experience leads user from insight to action
• Intuitive and interactive dashboards/scorecards
• Personalized, function-specific and role-based
Oracle
Answers
• Ad-hoc data exploration
• True business user self sufficiency
• Create, modify and author analysis, pivots and
dashboards
Oracle
Delivers
• Dynamic problem/opportunity detection and
notification
• Automated analytic workflows and processes
• Tailored delivery for wide range of mobile
devices
Oracle
Reporting &
Publishing
• Schedule & distribute enterprise-class reports
• Sophisticate “pixel-perfect” report layout
controls
Powerful Insight Across Data Sources
Simplify analysis of distributed data
• Point and click access to
information spanning multiple
physical sources
“Show me sales through
today for my highest value
customers. Assure sufficient
inventory to fulfill orders.”
• Users interact with simplified model
• Shielded from complex physical data
• Complete and timely information
Oracle BI Server
Intelligent Request Generation
• Real-time and historical data
• Enables high value crossdepartmental analysis
Data
Warehouse
ODS /
Operational
Inventory
System
Historical
Sales (through
yesterday)
Today’s
Sales
Current
Inventory
OBIEE Multi-Source
BI
Oracle BI EE Architecture
Web Server
(IIS, Tomcat, Websphere, iPlanet)
Oracle BI Web
Oracle Interactive
Dashboards
Web
Catalog
Service
Agent Execution Logic
Device Adaptive Content
Oracle Answers
User Profiling, Security and Session Mngmt
Scheduling/Event Services
TCP/IP
(SSL)
XML, HTML,
XLS, PDF, TXT
over
HTTP/HTTPS
TCP/IP (SSL)
SOAP Web Services, XML and URL Interface
Oracle Delivers Server
Web Browser
SAW Bridge (J2EE/ISAPI)
XML
Framework
ODBC over TCP/IP (SSL)
Query Govern.
Security Services
Cache
Services
Navigator
Multi-Pass /
Sub-Request Logic
Fragmentation
Optimization
Aggregate
Navigator
DB Authentication
Optimized Query Rewrites
Execution Engine
Data Source Adapters
ODBC, CLI, OCI, XML, MDX
Analytical and Operational Data Sources
Metadata Interchange
Session Management
System / Perf Monitoring
Load Balancer
Logical Request Generation
Custom Authenticator
Oracle BI Administration
Logical SQL ODBC/JDBC (Logical Business Model)
Intelligent Request Generation
Externalized
Authentication
LDAP
External Applications and Portals
Cache Services (Web) & Connection Mngmt
Oracle BI Server
Oracle BI
Cluster Controller
HTML, SOAP
over
HTTP/HTTPS
Javascript
for Usability & Interactivity
Metadata Management Services
Multi-User Development Services
Metadata Documentation Services
Server Management Services
Oracle BI EE Architecture
Web Server
(IIS, Tomcat, Websphere, iPlanet)
Oracle BI Web
Oracle Interactive
Dashboards
Web
Catalog
Service
Agent Execution Logic
Device Adaptive Content
Oracle Answers
User Profiling, Security and Session Mngmt
Scheduling/Event Services
TCP/IP
(SSL)
XML, HTML,
XLS, PDF, TXT
over
HTTP/HTTPS
TCP/IP (SSL)
SOAP Web Services, XML and URL Interface
Oracle Delivers Server
Web Browser
SAW Bridge (J2EE/ISAPI)
XML
Framework
ODBC over TCP/IP (SSL)
Query Government
Security Services
Cache
Services
Navigator
Multi-Pass /
Sub-Request Logic
Fragmentation
Optimization
Aggregate
Navigator
DB Authentication
Optimized Query Rewrites
Execution Engine
Data Source Adapters
ODBC, CLI, OCI, XML, MDX
Analytical and Operational Data Sources
Metadata Interchange
Session Management
System / Perf Monitoring
Load Balancer
Logical Request Generation
Custom Authenticator
Oracle BI Administration
Logical SQL ODBC/JDBC (Logical Business Model)
Intelligent Request Generation
Externalized
Authentication
LDAP
External Applications and Portals
Cache Services (Web) & Connection Mngmt
Oracle BI Server
Oracle BI
Cluster Controller
HTML, SOAP
over
HTTP/HTTPS
Javascript
for Usability & Interactivity
Metadata Management Services
Multi-User Development Services
Metadata Documentation Services
Server Management Services
Enterprise Business Model Administration
DB2
Supply
Chain
DM
Teradata
OLAP
Oracle
ERP.
Physical Layer – “Intelligent
Request Generation”
Reads in system catalog
XML Data
Source
SQL Server
Acxiom
Multiple sources
Optimized SQL generation
Regardless of Schema
Function ship to appropriate data
sources/Compensation
Siebel
Operational
Enterprise Business Model Administration
Business 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 EE Architecture
Web Server
(IIS, Tomcat, Websphere, iPlanet)
Oracle BI Web
Oracle Interactive
Dashboards
Web
Catalog
Service
Agent Execution Logic
Device Adaptive Content
Oracle Answers
User Profiling, Security and Session Mngmt
Scheduling/Event Services
TCP/IP
(SSL)
XML, HTML,
XLS, PDF, TXT
over
HTTP/HTTPS
TCP/IP (SSL)
SOAP Web Services, XML and URL Interface
Oracle Delivers Server
Web Browser
SAW Bridge (J2EE/ISAPI)
XML
Framework
ODBC over TCP/IP (SSL)
Query Govern.
Security Services
Cache
Services
Navigator
Multi-Pass /
Sub-Request Logic
Fragmentation
Optimization
Aggregate
Navigator
DB Authentication
Optimized Query Rewrites
Execution Engine
Data Source Adapters
ODBC, CLI, OCI, XML, MDX
Analytical and Operational Data Sources
Metadata Interchange
Session Management
System / Perf Monitoring
Load Balancer
Logical Request Generation
Custom Authenticator
Oracle BI Administration
Logical SQL ODBC/JDBC (Logical Business Model)
Intelligent Request Generation
Externalized
Authentication
LDAP
External Applications and Portals
Cache Services (Web) & Connection Mngmt
Oracle BI Server
Oracle BI
Cluster Controller
HTML, SOAP
over
HTTP/HTTPS
Javascript
for Usability & Interactivity
Metadata Management Services
Multi-User Development Services
Metadata Documentation Services
Server Management Services
Oracle BI Server
Common Enterprise Information Model
Simplified Logical Model
The Oracle BI server presents as a
logically modeled database enabling the
Common Enterprise Information Model.
This provides powerful calculation,
computation and federation capabilities to
3rd party tools as well as our own.
A Day in the Life of a Query
A Day in the Life of a Query
A logical request comes in asking for




Brand,
Closed Revenue (GL)
Service Requests (Call Center)
Share of Revenue (Derivation)
A Day in the Life of a Query
Oracle BI Server Cache
The Server will check to see if this request
can be fulfilled via a prior request using
Server Cache.
This is an on-demand intelligent shareable
and secure cache that can support:
Subsets, Aggregations and Derivations
A Day in the Life of a Query
Navigator
If it is the request is cannot be fulfilled by
cache then the server will intelligently
process the request
A Day in the Life of a Query
Multi-Pass/Sub-Request Logic
Does this analysis require sophisticated
analysis such as an OLAP calculation?
[Revenue Share]
The Server will determine the best
possible way to provide this
calculation/computation
A Day in the Life of a Query
Fragmentation Optimization
Does this request span across partitions
or silos of data?
[Closed Revenue and Service Requests]
The server will determine based on the
request if it should navigate to both or only
one. It will automatically resolve fan traps.
A Day in the Life of a Query
Aggregate Navigator
Is there an aggregate that can better
satisfy this request versus hitting the
detail?
{Brand Summary Table}
The Server will apply approprate summary
redirection to provide the quickest
response.
A Day in the Life of a Query
Optimized Query Rewrites
What can be function-shipped down to the
database versus performed
/supplemented by the computation
capabilities of the Server.
The server will provide a consistent set of
functionality to the user regardless of
underlying datasource.
Oracle BI Server
Exploiting Native Database Functionality
Oracle BI Server
Optimized Native SQL Rewrites
select distinct D1.c2 as c1,
Rank() OVER ( ORDER BY D1.c1 DESC ) as c2
from
(select sum(T677."ActlExtnd") as c1,
T699."District" as c2
from
"d1_customer" T699,
"d1_orders" T677
where ( T677."repkey" = T699."SalesRep" )
group by T699."District") D1
order by 1
select D1.c2 as c1, D1.c1 as c4
from
(select sum(T1397."ActlExtnd") as c1,
T1384."District" as c2
from
"D1_customer" T1384,
"D1_orders" T1397
where ( T1384."repkey" = T1397."SalesRep" )
group by T1384."District"
) D1
[Rank Calculation Performed on Oracle BI Server
To Compensate for the Limitations of MS SQL Server]
A Day in the Life of a Query
Cache Services
The request once executed will now be
available to other users as a cache entry.
Oracle BI Server
System Services
System Services
Clustering:
Add stacks as needed in a share nothing
clustered environment.
Session Management and Governance:
Query throttling via connection pools and
authorization
Security Services:
Integration with OID, LDAP with
sophisticated data driven personalization
mechanisms.
D E M O N S T R A T I O N
Oracle BI Suite
Enterprise Edition
Drive Pervasive Intelligence
All Departments, Users, and Processes
Unsurpassed Usability
Anywhere, Anytime
 Rich, interactive Web interface
 Guided analytics
 Seamless user experience
 Robust personalization
 Simplified business model
 Abstraction from physical sources
 Complex calculations made easy
 Dashboards, ad hoc, alerts, reports
 Any device
 Full mobile disconnected analytics
 Integrated with business processes
 Embedded analytics
 Portal integration
 Extranet
Leverage Prebuilt Oracle BI Applications
Built in Best Practices Across Functions and Industries
Auto
Comms. Complex Consumer
& Media
Sector
Mfg.
Energy
Financial
Services
High
Tech
Insurance
Life
& Health Sciences
Public
Sector
Travel
& Trans
Sales
Analytics
Service &
Contact Center
Analytics
Marketing
Analytics
Financial
Analytics
Supply Chain
Analytics
Workforce
Analytics
Pipeline
Analysis
Churn
Propensity
Campaign
Scorecard
Receivables /
Payables Analysis
Supplier
Performance
Employee
Productivity
Triangulated
Forecasting
Customer
Satisfaction
Response
Rates
Customer
Profitability
Inventory
Analysis
Compensation
Analysis
Sales Team
Effectiveness
Resolution
Rates
Product
Propensity
Product
Profitability
Procurement
Cycle Times
Compliance
Reporting
Up-sell /
Cross-sell
Service Rep
Effectiveness
Loyalty and
Attrition
Regulatory
Compliance
Inventory
Availability
Workforce
Profile
Discounting
Analysis
Service Cost
Analysis
Market Basket
Analysis
Expense
Management
Employee
Expenses
Turnover
Trends
Lead
Conversion
Service
Trends
Campaign ROI
Cash Flow
Analysis
BOM Analysis
Return on
Human Capital
Other Operational
& Analytic Sources
Prebuilt adapters:
Oracle BI Suite Enterprise Edition
Leverage Prebuilt Oracle BI Applications
Changing the Economics of BI
Build from Scratch
with Traditional BI Tools
Oracle
BI Applications
With BI Suite EE you can:
1. Build custom BI apps
2. Buy Oracle BI Apps
3. Do a mix of both
Training &
Roll-out
Define Metrics
& Dashboards
 Faster deployment
 Lower TCO
 Assured business value
DW Design
Back-end
ETL and
Mapping
Training & Rollout
Specific Metrics
& Dashboards
DW Design Mod
Pre-built ETL
Tailoring
Quarters or Years
Weeks or months
Role-based dashboards and alerts
Thousands of pre-defined metrics
Prebuilt DW design
Adaptable to your enterprise DW
Prebuilt ETL Business Adapters for Siebel,
Oracle, PeopleSoft, SAP, others
Leverage Prebuilt Oracle BI Applications
Proven Rapid Time To Value
Deployed to 800 users in under 90 days
Analytics for sales-oriented contact center
Live in 120 days
Sales Analytics
Deployed to 3000+ users in 3½ months
Sales Analytics
4 months from decision to live for 1200 users
Pharma Analytics
“
Live in 100 days, 6500 users
Sales and Marketing Analytics
Having had experience of Siebel Business Analytics,
I can vouch that it can be deployed as rapidly as they
claim...It is a product that really delivers.
Maximize the Value of IT Investments
“Hot Pluggable” BI Adapts to Your Environment
Integrate with portals & apps
Access with other tools
XML, SOAP API, JSR168 support
Open SQL query interface
Portals
Other
Applications
MS Office
Other
BI Tools
Leverage existing
security
Oracle, MSFT AD,
Sun iPlanet, Novell
Others …
Oracle BI Server
Oracle
Microsoft
SQL
Server
Teradata
IBM DB2
Essbase
Data
Warehouse
Data Marts
MultiDimensional
SAP BW
Leverage any Data Source
Optimized native SQL; Source-specific function shipping
XML
Excel
Flat Files
Scalable and Sustainable BI Process
Reduce IT backlog while increasing self-sufficiency
Provide greater self-sufficiency at each level and enable each
member of the process to do what they do best
Business Users
• Consume shared dashboards, reports, alerts
• Easily build / modify their own analysis
Business Analysts
& Operations
IT
• Build shared dashboards, alerts, workflow
processes for their user community
• Focus on data infrastructure, metadata
model, tuning performance, security
Oracle BI Suite Enterprise Edition
Summary of Key Benefits / Differentiators
1.
2.
3.
4.
5.
Comprehensive, integrated BI suite
Enterprise information model & consistent metrics
Intelligence spanning multiple sources
Designed for broad, pervasive use
Library of prebuilt Oracle BI Applications
•
6.
7.
8.
9.
Provide lower TCO, faster deployment, more assured value
“Hot Pluggable” to maximize value of current systems
Scalable and flexible BI architecture
Pre-integrated Oracle stack lowers cost & complexity
Scalable and sustainable BI process
Industry Leaders Adopting
Oracle BI Enterprise Edition
Aerospace & Defense
5 of the top 6
Commercial Banks
4 of the top 5
Pharmaceutical
8 of the top 9
Computer Office Equip
6 of the top 9
Diversified Financials
3 of the top 4
Railroad
3 of the top 4
Medical Products & Equip 3 of the top 6
Telecommunications
5 of the top 6
Securities
3 of the top 6
Network & Comms Equip
2 of the top 4
Life & Health Insurance
3 of the top 5
OBIEE Features vs. 11g DB
OBIEE Provides Tools for the Roadmap to Best Practice BI/DW
OBIEE
• Time and Value Based
Partitions for BI
Oracle Database 11g
• Time, Value, Interval Based
Partitioning for Enterprise
•
Aggregate awareness
through defined views
in data sources
• Transparent, highly scaled
aggregate awareness for
enterprise apps (OLAP)
•
Single, secured logical
definition for BI usage
• Single, secured physical
definition of enterprise