...
Yet you would only be interested in dim_Product and dim_SalesDivision; like an SQL statement, Tableau will also need to process all the joins before it can reach the data you require.
So, what is the benefit to me in writing SQL rather than using the data model, especially if both are processed at the same time?
As far as I can tell, they both achieve the same result yet the Custom SQL method takes longer to build.
...