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