KNOWLEDGE BASE

Join Culling Not Applied With Fact Table Join


Published: 28 Jun 2014
Last Modified Date: 27 Feb 2017

Issue

When joining multiple tables, applying the option "Assume Referential Integrity" does not cull the fact table, i.e. the first table dragged into the join window, even if no columns from the fact table are used in the worksheet.

Environment

  • Tableau Desktop 9.3 and earlier

Resolution

This behavior is currently by design.

Cause

The fact table will always be queried, even if Assume Referential Integrity is checked or if referential integrity is enforced in the database.
Did this article resolve the issue?