Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher 12c - left outer joins

Question
41
Views
0
Comments
3310714
3310714 Rank 6 - Analytics & AI Lead
in Oracle Analytics Forum

Summary

BI Publisher 12c - left outer joins

Content

Hi,


Does anyone know if it's possible to create LEFT OUTER JOINS in BI Publisher data models using multiple data sources?  I have sources from Oracle and SQL Server, but the data from Oracle isn't always available.  I'd still want to return everything from SQL Server side.  Any ideas?