1 of 1 people found this helpful
You can't set up a join exactly like this in Tableau's data source creation, you'd need to start with one of the dimension tables, join in the fact tables, then join the other dimension table to the three fact tables. Make sure that you have referential integrity turned on so that Tableau's join culling can prevent over-large joins.
However this kind of "put everything in one source" way of building out a data source for Tableau isn't necessarily the way to go as it can end up not having the performance that you need. It's better to focus in on the particular business questions being asked and make sure you have just enough data to answer them. This white paper is a really good reference on how to understand how to build out fast & functional Tableau workbooks: Designing Efficient Workbooks | Tableau Software.
Thank you for your response. As far as I understand, the only way to join a table with another one is just dragging it to the right hand side of another one. So, if I want to extend my model by adding another conformed dimension (like channel), I can not join this new dimension with fact tables. Right?
Link you shared will be very helpful for me. Thanks again!
I can add new conformed dimension as a new alias. Thanks again.