slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Analytics for Fusion Applications: Overview and Strategy PowerPoint Presentation
Download Presentation
Analytics for Fusion Applications: Overview and Strategy

Loading in 2 Seconds...

play fullscreen
1 / 52

Analytics for Fusion Applications: Overview and Strategy - PowerPoint PPT Presentation

  • Uploaded on

Analytics for Fusion Applications: Overview and Strategy. Zhu Yao Oracle University Principal Instructor .

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

Analytics for Fusion Applications: Overview and Strategy

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
analytics for fusion applications overview and strategy
Analytics for Fusion Applications: Overview and Strategy

Zhu YaoOracle University Principal Instructor


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.

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










Source: Gartner Executive Programs, "Amplifying the Enterprise: The 2012 CIO Agenda," January 2012

Source: IDC

today s typical bi landscape
Today’s Typical BI Landscape

Hard to Maintain, Duplication and Inconsistency of Tooling

Disparate User Interfaces

Independent Silos of Information, No Global Visibility













Non-Oracle Apps

Existing Apps

Unstructured Data

External Data

challenges faced by users
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
oracle business analytics
Oracle Business Analytics

Hardware And Software Engineered To Work Together



BI Foundation

Strategy Management

Planning &Forecasting

CRM Analytics

Industry Analytics

ERP Analytics

Reporting &Publishing



Detect& Alert

Query &Analysis

Interactive Dashboards




Financial Close & Reporting

Profitability Management



Data Integration

Content Management


BI Server


Dimension Management

Predictive Analytics




Exalytics In-Memory Engineered System

Exadata Engineered System

Storage & Tape

Common Enterprise Information Model

embedded bi
Embedded BI

Surmounts the Challenges of Traditional BI



Disconnected. Open Ended.

Embedded. Closed Loop.

bi in fusion applications
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
fusion reporting and analytics
Fusion Reporting and Analytics

Real-Time, Historical, Forward Looking

fusion bi architecture
Fusion BI Architecture

Content Summary:

  • 300+ embedded analytics
  • OBIA: 3,000+ reports, 4,000+ metrics
  • OTBI: Covers 35+ Fusion Products


Query &


Pre-Packaged Reports & Dashboards




BI Common Semantic Model

BI Common Semantic Model:

  • Supports highly aggregated trending and real-time transaction listings from a single query model


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


BI View Objects

EBS, PSFT, JDE, Siebel, Other

Fusion Applications Transactional Database

bi in fusion applications1
BI in Fusion Applications

Broad Coverage Across Functional Modules

  • Pre-Built Analytics Content Coverage
comprehensive business insight
Comprehensive Business Insight

Right Insight for the Right Job

  • Right Insight for the Job
program agenda1
Program Agenda
  • Overview of Analytics for Fusion Applications
  • Usage Patterns and UI Integrations
  • Roadmap Update
  • Customer Deployment Scenarios
  • Q & A
consolidated bi content catalog
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
fusion application dashboards home pages
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
embedded analytics in transaction pages
Embedded Analytics in Transaction Pages

Contextual, Relevant, Actionable

  • Embed Analytics within the Fusion Applications business processes
  • Enable better decisions with relevant, context aware Analytics
bi dashboards
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


reports and analytics work area
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


reporting pane
Reporting Pane

One Click Access

  • One-click access to frequently used reports & dashboards
  • Contextually relevant to current Apps work area
  • Customer configurable content


search integration
Search Integration

Find Relevant BI Content in Fusion Applications

bi composer
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


oracle apps in the cloud mobile strategy
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.

fusion tap performance indicators
Fusion Tap: Performance Indicators

Graphical Representation of KPI

Carousel of Related Documents for KPI

KPI Watchlist


With actual & status

fusion tap worker predictions
Fusion Tap: Worker Predictions

Nine box with worker positioned

Predicted performance & attrition key factors

oracle bi mobile hd application for ios
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
drastically improved cost of ownership analytics for fusion applications
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
program agenda2
Program Agenda
  • Overview of Analytics for Fusion Applications
  • Usage Patterns and UI Integrations
  • Roadmap Update
  • Customer Deployment Scenarios
  • Q & A
what cloud means for packaged analytics
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
priority 1 cloud adapters
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, 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




priority 2 pre built analytics in the cloud
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




oracle applications planning bi applications current releases and roadmap
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 + Extension PackApril 2012

What’s Next

0-12 month planning cycle

Future DirectionsPost 12 month planning cycle

BI Apps

September 2012

BI Apps

September 2012

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

oracle spend planning
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
oracle spend planning1
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
program agenda3
Program Agenda
  • Overview of Analytics for Fusion Applications
  • Usage Patterns and UI Integrations
  • Roadmap Update
  • Customer Deployment Scenarios
  • Q & A
oracle bi applications implementation strategy insight for today s applications and for fusion

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

customer scenario 1 independent cloud
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
customer scenario 2 fusion upgrade
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
customer scenario 3 fusion co exist
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
oracle bi applications
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

“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.”

one of the world s largest training organizations
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

training certification for the entire stack
Training & Certification for the Entire Stack




Business Users





Training On Demand


Live Virtual Class


Oracle Certified Professional

Oracle Certified Expert

Oracle Certified Associate

Oracle Certified Master

Contact Oracle University at:

Telephone: 800 810 9931



2013 leader in IT Education