Left outer Join in FAW OAC data sets

user11382739

Dear All,

I have a requirement to create a report from 2 data sources. One of them is the pre-built FAW subject area and 2nd is AOR table in data warehouse.

My requirement is to create left outer join in such a way that all data from Subject Area should appear but only matching rows from the AOR table.

Thanks,

Naveen

Sumanth V -Oracle

@user11382739 - This can be achieved using datasets. Please create a dataset from the subject area and another one from the AOR table, then blend them. Please refer to the document below to understand more about data blending in OAC.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/build-visualization-adding-data.html#GUID-A498DC2D-A815-408F-839D-22F4EA1E03C3