Fusion Data Intelligence Platform - Common Subject Areas Overview

January 12, 2024 | 8 minute read
Matthieu Lombard
Consulting Solution Architect
Text Size 100%:

Validation

Content validated on 01/11/2024 with

  • Oracle Cloud Application 23C (11.13.23.07.0)

  • Fusion Analytics Application Version  23.R4

 Background

Oracle announced recently the Fusion Data Intelligence Platform, the next generation data, analytics, and AI platform for Fusion Cloud Applications customers and an evolution of Fusion Analytics Warehouse. The Fusion Data Intelligence Platform (FDIP) will provide users with curated data, ready-to-use analytics, and AI-powered intelligent applications that enable smart decisions and directed actions for optimal business outcomes. It is an evolution of the existing Fusion Analytics offering, with a dramatically increased scope and vision.

The Oracle Fusion Data Intelligence Platform includes the following out-of-box capabilities that will enable Oracle Fusion Cloud Applications customers to derive the most value out of their data.

  • 360-Degree Data Models: Will help business users understand how their data relates to business processes and goals by providing them with a clear and consistent representation of their organization’s data. By providing a collection of conformed data models based on Oracle Fusion Cloud Applications data and other data sources, the platform will provide organizations with a 360-degree view into various aspects of their business—customers, products, accounts, suppliers, and employees.
  • Prescriptive AI/ML Models: Will help organizations solve specific business problems by using out-of-box AI/ML models, such as workforce skills assessment and customer payment forecasting, to automate time-consuming tasks and free up employees to focus on more strategic tasks. In addition, large volumes of data can be quickly analyzed, uncovering valuable insights and patterns to identify opportunities for business growth and efficiency.
  • Rich Interactive Analytics: Will help business users interactively explore and visualize their data using out-of-box dashboards, reports, and KPIs. In addition, they can use Analytics Cloud capabilities like natural language query, auto insights, and mobile apps to gain quick access to data and insights.
  • Intelligent Applications: Will help organizations make more informed decisions faster by leveraging underlying prebuilt data models, AI/ML models, and analytics content. These applications will go beyond insights and recommend intelligent actions that improve business outcomes.

Oracle's vision for FDIP is detailed in this blog.

FDIP offers administrator and power users analytics capabilities to derive insight from the data pipelines executions, including data augmentations, custom data usage or user usage tracking.

It also provides capabilities for implementers or even functional users to build reconciliation dashboard to compare data in Fusion SaaS source records with data extracted and transformed in FDIP ADW, using the Data Validation features.

This blog provides an overview of the FDIP Common Subject Areas enabling FDIP users to derive insight described above. This blog also share sample FDIP OAC data vizualisations based on these Common Subject Areas.

Suggested Prerequisite Reading Material:

* Data Augmentation with FAW 

Overall prerequisites

* Have access to an Fusion Analytics Instance (OAC, ADW) with Administrative privileges

 Common Subject Areas Overview

As of version 23R4, FDIP offers five Common Subject Areas

  1. Custom Data Usage
  2. Data Augmentation
  3. Data Validation
  4. Usage Tracking
  5. Warehouse Refresh Statistics

CUST DATA USAGE

Figure 1: FDIP Common SAs 

Custom Data Usage Subject Area 

The Custom Data Usage Subject Area offers two main dimensions : Time and Tenant Metric Attributes and one single fact metric that is the custom Storage Usage in GB, as described in the following figure:

Cust Data

Figure 2: FDIP Common SA - Custom Data Usage

Data Augmenation Subject Area 

The Data Augmentation Subject Area offers Data Augmentation Details dimension and two metrics : Total Number of Augmentations and Total Number of Subject Areas as shown in the following figure:

Data Val

Figure 3: FDIP Common SA - Data Augmention

Data Validation 

The Data Validation Subject Area offers two main dimensions : Time and Validation Set Details. And for the metrics, it provide Source Value, Warehouse Value as well as the Variance.

DA

Figure 4: FDIP Common SA - Data Validation

In order to use Data Validaton, the following prerequisities must be met

  • Ensure that you can access the Oracle Transactional Business Intelligence instance and run queries.
  • Ensure that you have the same data security privileges in Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance.
  • Ensure that you’re assigned the Integration Specialist Group in Oracle Fusion Analytics Warehouse to access the Common folder in Oracle Analytics Cloud and to view the output of the data validation project.
  • Create a user, such as MyFAWValidationUser, to validate the extracted data as described here.
  • Create a custom BI Abstract role and associate it with an applicable user, such as MyFAWValidationUser, whose credentials you want to provide for data validation.
  • In Oracle Fusion Analytics Warehouse, on the Source Credentials tab of the Data Validation page, provide the credentials of the applicable user, such as MyFAWValidationUser.

 

CREDS

Figure 5: FDIP Common SA - Data Validation Credentials

In order to use Data Validaton, the following prerequisities must be met

The Data Validation Subject Area requires additional confirguation that is described here .

To acces Data Validation configuration, in FDIP

  • Navigate to Console > Data Validation

Nav

Figure 6: FDIP Common SA - Data Validation Navigation

  • To create scheduled validation (Weekly, Monthly or Quarterly), in the Scheduled Validation, create a new Validation Set using the Create New Report button. Then follow instructions here.

Sched

Figure 7: FDIP Common SA - Data Validation Scheduled

  • To create Ad-Hoc validation, in Detailed Validation, the subject area such as Financials - GL Balance Sheet, a metric related to the selected subject area, and the column set that you want to validate. Run the validation and review the Summary.

Det

Figure 8: FDIP Common SA - Data Validation Detailed

Usage Tracking Subject Area 

The Usage Tracking Subject Area offers severals dimensions : Time, User, Logical Query Execution Details ; and metrics such Number of Users, Number of USers sessions..., as depicted in the figure below :

Refresh Stats

Figure 5: FDIP Common SA - Usage Tracking

Warehouse Refresh Statistics Subject Area 

The Warehouse Refresh Statics Subject Area of several dimensions : Time, Refresh Summary details, Rejected Record Details and metrics such as Count of Jobs, Count of Rejected records ...:

usage tracking

Figure 6: FDIP Common SA - Custom Data Usage

 Video Detailed Walkthrough

The following video dives deepers into the Common Subject Areas and offers a walk through of the type of visualizations users can build with them.

 

Sample FDIP OAC Common Subject Area Visualization 

Download the artefacts

Here is the download link to the Common SA OAC Visuzalisations

Disclaimer : these artefacts are provided "as is", i.e. Oracle will not be responsible for supporting their use

This concludes the activities in the blog.

 Want to Learn More?

Click here to sign up to the RSS feed to receive notifications for when new A-team blogs are published.

 Summary

This blog described how to utilize Fusion Data Intelligence Platform to derive insight from the data pipelines executions, including data augmentations, custom data usage or user usage tracking.

It also provided walkthorugh of the capabilities for implementers or even functional users to build reconciliation dashboard to compare data in Fusion SaaS source records with data extracted and transformed in FDIP ADW, using the Data Validation features.

This blog provided an overview of the FDIP Common Subject Areas enabling FDIP users to derive insight described above. This blog also shared sample FDIP OAC data vizualisations based on these Common Subject Areas.

Bookmark this post to stay up-to-date on changes made to this blog as our products evolve.

Matthieu Lombard

Consulting Solution Architect

The Oracle A-Team is a central, outbound, highly technical team of enterprise architects, solution specialists, and software engineers.

The Oracle A-Team works with external customers and Oracle partners around the globe to provide guidance on implementation best practices, architecture design reviews, troubleshooting, and how to use Oracle products to solve customer business challenges.

I focus on data integration, data warehousing, Big Data, cloud services, and analytics (BI) products. My role included acting as the subject-matter expert on Oracle Data Integration and Analytics products and cloud services such as Oracle Data Integrator (ODI),  and Oracle Analytics Cloud (OAC, OA For Fusion Apps, OAX).


Previous Post

OCI Logging Analytics Best Practices Series - Custom Log Sources and Parsers Tips

Royce Fu | 9 min read

Next Post


CPQ: Use the of function urldatabypost for REST GET calls

Patrick Mc Erlean | 1 min read