community-tableau-server-insights icon indicating copy to clipboard operation
community-tableau-server-insights copied to clipboard

Published 20 hours ago • verified publisher icon tableau

Moving to Relationships

Open beduke17 opened this issue 4 years ago • 2 comments

It would be great to take advantage of Relationships in 2020.2 to reduce duplication in the data.

Looking further into this, the security model will break due to the lack of joining on calculations.https://kb.tableau.com/articles/issue/Unable-to-Define-Relationships-Based-on-Calculated-Fields-or-Geographic-Fields

beduke17 avatar Sep 22 '20 02:09 beduke17

The security model also presents issues for Prep, as Prep cannot connect to a published data source on Server that uses any user filtering. :( I view that as a feature need for Prep, though.

To work around the relationship issue, we'd have to build the security model into every "table" that relates to the others, and include a data source filter on top of that for each calc built. That'd definitely make for ugly queries, and no doubt less efficient ones to boot, not to mention more overhead for any changes we might want to make.

mcoles avatar Oct 02 '20 20:10 mcoles

v2020.3 introduced relationship calculations so that's no longer a blocker.

jdrummey avatar Feb 24 '21 21:02 jdrummey