See More

Top 5 Questions Customers Ask About Fusion Analytics

Here at Apps Associates, we have implemented Oracle Fusion Analytics numerous times and have worked and are working with many other clients who are evaluating Fusion Analytics.  We are often asked questions about Fusion Analytics and we thought it would be helpful to document the Top 5 questions we get from our clients about Oracle Fusion Analytics.

  1. What is included with Oracle Fusion Analytics (FA)? 
    • Oracle Fusion Analytics (FA) is a bundled product from Oracle – meaning it includes multiple Oracle products in one ‘bundle’ or Stock Keeping Unit (SKU).
    • The Oracle FA bundle includes:
      1. Prebuilt Data Pipeline to extract data from Oracle Cloud Fusion Apps and load it into the FA data warehouse.  Oracle owns, maintains, upgrades and tests this data pipeline.  
      2. Oracle Autonomous Data Warehouse (ADW) – full license with full capabilities – not a limited use license.  This is the data warehouse that receives the Oracle Cloud Fusion Apps data extracted by the prebuilt data pipeline.  In ADW, the ‘raw data’ from Oracle Cloud Fusion Apps is transformed by Oracle into a clean star schema data model to support efficient reporting and self-service analytics.
      3. Oracle Analytics Cloud (OAC) – full license with full capabilities – not a limited use license.  OAC is used for reporting against the data in the FA data warehouse (ADW).  
      4. Prebuilt KPI’s, Metrics, Reports and Dashboards – Oracle provides literally hundreds of prebuilt Key Performance Indicators (KPI’s), metrics, reports and dashboards with each module of Oracle Fusion Analytics.
    • At present, there are 4 modules of Oracle Fusion Analytics – each of which are sold and licensed separately and have their own SKU:
      1. Fusion ERP Analytics
      2. Fusion SCM Analytics
      3. Fusion HCM Analytics
      4. Fusion CX Analytics.
  2. Can we develop custom reports in Oracle Fusion Analytics and can Oracle Fusion Analytics be extended to include other, non-Oracle data sources?
    1. Yes – custom KPI’s, metrics, reports and dashboards can be developed in Fusion Analytics.  Although developing custom KPI’s, metrics, reports and dashboards from scratch is fully supported in FA, what we see more often is our clients starting with an out-of-the-box (OOTB) KPI or report and modifying it to reflect the unique aspects of their company (which is, of course, fully supported).
    2. Yes – Oracle Fusion Analytics can be extended to include non-Oracle data sources.  You may recall in #1 above that I mentioned that the data for Fusion Analytics is stored in Oracle ADW.  Well, ADW is a world class cloud data warehouse and data from any source can be loaded into ADW – and it is no different with ADW as a part of FA – data from any data source can be loaded into the ADW that is part of FA.  Perhaps even more importantly, however, after the non Oracle data is loaded into FA’s ADW, Oracle provides a straightforward, browser-based utility to allow clients to join non Oracle data with Cloud Fusion Apps data from a data model and subject area standpoint. This allows reporting across Oracle Cloud Fusion data and non Oracle Cloud Fusion data in a seamless fashion.
  3. Roughly how long does it take and what is the process for implementing Oracle Fusion Analytics?
    1. Apps Associates provides a ‘Quick Start’ offering to get customers up and running quickly on Oracle Fusion Analytics.  We will implement a single module of FA in 6 weeks, any two modules in 8 weeks and any three modules in 12 weeks.  Please note that these timeframes do not include integration of non Oracle data sources into FA’s ADW.
    2. The FA implementation process is included in our ‘Quick Start Offering’ and is as follows:
      • Provision Oracle Fusion Analytics instance
      • Create and associate users and groups (IDCS)
      • Configure security rules
      • Validate Cloud ERP/SCM/HCM/CX configuration parameters for Fusion Analytics’ OOTB KPI’s
      • Configure Oracle Fusion Analytics and the prebuilt data pipeline
      • Execute the FA data pipeline to extract data from Cloud ERP/SCM/HCM/CX and load it into FA’s ADW
      • Validate the OOTB KPI’s, metrics, reports and dashboards
      • Conduct User Acceptance Testing (UAT)
      • Conduct End User Training and Knowledge Transition to the going forward operational team
      • Plan for and execute migration to production for FA
  4. Doesn’t Oracle Cloud ERP/SCM/HCM already have everything I need for reporting and analytics?   Why do I need Oracle Fusion Analytics?
    • Oracle Cloud Fusion Apps have taken a giant leap forward with respect to reporting vs Oracle’s on premises versions like EBS, Peoplesoft and JDE.
    • Oracle Cloud Fusion Apps include Oracle Transactional Business Intelligence (OTBI) which enables reporting directly against the data in Oracle Cloud Fusion Apps.  For OTBI, the subject areas are defined and maintained by Oracle.
    • Customers find OTBI to be very helpful for operational reporting – especially any reporting that needs to be real time.
    • However, the OTBI subject areas cannot be modified by the end users and it is difficult to do cross-subject area analysis with OTBI.  OTBI is not able to access any data outside of Oracle Cloud Fusion Apps and OTBI struggles in terms of performance as data volume grows over time.
    • Companies are seeing the value of Fusion Analytics in the areas of strategic performance reporting, drill down analytics by analysts to uncover hidden insights, cross-subject area analytics, seamless trend reporting across current and historical data , reporting and analysis across multiple Oracle and non-Oracle data sources and flexibility to create KPI’s and reports of any kind using any data.
  5. Oracle Cloud ERP/SCM/HCM are updated quarterly by Oracle.  Will I have to retest FA’s data pipeline, KPI’s and reports each quarter?  Does Oracle help with that?
    • Customers of Oracle Fusion Analytics do not have to worry about maintaining or testing the prebuilt data pipeline as the Oracle Cloud Fusion Apps are upgraded over time.  Before a new enhancement is added to Oracle Cloud Fusion Apps, Oracle will test the impact of the enhancement on the prebuilt FA data pipeline.  If any updates are required to the prebuilt data pipeline as a result of the Cloud App enhancement, Oracle will make those changes and test them. 
    • The confidence that comes with knowing that your data pipeline will not gradually become obsolete over time is one of the main benefits of Oracle Fusion Analytics.