Analytics for Fusion Applications: Overview and Strategy

2. Analytics for Fusion Applications: Overview and Strategy Zhu YaoOracle University Principal Instructor

3. 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.

4. Program Agenda • Overview of Analytics for Fusion Applications • Usage Patterns and UI Integrations • Roadmap Update • Customer Deployment Scenarios • Q & A

5. ANALYTICS & BI CIO TECHNICAL PRIORITY FOR2012 BUSINESS ANALYTICS SOFTWARE MARKET LEADER Source: Gartner Executive Programs, "Amplifying the Enterprise: The 2012 CIO Agenda," January 2012 Source: IDC

6. Today’s Typical BI Landscape Hard to Maintain, Duplication and Inconsistency of Tooling Disparate User Interfaces Independent Silos of Information, No Global Visibility Finance Procure HCM SCM Project CRM Discoverer BO DBI QlikTech Cognos OSA Non-Oracle Apps Existing Apps Unstructured Data External Data

7. Challenges Faced by Users Growing Fragmented Data, Decisions Without Insight • Too many decisions are based on inaccurate / incomplete data • Difficult identifying operational inefficiencies • Demand for timely and accurate facts • Growing volumes of organizational data is under used

8. Oracle Business Analytics Hardware And Software Engineered To Work Together Analytic Applications BI Foundation Strategy Management Planning &Forecasting CRM Analytics Industry Analytics ERP Analytics Reporting &Publishing OfficeIntegration Scorecards Detect& Alert Query &Analysis Interactive Dashboards Mobile Search Embedded Financial Close & Reporting Profitability Management Data Mgmt Data Integration Content Management Database BI Server Essbase Dimension Management Predictive Analytics Servers/ Storage Virtualization Exalytics In-Memory Engineered System Exadata Engineered System Storage & Tape Common Enterprise Information Model

9. Embedded BI Surmounts the Challenges of Traditional BI THE OLD WAY THE NEW WAY Disconnected. Open Ended. Embedded. Closed Loop.

10. Better Analytics in Fusion Applications

11. BI in Fusion Applications Solution Components • Real-time, self-service reporting • Historical and complex analysis with a data warehouse • Domain-specific, specialized analytics Key Features • Consistent user experience: Identical visualization components used throughout • Common semantic model: Unified definition of key entities • Tight integration with Fusion Applications • Pervasive embedded analytics, role-based dashboards, and reports • Architected for Fusion Apps: seamless integration with flex, trees, security, … • Low total cost of ownership

12. Fusion Reporting and Analytics Real-Time, Historical, Forward Looking

13. Fusion BI Architecture Content Summary: • 300+ embedded analytics • OBIA: 3,000+ reports, 4,000+ metrics • OTBI: Covers 35+ Fusion Products Self-Service Query & Reporting Pre-Packaged Reports & Dashboards Fusion Embedded Analytics BI Common Semantic Model BI Common Semantic Model: • Supports highly aggregated trending and real-time transaction listings from a single query model OBIA OTBI Real-Time Queries OBIA Data Warehouse BI View Objects: • Are single source of truth for BI • Represent facts and dimensions • Implement Apps data security • Handle MLS ETL BI View Objects EBS, PSFT, JDE, Siebel, Other Fusion Applications Transactional Database

14. BI in Fusion Applications Broad Coverage Across Functional Modules • Pre-Built Analytics Content Coverage

15. Comprehensive Business Insight Right Insight for the Right Job • Right Insight for the Job

16. Program Agenda • Overview of Analytics for Fusion Applications • Usage Patterns and UI Integrations • Roadmap Update • Customer Deployment Scenarios • Q & A

17. Consolidated BI Content Catalog Better User Experience • Single repository for • BI Publisher reports • OTBI reports & dashboards • BI Apps dashboards & scorecards • Financial Reporting • Matches Fusion Applications main menu structure • Ease of navigation for Fusion Apps users • Folder structure is content driven, not technology driven

18. Fusion Application Dashboards & Home Pages Mashup of Reports and Portlets • Personalize role based Home Page • Combine context aware BI and transactional content • Navigate BI actions to related Fusion Applications information

19. Embedded Analytics in Transaction Pages Contextual, Relevant, Actionable • Embed Analytics within the Fusion Applications business processes • Enable better decisions with relevant, context aware Analytics

20. BI Dashboards Multi-Page Dashboards with Full Interactivity • Launch entire BI Dashboards from Fusion Applications • Gain insight from a combination of historical and forward-looking analytics 20

21. Reports and Analytics Work Area Access Entire BI Catalog • Access Entire BI Catalog • Browse and view entire BI Catalog • Access personal & shared reports • Launch BI tools for advanced actions • Create new reports with BI Composer 21

22. Reporting Pane One Click Access • One-click access to frequently used reports & dashboards • Contextually relevant to current Apps work area • Customer configurable content 22

23. Search Integration Find Relevant BI Content in Fusion Applications

24. BI Composer Create New Reports from Within the Fusion Apps UI • Author reports within the Apps UI • Wizard-based for ease of use • Supports tables, graphs, crosstabs, • Sorting, filtering, formatting • Access any deployed BI subject area • Save reports to the catalog & share with others 24

25. Oracle Apps in the Cloud Mobile Strategy User Experience Aligned with User Need Cloud Apps for Mobile Web Cloud Apps for Tablets Cloud Apps for Smartphones Highly responsivenative experience that leverages offline & device capabilities. Native user experience where most tasks can be done by simple gesture.

26. Fusion Tap: Performance Indicators Graphical Representation of KPI Carousel of Related Documents for KPI KPI Watchlist KPI With actual & status

27. Fusion Tap: Worker Predictions Nine box with worker positioned Predicted performance & attrition key factors

28. Oracle BI Mobile HD Application for iOS • Full, interactive support for all OTBI and OBIA reports, dashboards and scorecards • No need to redevelop content for mobile consumption • Collaborate and take action while on the move • Supports offline storage and consumption • Rich Views of your Business

29. Drastically Improved Cost of OwnershipAnalytics for Fusion Applications • Single installer across Fusion OLTP, Fusion BI and supporting technology • Automated provisioning rather than manual connection configurations • New Functional Setup Manager interface to manage the install & configuration tasks • New Configuration Manager interface to manage detailed warehouse configurations such as currencies, domains • BI Extender to propagate flex field configurations into BI and ETL metadata • Shared runtime metadata for function security, data security, hierarchies, effective dating, set ids, field descriptions/translations, list of value • Shared systems management using Enterprise Manager

30. Program Agenda • Overview of Analytics for Fusion Applications • Usage Patterns and UI Integrations • Roadmap Update • Customer Deployment Scenarios • Q & A

31. What Cloud Means for Packaged Analytics • Companies need enterprise data warehousing solutions more than ever • Key enterprise data spread over more systems, on premise and in the cloud • Enterprise BI semantic model provides only consolidated view of the business • In the next 5+ years the majority of these efforts will remain on premise • Companies need pre-built analytics supporting their Cloud applications • Real-time operational analytics and reporting fills majority of requirements • Embedded analytics require dedicated data mart for more complex calculations such as cycle times, aggregate trend metrics, KPIs • Extensibility and configurability via web-based wizards is critically important • Advanced configuration/customization use cases are not as important

32. Priority #1: Cloud Adapters Oracle Analytic Applications • Ensure BI Applications “on premise” increases its appeal as a foundation for enterprise data warehousing by supporting sourcing of information from cloud applications • OBIA – Oracle BI Applications • Pre-built analytics for EBS, PSFT, Siebel, JDE, Fusion, SAP, IBM Maximo • Add ETL adapters to cloud-based applications • Planned: Fusion Public Cloud - support common “coexistence” scenarios • Rely on partners for third party adapters such as Salesforce.com, WorkDay • Protect existing customers’ investments in Oracle BI • Continue build out of content & adapters for Apps Unlimited systems • Adapters to Taleo, Rightnow, and other new Oracle Public Cloud offerings Goal Product Futures

33. Priority #2: Pre-Built Analytics in the Cloud Oracle Analytic Applications • Ensure pre-built analytics supporting Oracle’s cloud-based applications are complete and easy to configure and extend • OTBI – Oracle Fusion Transactional Business Intelligence (Available Today) • Real-time operational analytics and reports built with OBIEE • Broad coverage over all Fusion Applications families • Supports embedded analytics • OBIA – Oracle BI Applications (Available On Premise, Planned for Cloud) • Rich, more aggregated analytical dashboards built with star schemas • Easy to configure version of existing OBIA product deployed in the cloud • Initially - limited customizability or support for other data sources • Supports embedded analytics with Fusion Applications • Automatic coverage for data model extensions, support for non-cloud sources Goal Product Futures

34. Oracle Applications PlanningBI 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 • Financials, Procurement & Spend, Supply Chain & Order Management Analytics • For Fusion Applications Release 5 • ETL with Informatica • Real-time operational analytics (OTBI) • Support for ODI across all sources • Data model and release integration across Fusion and Applications Unlimited • New content: Fixed Assets, Commitment Control, Sourcing, Time & Labor, Project Resource Management, Global Payroll • New modules: Student Information Analytics, Spend Planning • New adapters: Fusion Applications Public Cloud adapters, Procurement & Spend Analytics for JDE, Price Analytics for EBS, Supply Chain & Order Management Analytics for PeopleSoft • User Experience Redesign (partial) • Cost of Ownership Improvements: Data Lineage, ETL Data Validation, Golden Gate • BI Applications in Oracle Public Cloud • ODI and Informatica : release alignment • Merge in SAP code line • New content/modules: Talent Management , Grants, Benefits, Depot Repair & Field Service, EVM & Project Scheduling, EAM enhancements • New adapters: Adapter to Taleo, Manufacturing Analytics for JDE. • Additional operational planning applications • Unstructured/big data analytic applications • Continue user experience redesign • Additional cost of ownership improvements BI Apps 7.9.6.3 + Extension PackApril 2012 What’s Next 0-12 month planning cycle Future DirectionsPost 12 month planning cycle BI Apps 7.9.7.2 September 2012 BI Apps 11.1.1.6.3 September 2012

35. Robert Brust Former Sprint CIO Business Finance Magazine. February 2012 “Executives rarely see the magnitude of overall spend that these [indirect] categories represent. When looked at individually, the dollar amount of indirect spending in each department seems insignificant when compared to raw materials. But, when added together, they can account for hundreds of millions of dollars.”

36. Oracle Spend Planning Control and Optimize Indirect Spend • Spend Planning enables procurement teams to forecast indirect spend, and use packaged what-if modeling tools to reduce spend • Lines of business can use Spend Planning to quickly project future purchases that align with budgets, and develop multiple scenarios using different driver assumptions

37. Oracle Spend Planning Extend Value of OBIA Investment • Pervasive context from BI helps planners make better decisions about supplier allocations • Integration to Oracle ERP business rules means more accurate plans based on real-world constraints • Leverages existing Procurement & Spending Analytics data model and ETLs

38. Program Agenda • Overview of Analytics for Fusion Applications • Usage Patterns and UI Integrations • Roadmap Update • Customer Deployment Scenarios • Q & A

39. Other Apps Oracle EBS Financials Oracle Fusion Applications PeopleSoft HR Siebel CRM Oracle BI Applications Oracle BI Applications Implementation StrategyInsight for Today’s Applications and for Fusion Add insight layer over existing IT assets Use prebuilt BI Apps to implement quickly and follow best practices Start with a single area or tackle several in parallel Also build custom analytic apps as necessary Benefit from enterprise-wide analysis as you broaden your implementation Incorporate Fusion Apps using same architecture and technology

40. Customer Scenario #1: Independent Cloud • Recommend Analytics Roadmap: • Leverage HCM Cloud Service built-in reporting options (OTBI, BIP) for majority of operational HR reporting (available functionality) • Subsequently, deploy HR Analytics cloud service for DW-based trending and aggregations across the large employee population (planned functionality) • Moving HR footprint to Oracle HCM Cloud • Need to analyze ongoing progress and trends of key campaigns around recruiting, appraisals, compensation • Not integrating with third party or legacy HR systems from a reporting perspective • No need for visibility across business functions • European Energy Multinational

41. Customer Scenario #2: Fusion Upgrade • Recommend Analytics Roadmap: • Leverage HCM Cloud Service built-in reporting options (OTBI, BIP) for majority of operational HR reporting (available functionality) • Source HCM Cloud Service data into a single on premise BI Applications deployment for both HR and ERP functions (planned functionality) • Existing PeopleSoft HR deployment • Moving HR footprint to Oracle HCM Cloud Service but other ERP systems remain on premise • Existing Oracle HR Analytics deployment, which also integrates non-Oracle recruiting system data • Further extended BI deployment with custom analytics against legacy systems • US High Tech Company

42. Customer Scenario #3: Fusion Co-Exist • Recommend Analytics Roadmap: • Start with an HR Analytics deployment against the PeopleSoft source • Next year, source HCM Cloud Service and Taleo data into on premise HR Analytics deployment (planned functionality). • Use the universal adapter to load information from niche HR solutions • Existing PeopleSoft HR, Taleo deployment • Plan on adopting Fusion HCM Cloud Service next year but maintaining Payroll on PeopleSoft (maintaining Taleo also) • Looking for HR-wide visibility across these sources and other niche HR solutions • Existing legacy DW against their PeopleSoft system • Global Fortune 100 Bank

43. Oracle BI Applications Get Fusion Ready with BI Applications Today • Compelling Products Available Today • Complete end to end analytics solutions for Apps Unlimited and SAP customers • Deploy rapidly as data marts or as basis for conformed, complete enterprise warehouse • Best practice role-based reports and dashboards • BI Applications Make Sense as Part of an ERP Upgrade • Add BI implementation for real business user visible benefits of an ERP or CRM upgrade project • Improved Fusion Applications Readiness • Uptake of Fusion Middleware technologies, like BI Foundation, Enterprise Manager, OID • Reduced end user Fusion Applications training • Continuity of Reporting during Coexistence or Upgrade • End user reports and dashboards can be retained and will start working against alternate source

44. “With an ever-expanding portfolio of tools and applications, Oracle University is strongly oriented toward the individual learner.” 2013 leader inIT EducationAccording toIndustry Analyst Firm IDC “Of the vendors evaluated, Oracle is most adept at describing the value of training at multiple parts of the technology deployment life cycle.” “This decentralized control [of the curricula development] helps maximize the relevance of the training offering to the elements that are most useful to end users.”

45. One of the World’s Largest Training Organizations Worldwide classrooms: 200+ in 89 countries Courses: 2000+ Languages supported: 28 Classes per week: 600+, 90+ Virtual Classes On Demand Courses: 100 and growing Students trained per year:400,000+ Global education partnerships:500+ Oracle certified professionals: 1.6+ million

46. Training & Certification for the Entire Stack ROLE-BASED TRAINING Administrators Developers Business Users Architects Implementers WHEN AND HOW YOU NEED IT In-Class Training On Demand Private Live Virtual Class VALIDATED BY INDUSTRY-RECOGNIZED CERTIFICATIONS Oracle Certified Professional Oracle Certified Expert Oracle Certified Associate Oracle Certified Master

47. More than 2000 Courses Across 50+ Products

48. 160+ Certification Credentials Available

49. Contact Oracle University at: Telephone: 800 810 9931 orEmail: OUChina_CN@oracle.com Website: www.oracle.com/cn/education 2013 leader in IT Education education.oracle.com

50. Q&A