Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

BI Publisher 12c - left outer joins

Question
42
Views
0
Comments
3310714
3310714 Rank 6 - Analytics & AI Lead
in Oracle Analytics Cloud and Server

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?