Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
