Fusion Analytics Capabilities Explorer

Prebuilt data model and pipelines

Fusion Analytics delivers prebuilt data integration and management components to handle Oracle Cloud Applications data, removing the complexity from data management tasks.

Prebuilt data foundation components

Fusion Analytics is designed for easy and fast data analytics throughout the entire process, including data pipeline extraction, transformation and load of Oracle Cloud Applications data to a designed cross-functional data model, to the provided semantic model that translates the data model.

Figure 1: Prebuilt data management tasks of the analytics workflow done for you

Data pipelines for Oracle Cloud Applications data

When provisioning Oracle Fusion Analytics, the prebuilt data pipelines for specific functional areas are ready to be activated and scheduled for loading Oracle Cloud Applications data into the prebuilt data model. For example, general ledger is a functional area under finance and talent acquisition is a HR functional area.

Pipelines can be scheduled to refresh data either incrementally or on demand. Access to data is uninterrupted during the data refresh process for zero downtime.

The data pipelines automatically extract and load Oracle Cloud Applications flexfield extensions.

Figure 2: Example of data pipeline activation status

Data model for Oracle Cloud Applications data

The prebuilt data pipelines load Oracle Cloud Applications (ERP, HCM, SCM, and CX) data in a single, prebuilt data model, which resides in an embedded Oracle Autonomous Data Warehouse service. Data in this immutable star schema is accessible via secured SQL queries or through Fusion Analytics’ semantic layer with business role security ensuring reliability, accuracy, and high performance.

Additional external data sources can be loaded into custom database schemas in the same Oracle Autonomous Data Warehouse service, allowing for star schema extension. For more information, see data enrichment.

Semantic model and business subject area views

Oracle Fusion Analytics provides simple business subject area views of the hundreds of physical tables and views in the data model accessing Oracle Cloud Applications data. The mappings, rules, and translations between the complex physical data is done for you in easily understood and consistent business terms. Conformed dimensions (customer, supplier, product, fiscal calendar, business units, ledgers, etc.) are made available for easy cross-subject area analysis.

Figure 3: Semantic model with prebuilt conformed dimensions for easy cross-subject area analysis

These subject areas are the building blocks for authoring custom analyses and reports. For example, AP aging and AR revenue subject areas for finance and workforce, talent acquisition, and performance management subject areas for HCM. Users can quickly create visualizations and reports by dragging and dropping metrics and attributes from these subject areas. Oracle Fusion Analytics is designed to answer specific business questions and use cases from the summary levels to the lowest transactional grain analysis.

Subject areas are designed to optimize query execution with fine-grained tuning and data and role-level security. Oracle Cloud Applications flexfield extensions are also automatically made available. Users can customize the semantic model. For more information, see data enrichment.

Below is a sample list of the prebuilt subject area business views used to create visualizations and reports from Oracle Cloud Applications data.

Sample prebuilt subject area business views


  • GL profitability
    Provides details of base profitability metrics associated with income and expense accounts and the derived metrics that support the income statement.
  • AR aging
    Provides the ability to analyse all the open AR transactions with respect to aging details and current and overdue positions.
  • AP invoices
    Enables the analysis of AP invoices transaction activity and the associated details at the most granular level.


  • Workforce core
    Provides a comprehensive list of metrics to analyse employee assignments and events at the most granular level.
  • Talent acquisition
    Provides a comprehensive view of the hiring process, from candidate and recruiting insights to recruiting operations insights.
  • Performance management
    Provides insight into the employee work performance assessed through performance appraisals.


  • Spend
    Provides the ability to report on total spending across suppliers, products, item categories, business units, cost centers, buying locations, supplier locations, and associated hierarchy.
  • Agreements
    Provides the ability to report on purchasing agreement measures, such as consumed amount, count of agreements, day to expire analysed by supplier, procurement item, and business units.
  • Purchase orders
    Combines the information from purchase orders, purchase order costs, and purchase schedules.


  • Campaign opportunity revenue line
    Provides the ability to report on campaign performance, campaign cost/ROI, and associated opportunities with their revenue lines.
  • Opportunity
    Provides information on all the opportunities created and the associated account, opportunity owner, lead, campaign, contact, competitor, and partner.