Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 242 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 90 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Left outer Join in FAW OAC data sets
user11382739
Rank 1 - Community Starter
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
Tagged:
0
Answers
-
@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.
0
