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 About 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 |
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) |
|
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
About Joins
Setting up Joins
Performing a Complex Join
Creating an Inherited source
Creating a Live Access
Connection