Moving to Relationships

[beduke17]

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

[mcoles]

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.

[jdrummey]

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