Permissible Joins

This table lists the types of joins that can be created in Birst. Joins can be created on the Data Flow page in the Admin module. See Joins for more information about joins and Setting up Joins to learn how to create joins.

Source 1

Source 2

Allowed to Join?

No

Yes - Types of Joins Allowed

Discovery

(including inherited Discovery sources)

Discovery

 

Inner, Left Outer, Right Outer

Raw or Derived (scripted)

No

 

Measure/Dimension warehouse table

 

Inner, Left Outer, Right Outer

Live Access

No

 

Raw or Derived (Scripted)

Discovery No  

Raw or Derived (scripted)

No

Inner only

Measure/Dimension warehouse table

No

 

Live Access

No

 

Measure/Dimension Warehouse Table

Discovery No

 

Raw or Derived (scripted)

No

 

Measure/Dimension warehouse table

No

 

Live Access

No

 

Live Access

Discovery No

 

Raw or Derived (scripted)

No

 

Measure/Dimension warehouse table

No

 

Live Access

 

Inner, Left Outer, Right Outer

See Also
Joins
Setting up Joins
Performing a Complex Join
Creating an Inherited source
Creating a Live Access Connection