Insert Picture Here Oracle Business Intelligence Applications for
<Insert Picture Here> Oracle Business Intelligence Applications for the E-Business Suite Presenter’s Name Presenter’s Title
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Oracle’s Strategy for Business Intelligence Complete Open Integrated Comprehensive BI/EPM Portfolio Standards-Based Architecture Designed to Work Together More Value Less Complexity More Choice Less Risk More Flexibility Less Cost
Oracle EPM System Industry’s First Integrated EPM System EPM Workspace Performance Management Applications BI Applications Business Intelligence Foundation Fusion Middleware OLTP & ODS Systems Data Warehouse Data Mart OLAP SAP, Oracle, Siebel, People. Soft, Custom Excel XML Business Process
Oracle Business Intelligence Complete, Open, Integrated Data Integration Ad hoc Analysis Interactive Dashboards Essbase Reporting & Publishing Proactive Detection and Alerts Disconnected & Mobile Analytics MS Office & Outlook Integration Common Enterprise Information Model BI Server • Integrated Security, User Management, Personalization • Multidimensional Calculation and Integration Engine • Intelligent Request Generation and Optimized Data Access Services OLTP & ODS Systems Data Warehouse Data Mart Essbase SAP, Oracle People. Soft, Siebel, Custom Apps Files Excel XML Business Process
Unified BI Foundation Integrated BI Tools; Common Enterprise Information Model Ad hoc Interactive Reporting & Proactive Smart. View Analysis Dashboards Publishing Detection MS Office and Alerts Common Enterprise Information Model BI Server Essbase t Role-based interactive dashboards t Proactive alerts t MS Office and Excel integration t Simplified logical view of data t Powerful query processing t Speed-of-thought analytics t Modeling, Planning, Allocations t One-day, throw-away applications BI Apps or any DW or OLTP schema Native RDBMS t Access Enterprise data sources Data Warehouse "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"
Common Delivery Layer Pervasive Information Access; Single Sign-On EPM WORKSPACE Desktop Web Search Performance Management Applications Alerts Office Mobile BIBIApplications Business Intelligence Foundation Fusion Middleware OLTP & ODS Systems Data Warehouse Data Mart OLAP SAP, Oracle, Siebel, People. Soft, Custom Excel XML Business Process
Unified Microsoft Office Interface Smart View for Office • Ad hoc Reporting • Stylized Output • Formats • Tables • Charts • Formulae • Data Entry and Apps Processing • Word and PPT • New OBIEE as Smart View source
Unified Desktop Gadgets Oracle Smart Space • New OBIEE and BI Publisher Integration • Hyperion Reporting and Analysis Support • Enhanced Client UI and Collaborator • New Gadgets • Essbase Calculation • Essbase Data Load • Global Gadgets • Pluggable Services Architecture
Comprehensive BI Applications EPM Workspace Performance Management Applications BI APPLICATIONS Sales Service Contact Center Marketing Procurement & Spend Supply Chain & Order Mgmt Finance HR Business Intelligence Foundation Fusion Middleware OLTP & ODS Systems Data Warehouse Data Mart OLAP SAP, Oracle, Siebel, People. Soft, Custom Excel XML Business Process
OBI EE Plus vs BI Applications Oracle Business Intelligence Enterprise Edition Plus Oracle Business Intelligence Applications – Prebuilt Metadata
Oracle BI Applications Complete, Pre-built, Best Practice Analytics Auto Comms & Media Complex Mfg Consumer Sector Energy Financial Services High Tech Insurance & Health Life Sciences Public Sector Travel & Trans Sales Service & Contact Center Marketing Procurement & Spend Supply Chain & Order Management Financials Human Resources Pipeline Analysis Service Effectiveness Campaign Effectiveness Direct / Indirect Spend Revenue and Backlog General Ledger Employee Productivity Forecast Accuracy Customer Satisfaction Customer Insight Buyer Productivity Inventory Accounts Receivable Compensation Sales Team Effectiveness Resolution Rates Product Propensity Off Contract Purchases Fulfillment Status Accounts Payable Compliance Reporting Up-sell/ Cross-sell Service Rep Efficiency Loyalty & Attrition Supplier Performance Customer Status Cash Flow Workforce Profile Cycle Times Service Cost Market Basket Analysis Purchase Cycle Time Order Cycle Time Profitability Retention Analysis Lead Conversion Churn & Service Trends Campaign ROI Employee Expenses BOM Analysis Expense Management Return on Human Capital and Other Operational & Analytic Sources Source adapters: Oracle BI Suite Enterprise Edition Plus
A Problem with Recognizing Revenue … Starting in Order Management Analytics Overview
…Ends in Placing a Rush Order with a Strategic Supplier
Integration Becoming Imperative Clients consider Analytics integral to OLTP systems The Next Level of Performance Optimization THE #1 BI VENDOR CRITERIA “Ability to Integrate with Existing Applications” “Business intelligence (BI) is moving into the context of the business process, not just to make users’ information experience more effective, but also to allow for business process optimization. ” Source: Software Macro-Trends: Reshaping Enterprise Software - Sep 2005 Source: Information. Week
More than just dashboards and reports Value of BI Apps lies under the surface DASHBOARDS • “Visible” “PLUMBING” • Data warehouse design • “Under the Surface” • Significant time, resources and expertise required • Data mapping & transformation from multiple applications • Analytic models, KPIs, metrics • Much more…
Pre-Built, Pre-Mapped, Pre-Packaged Insights Example: Financial Analytics 1 2 Pre-built warehouse with more than 16 star-schemas designed for analysis and reporting on Financial Analytics Pre-built ETL to extract data from hundreds of operational tables and load it into the DW, sourced from Oracle EBS, People. Soft Enterprise, SAP R/3, and other sources. 3 Pre-mapped metadata, including embedded best practice calculations and metrics for Financial, Executives & other Business Users. • Presentation Layer • Logical Business Model • Physical Sources 4 A “best practice” library of over 360 pre-built metrics, Intelligent Dashboards, 200+ Reports and alerts for CFO, Finance Controller, Financial Analyst, AR/AP Managers and Executives
BI Applications - Business Content Over 5, 000 assets including industry applications Application Dashboards Dashboard Pages Reports Metrics Sales 5 23 134 560 Marketing 5 27 124 501 Service 8 15 102 465 Contact Center 5 17 72 448 Finance 4 30 205 360 HR 4 16 76 138 Supply Chain & Order Mgmt. 2 18 157 388 Procurement & Spend 2 14 103 161 35 160 973 3021 Total
Even more metric value under the surface Metrics used in Reports & Dashboa rds Not all measures in presentation layer used in reports & dashboards Metrics in Subject Areas Subset of logical measures are exposed in presentation layer Metrics in Logical Layer Aggregations, time series calculations and derived calculated measures extend physical measures Metrics in Physical Warehou se Measures from physical columns in data warehouse
Selected Key Entities of Business Analytics Warehouse Sales § Opportunities § Quotes § Pipeline Order Management § Sales Order Lines § Sales Schedule Lines § Bookings § Pick Lines § Billings § Backlogs Marketing § Campaigns § Responses § Marketing Costs Supply Chain § Purchase Order Lines § Purchase Requisition Lines § Purchase Order Receipts § Inventory Balance § Inventory Transactions Finance § Receivables § Payables § General Ledger § COGS Call Center § ACD Events § Rep Activities § Contact-Rep Snapshot § Targets and Benchmark § IVR Navigation History Service § Service Requests § Activities § Agreements Workforce § Compensation § Employee Profile § Employee Events Pharma § Prescriptions § Syndicated Market Data Financials § Financial Assets § Insurance Claims Public Sector § Benefits § Cases § Incidents § Leads Conformed Dimensions § § § § Customer Products Suppliers Internal Organizations Customer Locations Customer Contacts GL Accounts Employee Sales Reps Service Reps Partners Campaign Offers Cost Centers Profit Centers Modular DW Data Warehouse Data Model includes: ~350 Fact Tables ~550 Dimension Tables ~5, 200 prebuilt Metrics (2, 500+ are derived metrics) ~15, 000 Data Elements
Align Actions with Best Practices Guided & Conditional Navigation Helps Novice Users GUIDED NAVIGATION • Enables users to quickly navigate a standard path of analytical discovery specific to their function and role • Enhances usability and lowers learning curve for new users CONDITIONAL NAVIGATION • Appears only when conditions are met and alerts users to potential out of ordinary conditions that require attention • Guides users to next logical step of analytical discovery Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 22
Actionable Insight - Analytic Workflows Business Objectives / Issues Maximize Cash Flow Is DSO on target? Gain Insights Is Overdue Balances trending up? Are Payment Terms in compliance? How long is the underlying Overdue Balance pending? What is the aging of Due Balances? Who are the Customers and Collectors? Drill to Due Balances by Region Drill to Overdue Invoice Detail Take Action Target collection efforts to reduce overdue balances Is DPO on target? • Business Function: Receivables • Role: Director, Credits & Collections • Objectives: • 1) Maximize Cash Flow • 2) Control Risk of Receivables Portfolio
Example: Analytic Workflows Business Objectives / Issues Maximize Cash Flow Is DSO on target? How long is the underlying Overdue Balance pending? Drill to Overdue Invoice Detail Take Action Target collection efforts to reduce overdue balances tail Who are the Customers? o De Gain Insights Drill t Is Overdue Balances trending up?
Oracle BI Applications Architecture Dashboards by Role Oracle BI Presentation Services § § § Role Based Dashboards Analytic Workflow Guided Navigation Security / Visibility Alerts & Proactive Delivery Oracle BI Server § § Logical to Physical Abstraction Layer Calculations and Metrics Definition Visibility & Personalization Dynamic SQL Generation § § Abstracted Data Model Conformed Dimensions Heterogeneous Database support Database specific indexing § § § Highly Parallel Multistage and Customizable Deployment Modularity Logical Model / Subject Areas Physical Map Metadata Metrics / KPIs Data Warehouse / Data Model Direct Access to Source Data Load Process Staging Area ETL DAC Administration Reports, Analysis / Analytic Workflows Extraction Process Oracle SAP R/3 Siebel PSFT EDW Federated Data Sources Other
Application Integration Strategy BI Apps with Performance Management Apps Interactive Dashboards Reporting & Publishing & Spend Procure HR & Order Mgmt Supply Chain Marketing Service Sales BI Applications Proactive Detection and Alerts Financials Ad hoc Analysis What If Smart. View MS Office Performance Management Apps HFM Planning FDM Essbase Common Enterprise Information Model OLTP Data BI Server Native Access (Plans, Consolidated Results) BI Applications DW (BAW) OLTP & ODS Systems Data Movement 1) Plans 2) Consolidated results Data Warehouse Data Mart SAP, Oracle People. Soft, Siebel, Custom Apps Files Excel XML Business Process
Oracle BI Apps 7. 9. 5 Now Available • Unified multi-source data model • Enhanced user experience • Data Warehouse Administration Console • Expanded deployment options • Support for Siebel CRM 6. x, 7. 5. x, 7. 7. x, 7. 8. x, 8. 0. x • Support for Oracle EBS ERP 11 i 8, 11 i 9, 11 i 10 and R 12 • Support for PSFT Financials 8. 4, 8. 8, 8. 9, 9. 0 and HR 8. 8, 8. 9, 9. 0 • Tightly Integrated with Oracle Applications • Full localization • Translation to 28 languages • Certified on Informatica Power. Center 8. 1. 1 SP 4
Unrivaled Integration with Oracle EBS Extend EBS Value, Lower TCO Action Links – “Insight to Action” Integrated Security Seamless navigation from analytical information to transactional detail One login. Right content for each user. Data Security User Security Object Security Integrated Workflow Integrated with Planning and EPMS Intelligence-driven business processes View performance “in-context” with budgets and plans BPEL, ESB Oracle BI
Tight Integration with E-Business Suite Action Links navigate from analytical to operational • Action Links • Seamless navigation from analytical information to transactional detail while maintaining context • Works with Oracle EBS, Siebel CRM, People. Soft Enterprise
Flexfield and Value Set Integration • Key Flexfields (KFF) • Pre-packaged mappings to extract Key Flexfield data • Mappings are flexible to handle configuration performed on these flexfields • Out-of-the-box support to a number of KFF’s (refer next slide) • Descriptive Flexfields (DFF) • Support by extension of the data warehouse by adding requisite columns • Value Set Hierarchy • Extract hierarchical relationships of Value Sets
User Single Sign-On with Oracle EBS Security 3 navigate to 2 store ICX session cookie in browser 5 establish connection with Oracle EBS Web user Browser Oracle EBS Oracle BI 1 log in once 6 drill back to Oracle EBS via Action Links 4 validate session via the ICX cookie
Object Security What parts of the application can you see? • Business Logic Object Security Presentation Layer Semantic Object Layer Physical Layer Controls access to Subject Areas, Tables and Columns • Web Object Security Limits access to Dashboards, Reports and Web Folders • Query Blocking • Specified combinations of columns in queries can be blocked from running and the user is notified of the illegal query
Data Security for EBS What data can you see? • Multi-Org data access support with Oracle E-Business Suite applications: • Operating Unit • Inventory Organization • Business Group • Company Org • Ledger/ Set of Books • Position Data Security
BI Integrated with EBS
End Result: Role Based Dashboard Object Security: Dashboard Roles Object Security: Reports Data Security: Suppliers based on user OU
Oracle BI Applications Use together to provide an Enterprise Analytic View Sales Marketing Service & Contact Center Procurement & Spend Supply Chain & Order Management Financials Human Resources Industry Apps More Prospect to Customer Order to Cash Procure to Pay Demand Chain to Supply Chain … Analyze End-to-End Business Processes Even Across Heterogeneous Sources 3
Rapid Deployments Oracle BI Applications 6 weeks 9 weeks 10 weeks 12 weeks 3 months 3½ months 100 days
“Pre-built, yet Customizable…” Teva Pharmaceuticals is the leading generic pharmaceutical company. ($10 B+) Teva USA products are marketed to chains, wholesalers, distributors, hospitals, managed care entities, and government agencies. Before 1. Fragmented systems and 2. 3. 4. 5. processes Inability to analyze sales data from direct and indirect channels No “Single Source of Truth”, crossfunctional analysis was not possible End users were unable to access information critical to business and decision making without going to IT Individual queries took almost an hour to run After § Business Users can now access sales § § information in a “self service” fashion, reports run in seconds 50 critical EBS flexfields now part of overall BI views Teva USA now has “a standard set of metrics” End users can securely drill to contract order info from BI Dashboards Supply Chain Analytics for Process Manufacturing is next to be implemented Leveraging the out of the box ETL maps and OBI Apps data model, Teva was able to create a custom dashboard for Chargeback Analytics, which integrated with the pre-built Order Management and Fulfillment Analytics offerings from Oracle
HR and Financial Analytics with EBS… GL, Profitability, HR and Compliance Analytics Wyndham Worldwide is one of the world’s largest hospitality companies, with 6500+ hotels and over 550, 000 hotel rooms worldwide. Wyndham Worldwide has over 33000 employees Before § Disparate BI and Reporting § § Technology Investments Difficulties with integrating and accessing multiple data sources Lack of easily utilized ad-hoc and analytical reporting capabilities Dependency on IT for report development/lack of self-service reporting Could not get needed information in a timely fashion After § OBI EE+ and the Oracle BI Applications as Wyndham’s BI Architecture/Platform § Purchased OBI EE and BI Apps in Feb 2008 after pilot, Financial Operational Reporting live March 2008, HR live in June 2008 § All Business Units using OBI EE platform for Operational Reporting § Next steps include additional HR and Accounts Payable Analytics
Sales and Operations Insight 4 BI Applications, 120 Users, 75 Days, 7 FTE’s Regal Beloit Corporation is the world’s largest manufacturer of electrical and mechanical motion control and power generation products. With revenue of $2 B+, Regal Beloit has worldwide manufacturing, sales, and service operations. Before § Poor understanding of business § § performance across functions, esp. Sales, Orders, AR, Inventory Lack of visibility: Plan + Forecast + Actual and variances in one place Need to see performance along any dimension of the business – BU, Product/SKU, Geo, Customer Need to integrate data from multiple sources Acquisitions – adding new apps; need to integrate into view within 90 days After § One BI system for the entire company § Data sourced from EBS, ASCP, legacy and other systems § Implementation took 75 days versus estimated 1 year+ for custom build § 81 role specific business views based on same data, versus previous individual reports § Immediate, significant savings from visibility into order status and worldwide finished goods inventory
BI Apps on EBS and Cognos in 14 Weeks Financials, Procurement and Spend Analytics…. Audatex, a Solera company, is the only global provider of claims solutions, delivering a comprehensive, integrated suite of applications for claims processing, estimating, shop and yard management, and claims analytics in 51 countries and to over 50, 000 customers Before 1. Expensive, error prone, time consuming manual process to generate financial statements and get financial data 2. Users had to combine data from EBS, Cognos Consolidations, Oracle Financial Statement Generator, Microsoft Access and Excel 3. Departments needed to create individual data marts 4. No single source of truth for financial data After 1. Oracle Financial and Procurement & 2. 3. 4. 5. Spend Analytics provide “single source of financial data” Leveraged pre-built EBS security at cost center, line of business, company, and chart of accounts. “No more manual financial statements” “Financial Data in near-real time” as biggest business benefit. Implemented Financial Analytics in 10 weeks, P&S in just 4.
Summary – Oracle BI Applications • Most Complete • Fast time-to-value and lower TCO • Enterprise-wide, cross-value chain pre-built analytics • Embedded best practices by industry, function, and role • Most Open • Built on open, leading BI platform • Flexible, extensible • Access Oracle and Non-Oracle data sources and applications • Most Integrated • Pre-Integrated with Oracle EBS • Leverage EBS Security, SSO, Flexfields • Add insight to existing and new EBS implementations
- Slides: 41