BI Publisher 12c - left outer joins — Oracle Analytics

Oracle Analytics Cloud and Server

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

BI Publisher 12c - left outer joins

Question
44
Views
0
Comments

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?