Fusion Analytics delivers prebuilt data integration and management components to handle Oracle Cloud Applications data, removing the complexity from data management tasks.
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.
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.
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.
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.
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.