tableau / community-tableau-server-insights

Community-built data sources for answering questions about Tableau Server
MIT License
129 stars 52 forks source link

Moving to Relationships #45

Open beduke17 opened 4 years ago

beduke17 commented 4 years ago

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 commented 4 years ago

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 commented 3 years ago

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