Connecting Table(Join)

Referential Join:

     Referential Join is a feature aviable only in OLAP engine. when testing Attribute Views outside the context of a Analytical View then the Join Engine will perform a Inner Join.

     Referential Join can not be used if a filter is set on a field in the right table.

 

Union:

     Do not Join Analytical Views, this could lead to performance implications. Instead use Union with constant values when work with multiple fact table.