3 Replies Latest reply on Feb 9, 2016 8:41 AM by Dan Cory

    Referential integrity with live connection on Hive

    yogev zilberman

      I found out something scary in Tableau that I hope is not bug/I am mistaken.

      Attach the picture model of semantic layer – I am working live on Hive with Referential integrity.

      Seems that:

      1. If I am taking from level 1 tables – I am getting only SQL from level 1 tables (as expected)
      2. If I am taking from level 2 tables – I am getting SQL from level 1+2 tables (as not expected)
      3. If I am taking from level 3 tables – I am getting SQL from level 1+2+3 tables (as not expected)
      4. If I am taking from level 3 tables – I am getting SQL from level 1+2+3+4 tables (as not expected)

       

      Am I doing something wrong?

      Is this how Tableau actually works?