480 likes | 682 Views
What’s Next for Oracle BI Applications Florian Schouten BI Apps Product Management.
E N D
What’s Next for Oracle BI ApplicationsFlorian SchoutenBI Apps Product Management
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. Safe Harbor Statements
Oracle Analytic Applications Product Family • Transactional BI • Single Source, single function • Part of the Cloud application • Real-time analysis • Configurable • Built on BI Foundation Suite • Available for Fusion Applications • Planned: Taleo, RightNow, Eloqua • BI Applications • Multi-source and cross-functional • Independent Deployment • Warehouse-based analysis • Configurable and customizable • Built on BI Foundation Suite • Available for on premise Oracle Apps • Planned: Connectors to Cloud Apps
Business Analytics in Oracle Fusion Apps Role-Based Analytics Served within the Context of Business Processes Unique Features • Pre-integrated content for lines of business including finance, HCM, supply chain, procurement, projects, sales & marketing • Modular design • Engineered as a single system with single UI Benefits • Enables decisions with relevant insight in context of business process • Combines real time, historic & forward looking data
Oracle BI Applications Product Family Rapid Performance Insight CRM ANALYTICS ERP ANALYTICS ORACLE BUSINESS INTELLIGENCE FOUNDATION AND OTHER OPERATIONAL AND ANALYTIC SOURCES SOURCE ADAPTERS:
Oracle BI Apps: Deeper than Dashboards 1. 2. Pre-Built Analytic Warehouse Certified Application Integration • Business Analytics Warehouse • Over 300 star schemas • Designed for analysis and reporting • Pre-mapped integration • Fusion, EBS, PSFT, SEBL , JDE, IBM • Role-based Security 3. 4. Best Practice Metrics Role-Based Dashboards • Over 10,000 metrics • Additional pre-defined calculations • Based on best practices • Over 500 Dashboards and Pages • Over 3,000 reports • Across Lines of Business
Topics • BI Applications – Recent Releases • Customer Success • Roadmap & Strategic Themes • Q & A
Summary of Release BI Applications 11.1.1.7.1 Price Analytics for EBS • Financials: Fixed Assets, Budgetary Analysis • HR: Time & Labor, Payroll Analysis • Projects: Resource Management, GL reconciliation • CRM: Service Contracts, Price Analytics for EBS • Procurement & Spend :Sourcing • Supply Chain: Costing, Inventory Aging & Cycle Counts Student Information Analytics New Applications & Adapters New Content Enhancements Oracle Data Integrator Oracle GoldenGate • GUI Based Configuration • Functional Setup Tool New TCO Tools New OBIEE 11.1.1.7 New Data Integration
Insight into Student Success & Institutional Performance Oracle Student Information Analytics • New analytics module offering with integrated view of admissions and recruiting, student records and student financials • Summary level KPIs with drill down capabilities to identify exceptions • Cross-functional analysis capabilities with Financial Analytics, Procurement & Spend Analytics, HR Analytics and other BI Apps • Certified for PeopleSoft Campus Solutions 9.0 Bundle#25
Fixed Assets Analysis Complete lifecycle of assets from acquisitions, capitalization to retirements Budgetary Control Analysis Providing insight into expense & revenue budgets including analysis of budgeted amounts, encumbrances, expenditures, funds available, overspending, and recognized revenues. Summary level analysis with drill-down to transactional details. Financial Analytics What’s New in 11.1.1.7.1
HR AnalyticsWhat’s New in 11.1.1.7.1 • Time and Labor Analysis Provide insight into timecard status, timeliness of submission, productive time and estimated cost • Payroll Analysis Analyze pay run transactions including earnings, deductions, taxes and special balances • Headcount Gain & Loss Subject Area Track headcount movement by supervisor hierarchy • Added Leave Accrual to Absence subject area • ETL Adaptor to PeopleSoft Global Payroll
Project AnalyticsWhat’s New in 11.1.1.7.1 • Resource Management analysis Providing visibility into project requirements, trending, utilization, competencies and alignment • Reconciliation of project sub-ledger and General Ledger Assist project accountants in reconciling differences between the two ledgers for cost and revenue transactions. • Perspective based dashboards Optimized Project Analytics user interface that orients the content around specific user perspectives (optional layout) .
Oracle Procurement and Spend Analytics What’s New in 11.1.1.7.1 • New comprehensive Sourcing Business Process that includes negotiations, awards, savings and performance • Pre-built ETL Adapters for EBS and PeopleSoft • New Dashboard
Supply Chain and Order Management Analytics What’s New in 11.1.1.7.1 • Enhanced Inventory Analysis Providing deep insight into Inventory Cycle Count, Inventory Aging, Inventory Expiration/Obsolescence tracking and Inventory balances and transaction details at lot level • Item Cost History Analysis Insight into historical cost of Supply Chain related items
CRM AnalyticsWhat’s New in 11.1.1.7.1 • Price Analytics • EBS added to the list of supported sources, customers now have a ready means to assess pricing performance and arrest revenue and margin leakage • Robust price waterfall analysis possible with the new Waterfall view • Sales Analytics • Indirect Forecasting • Forecasting analysis is now possible when submissions are made up a forecast hierarchy that is outside of the reporting hierarchy • Service Analytics • EBS Support for Service Contracts
Next Generation Data Integration BI Apps 11.1.1.7.1 with Oracle Data Integrator and Golden Gate Oracle Data Integrator provides • In-database E-LT Transformation vs. E-T-L • Best in class performance, scalability, availability • Lightweight deployment for lower TCO • Faster time-to-value through declarative design Oracle Golden Gate option for BI Apps • Reduce load on source system by streaming data continuously into persistent store in the DW • More reliable change data capture and delete support • Enables near real time DW refresh
ODI is SimplerSpeed Project Delivery and Time to Value with ODI • Development Productivity • 40% Efficiency Gains • Environment Setup (ex: BI Apps) • 33-50% Less Complex
BI Apps DW ETL Architecture + SDS Optimized ETL for local SDS Persistent store Optimized for Incremental ETL Captures deletes Generated based on a customers BI Apps deployment
Features and Benefits Golden Gate SDS Option • Near-zero impact of ongoing extraction • No ETL batch load windows required • Full reload without touching the source • Transformations and star loads all local in BI Apps DW schema • Near real time ETL possible • 24/7 deployments Drastically Reduced Impact on Source System Drastically Reduced ETL Runtimes BI Applications with Golden Gate • Ability to change indexes, add views • Perfect source for real-time reporting requirements • Consistent CDC approach regardless of source • Hard deletes in source generate Golden Gate events More Reliable Change Data Capture and Delete Support Dedicated Copy of Source Tables in BI Apps DW
BI Applications Configuration Manager • Administrative UI to manage system config for your BI Applications • Global parameters • Language setup • Currency setup • Extract dates • Ability to export and import configuration from file
New Certifications Since Last Release in May CERTIFIED CERTIFIED CERTIFIED
OBIEE 11.1.1.7 Office Integration Improvements • Export Dashboards &Dashboard Content • Export Report in Native Excel & PowerPoint formats (2003, 2007+) • Export Dashboard or Dashboard page; Dashboard pages appear as separate Excel worksheets • BI Presentation Catalog in Smart View • Smart View 11.1.2.2 replaces the existing Oracle BI Add-in as the primary Office application • Full support for BI dashboard page and report prompts • Enhanced security including single sign-on • BI View Creation in Smart View • Answers View creation from Excel • Save in Excel or as an Answers View • Publish and save in the OBIEE Web Catalog • OBI Data is accessible to other Smart View providers (e.g. Planning, HFM, DM)
Comprehensive Mobile Analytics BI Mobile HD IT Controlled – Managed – Consistent BI Mobile App Designer Purpose Built Analytical Apps • Extend Oracle BI to mobile devices – smartphones, tablets – automatically with no additional development • NewOptimized for touch-gestures, interactions • NewLocation Intelligence • NewOffline support • NewEnhanced containerized security via BI Mobile Security Toolkit • Newself-service capability allowing business users to create and distribute mobile apps • Users build targeted business apps with zero-coding • Stunning, interactive apps in minutes
Topics • BI Applications – Recent Releases • Customer Success • Roadmap & Strategic Themes • Q & A
Key Trends and Product MomentumOracle BI Applications Customer speakers at OpenWorld 2013 from: • Over 500 new logos again in FY2013 • Across all industries and regions • Nearly half of customers license 3 or more BI Applications • Live deployments supporting the largest Oracle ERP deployments in the world • Broad Adoption Continues
Total Economic Impact of Oracle BI Apps Based on Commissioned Study Conducted by Forrester Consulting Validated Benefits • Lower Procurement Spend - 5% lower procurement costs in Year 1 of the study and increased to 7% in Year 2. • Accounts Payable Savings - Savings of more than $1 million per year by the third year of the study • IT and business labor savings - Apps created efficiencies in both the IT and business sides of the organization. • Lower Inventory Working Capital – 15% reduction in inventory for the affected product categories • Increased gross sales and prices- 0.3% increase in average sales price and 0.4% lift in sales at affected parts of the organization 97%ROI with a 20 Months Payback Period* *Composite Organization Three-Year Risk-Adjusted ROI Source: The Total Economic Impact of Oracle BI Applications," commissioned study conducted by Forrester Consulting on behalf of Oracle, October 2012.
New Book! Oracle Business Intelligence Applications: Deliver Value Through Rapid Implementations Available for sale at Amazon and at the Oracle Bookstore during OOW 2013 • Shows how to justify, configure, customize, and extend OBIA • Architecture walkthrough - from dashboard to data source - and best practices for maximizing the powerful features of each application. • Find out about stakeholders critical to project approval and success.
Topics • BI Applications – Recent Releases • Customer Success • Roadmap & Strategic Themes • Q & A
BI Applications Key Strategic Themes • Deliver integrated analytics supporting Oracle’s Cloud Apps • OTBI for Fusion, Taleo, Rightnow, Eloqua • Cloud Adapters to support coexistence and cross-functional analysis • BI Apps DW as a bridge between on premise and cloud sources • Add functional coverage and lower TCO to increase appeal of the suite • Module completion, new source adapters • Expanded value proposition through new analysis types • Essbase for what-if analysis ,Endeca for unstructured analysis, Advanced Analytics for predictive metrics
Cloud Analytics Key Investments • OTBI: Business user self service reporting & analysis • Real time, transaction level detail • Embedded cloud delivery, reflecting customer extensions • Leverages full set of Oracle BI tools for rich capabilities • Available for Fusion, in process for Taleo, Rightnow, Eloqua • Investments: • Increase coverage to expose all attributes and functional areas • Improve task-driven embedded help, documentation and training • Simplify user interface, align terminology and UI concepts with Apps
Oracle Cloud to BI Applications Connector Overview OBIEE • Replicates hosted data from cloud environment to on-premise • Operates identically to all other data sources (via OBIA SDS) • Loads data into OBIA SDS tables to support standard OBIA ETL processing into OBIA Data Warehouse • Planned availability • Fusion Sales, HCM, ERP • RightNow & Taleo • Eloqua OBIA DW ODI FusionSDS EBS Fusion JDE PSFT Customer On-Premise Environment Oracle Cloud
Continued “Traditional” Investments Cost of Ownership Improvements • Content Enhancements • Procurement & Spend for JDE, more Manufacturing, EAM, Student, Talent Management coverage • Data Lineage Analysis • Allows customers and implementers to track lineage from source to target • Content Refresh • User-based research driving dashboard redesign, targeted mobile applications for key roles • ETL Validation Utility • Provides scripts and validation reports comparing source and target data .
And What About Informatica? Thousands of Installed Base Customers • Investment with OBIA and Informatica are secure • Oracle is committed to supporting the Informatica / OBIA installed base and launched BI Applications 7.9.6.4 in January of 2013. • Oracle plans to introduce an Informatica version of 11g in CY 14 • Customer choice: continue on Informatica or migrate to ODI if and when you like
Oracle BI Applications Current Releases and Roadmap • For Applications Unlimited customers • ETL with Informatica • New Manufacturing Analytics • New Enterprise Asset Management Analytics • New SLA support for EBS R12 (patch) • For SAP customers • ETL with ODI • Fin, Proc & Spend, Supply Chain Analytics • For Application Unlimited customers • ETL with ODI • New Student Information Analytics • New Golden Gate option • New content in all major products • Fusion & AU: release alignment • ODI and Informatica : release alignment • New content: Talent Management, PLM Analytics integration, EAM enhancements, Student Analytics enhancements, EVM • New adapters: Procurement & Spend Analytics for JDE, Manufacturing Analytics for JDE, Supply Chain & Order Management Analytics for PeopleSoft • New cloud adapters: Adapters to Fusion CRM, HCM & ERP Cloud Services, Taleo adapter • Cost of Ownership Improvements: Data Lineage, ETL Validation, platform support • Endeca Extensions • BI Applications as Oracle Cloud Service • New content/modules: Continue to fill key content gaps based on customer demand • New cloud adapters: RightNow adapter, Eloqua adapter • Unstructured/big data analytic applications e.g. Customer 360 • Continue user experience redesign by leveraging BI Foundation Suite platform developments incl Mobile App Designer • Additional cost of ownership improvements What’s Next 0-12 month planning cycle Future DirectionsPost 12 month planning cycle BI Apps 7.9.6.4January 2013 BI Apps 7.9.7.2 September 2012 BI Apps 11.1.1.7.1 May 2013
What’s Planned: Higher Value Prebuilt Analytics HR domain as example Workforce Sentiment (unstructured analysis of surveys and reviews) • Endeca Extensions • “Why is attrition in the Midwest spiking? Operational Modeling (domain specific forecasting and performance mgmt) • Essbase Extensions • “How many should I hire to meet projected demand?” Predictive Metrics (smarter KPIs) • Advanced Analytics Extensions • “Will more training increase employee productivity and by how much?” Future HR Analytics (historical analysis on structured metrics) HR Analytics (historical analysis on structured metrics) Today OTBI (real-time operational analysis & reporting) OTBI (real-time operational analysis & reporting)
BI Applications Integration to Endeca • Combine the power of BI Applications with Endeca Discovery to explore unstructured data with structured context • Selected Examples • Overview
Oracle BI Apps Endeca Enhancements Harnessing power of Enterprise Models • Maximize value of customer’s existing investments in OBIA models • 40+ new high-value unstructured fields loaded from source systems into the BI warehouse • 150+ packaged ODI Interfaces create Endeca Data Domains from BI Applications Subject Areas • Sample Endeca Applications to highlight key discovery use cases
Unstructured Additions to Subject Areas • Enterprise Asset Management.Asset - Failure Comments • Financials.GL – Adjustment Reason, AP – Invoice Comments, AR – Invoice Comments / Expense Reason • HCM.Learning Mgmt – Learning Objective / Purpose / Intended Audience, Employee Event – Absence Reason / Requestor Comments, Recruitment – Hire Comments, Time & Labor – Timecard Comments • Manufacturing.Production – Scrap Reason, Work Order – Job Notes • Marketing.Campaign Response – Response Notes / Campaign Notes / Response Survey, Leads – Qualification Comments / Customer Notes / Product Description / Customer Project • Procurement/Spend.Expenses – Justification / Adjustment / Description, Supplier – Negotiation Notes / Disqualify Reason, Purchase Order – Line Item / Header Descriptions • Projects.Project – Project Description /Task Description • Sales.Opportunity – Lead Reject Reason / Won-Lost Reason / Close Reason / Competitor Threat Description • Service.Agreement – Cancel Reason • Supply Chain/Order Mgmt.Customer Return – Return Reason
Customer 360o Big Data Analytic ApplicationProduct Concept Service Interactions Single 360o view of customers across all channels • Hybrid between traditional DW and Big Data using Hadoop-based infrastructure • Customer event model can be extended with other organization specific, relevant sources of customer information (social, web activity, promotion responses, loyalty) • Foundation for more intelligent CRM business processes in marketing, sales, service, pricing & brand management Marketing Responses Social, Web Activity Aggregation • Scalable customer event model • Identity resolution & other enrichment • Real-time query services • Populate DW • Aggregate analysis & historical trends Any Other Customer Data • Real-time customer profiles, alerts and recommendations embedded in CRM, eCommerce APIs
The preceding 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. Safe Harbor Statements