Getting started with Oracle Fusion CX Analytics

October 3, 2023 | 4 minute read
Divit Gupta
Principal Architect
Text Size 100%:


In the dynamic realm of modern business, harnessing the power of data is not just an advantage—it's a necessity. Oracle Fusion Analytics emerges as a beacon in this data-driven landscape, offering a comprehensive suite of tools designed to transform raw information into actionable insights. From customer-centric views that break down silos between sales, marketing, and service to empowering end-users with self-service data preparation, Oracle Fusion CX Analytics promises to reshape the way organizations understand and utilize their data. This blog explores the nuances of Oracle Fusion Analytics, delving into its prebuilt, cloud-native analytics application that caters to sales, marketing, service, and finance business users. Join us on a journey through the features, functionality, and the potential of Oracle Fusion Analytics, where data isn't just information—it's a pathway to informed decision-making and unparalleled business growth.


Oracle Fusion CX Analytics stands out as a prebuilt, cloud-native analytics application tailored for sales, marketing, service, and finance users. By providing out-of-the-box insights, it empowers decision-makers with valuable information. One of its key strengths lies in breaking down data silos between sales, marketing, and service, fostering a customer-centric perspective on revenue generation activities. The application unifies sales, marketing, and service data, promoting a comprehensive understanding of revenue potential. Prebuilt data pipelines to Oracle Fusion CX Cloud applications simplify data integration, ensuring a consistent and accurate business-critical view. Notably, Oracle Fusion CX Analytics doesn't require coding for customer experience teams to enhance analytics; embedded machine learning and data from diverse sources beyond Oracle Fusion Cloud Applications can be easily incorporated. This analytics solution nurtures an insights-driven business culture, supporting the entire analytics workflow. With self-service data preparation capabilities, business users can access, combine, and leverage relevant data across departments. This blog delves into the details of predefined objects in Oracle Fusion CX Analytics, encompassing tables, entity relationships, subject areas, job roles, duty roles, associated business questions, metric details, prebuilt analyses, prebuilt business metrics, and prebuilt dashboards. Additionally, it introduces features available for preview, allowing functional administrators to assess and understand new functionalities before their default rollout. 

Features Available for Preview

Preview features provide functional administrators with the capability to toggle functionalities on and off. This allows your organization to assess and familiarize itself with new features before they are automatically implemented by default.



See Fusion CX Analytics table types and their columns, primary keys denoted as key columns, data types, and the referred table and column names.

Table Types

The suffixes in table names designate the table type.

  1. CA, A: Aggregate
  2. CF, F: Fact
  3. CF_DN: Denormalized Fact
  4. CG, G: General
  5. D: Dimension
  6. DH: Dimension Hierarchy
  7. EF: Extended Fact
  8. EN: Oracle internal use only
  9. H: Helper
  10. P: Prediction
  11. TL: Translation

Data Store

Enhance your reports by selecting specific columns from different view objects (VOs) within the data sources of Oracle Fusion Cloud Applications. By choosing columns from various VOs, you can establish an enrichment dataset and use it to formulate a data pipeline activation plan. This process facilitates the smooth extraction and loading of data from additional Oracle Fusion Cloud Applications VOs, making it easily accessible in Oracle Autonomous Data Warehouse tables. Subsequently, you can leverage this data for visualization and analysis purposes.

Data Lineage

Choose the subject area for each of the Fusion Analytics products to examine the data lineage specifics. This allows you to comprehend the lineage details of columns and tables, tracking from the presentation layer to the physical layer.

Data Augmentation

Entities serve as fundamental concepts or foundational elements for executing business processes within any of the Fusion Applications. Oracle Fusion Analytics extracts data related to these crucial entities and presents the data in analysis-friendly data models, represented as tables. Internally, Oracle Fusion Analytics maintains records of tables, capturing entity details along with tables containing references for entities. As the data augmentation framework introduces additional attributes beyond the predefined data model, users observe the new information as new attributes linked with the respective tables. The Entity ID constitutes a unique set of attributes that serves to identify the entity.


This blog covers essential elements of Fusion Analytics, from enriching reports with specific columns to comprehending data lineage details, providing users with a holistic view of Oracle's analytics solution and empowering them to leverage its capabilities for enhanced decision-making. For more information and to ask questions, please visit Fusion Analytics on the Oracle Analytics community site.

Divit Gupta

Principal Architect


Previous Post

Unlocking the Power of Oracle Fusion Analytics

Divit Gupta | 3 min read

Next Post

Enable drill back from Oracle Analytics to Oracle Enterprise Performance Management

Pavan Kasetty | 6 min read