Fusion Analytics Extensiblity Series: Case study-Data Augmentation (Part 2 of 4)

Abhishek Bajpai - CEAL Team-Oracle

In this series, we will discuss the use case and showcase the steps to bring in the custom object (created in Oracle Fusion Application) into Fusion Analytics and model it for analytical reporting. This is a 4-part series. The current part covers the Data Augmentation

Part 1- Use-Case Discussion.

Part 2- Data Augmentation

Part 3- Semantic Model Extension

Part 4- OOTB Security

https://videohub.oracle.com/embed/secure/iframe/entryId/1_npg5qr4v/uiConfId/35965902

This video is a continuation to the post

https://community.oracle.com/products/oracleanalytics/discussion/19571/fusion-analytics-extensibility-case-study-blending-fusion-app-custom-objects-with-fusion-analytics

Abhishek Bajpai - CEAL Team-Oracle

Next part :

https://community.oracle.com/products/oracleanalytics/discussion/19585/fusion-analytics-extensibility-case-study-semantic-model-part-3-of-4/p1?new=1

Abhishek Bajpai - CEAL Team-Oracle

@Ankur Jain--Oracle

Custom PVO Creation - Community Post

https://community.oracle.com/customerconnect/discussion/617060/how-to-create-custom-pvo-and-add-it-in-bicc

#2 - Subject Area

In the last screen for data Augmentation you get an option to select the existing subject Area or create a new one . As the product is evolving we prefer data Augmentation just for data extraction purpose and not creation of subject area , since the look and feel of final output is not as per the OOTB subject areas n( Note -The video was created for a POC in Sep,2022 when this was not the direction, Also if you notice in third part of the series we had to anyways discard Out of the Box subject area thus created by data Augmentation and create custom per the demand from the end user)

#3 Extend entity is a better option if the attributes are related to the existing dimension and you have exposed joining keys between the two tables .

Ankur Jain--Oracle

Thanks for your response @Abhishek Bajpai -CEAL Team-Oracle

Regarding point #3, as simple example is if I want to add few DFF of assignment extra info table then I have selected create dimensions. so these new fields will not be appear in existing subject area ?

Regards,

Ankur

Abhishek Bajpai - CEAL Team-Oracle

@Ankur Jain--Oracle The example that you provided can be easily answered by extending a dimension .