Can you get augmented table data into an FAW subject area

JDCal

I am pretty new to FAW configuration and development. I have created a custom subject area for learning which I will create a workbook from and take the code from it. I need to create a custom view from it but I have to add fields/tables to it that aren't found in FAW, but that data is found in HCM Empower. I have created a few augmented tables but can't seem to find a way to add the fields from them to the SA. I appears I will have to manually add the augmented table fields and joins. If this is the case, are there possible examples around to show that process or just in the learning sphere itself?

Is there a code/visualization sharing forum for FAW?

Thanks much!

Ashish-Oracle

@JDCal You can use the Semantic Model Extension Feature to add the Objects in the Data model, which have already been brought to the ADW using Data Augmentation.
https://docs.oracle.com/en/cloud/saas/analytics/24r2/fawag/semantic-model-customization.html

In case you find there are additional attributes which you want to add to the Prebuilt dimensions, you can Extend prebuilt dimensions with additional attributes from Fusion HCM source.

Refer: https://docs.oracle.com/en/cloud/saas/analytics/24r2/fawag/add-step-branch.html#GUID-736F433C-3E88-4F19-999C-43DCDC2FC1CB

PS: You will always need to define joins between the Custom facts and Dimensions that you plan to bring in to your Custom Subject area to perform any kind of reporting.

Mallikarjuna Kuppauru-Oracle

Hi @JDCal

Using the Data Augmentation functionality can you able to get the External Data .can you please let me know what are the steps are you done so that i will guide on further. however we don't have any KM for this but we will create the same.

Regards,

Arjun