Oracle Fusion Analytics (Fusion Analytics), a part of the Oracle Fusion AI Data Platform, is a family of prebuilt, cloud-native analytics applications for Oracle Fusion Cloud Applications that provide ready-to-use insights to help improve decision-making. It’s extensible and customizable, allowing customers to ingest data and expand the base semantic model with additional content.

In addition to the pre-built content FAIDP offers in each pillar, we have an ongoing effort to provide more reusable artifacts for FAIDP which is described in this blog.

In this post we are sharing a reusable workbook that draws relationships various objects with FAIDP and OTBI. Thus providing the luxury of having all the data lineage in once place.

Note, FAIDP does not provide the data lineage to map columns to PVOs directly. However, using the publicly available separate data lineage (both FAIDP and OTBI) information, we have come up with a hands on solution to provide single-pane window to view both data lineage information. Using this, we can draw relationships and understand model and mapping to certain extent, and also helps understand the data model better and to plan the Semantic Model Extension by examining the data lineage.

NOTE: If you experience any issues importing this workbook or running it, it may be likely that your environment is on a version of FAIDP and/or OAC that is lower than the version used for developing this workbook. Update/upgrade timings are dependent on the data center your instance is in. We recommend waiting until your instance is upgraded to the latest version before importing and using this workbook.

Functional Areas
Not Applicable

Subject Areas
Not Applicable

Business Use Case

The provides single pane of window to view or compare both FAIDP and OTBI data lineage each products share separately. This helps in understanding the underlying data model / metadata and also look for the needed targets for Semantic Model Extension and Data Augmentation use cases.

Pre-Requisites:
None

The dva you are using may be an older version – you can replace the latest version data lineage files if needed to get the latest data lineage information.

Attachments

General Guidelines and Best PracticesHere some guidelines and recommendations to adapt these workbooks to your environment. Additionally, review the information provided on the workbook Help page (if any) to ensure the workbook renders data after you select the appropriate options and filters.

• Download the workbook from the above attachment section and import the workbooks to your instance. Note: These workbooks don’t have passwords, in general. Password, if any will be explicitly called out.
• All the workbooks will have a Help page containing required information and guidance on how to use the workbook. Be sure to follow these instructions before using the workbooks on your instance.
• Note, workbooks cover only generic use case / business scenario. Review the workbook content, make any changes as needed, and set the appropriate filters.
• It is highly recommended that you perform basic sanity checks and data validity before rolling out workbooks to business users and analysts.