I have a requirement where I need to create a data source connection in Tableau as per the data model in Cognos. The requirement is to join 5 tables (2 dimension and 3 fact tables) D1, D2, F1, F2, F3.
D1 <-> F1
D1 <-> F2
D1 <-> F3
D2 <-> F1
D2 <-> F2
D2 <-> F3
When I give joins as per above and create a data source in Tableau, it would create loops as below and the data values for the measures would get incorrect.
In Cognos to handle this kind of situation there is an option called as Alias Shortcut for dimension tables which can be created to break the loops formed in the data model.
However can someone let me know if there is any such option in Tableau.
See my comments on your other post. Since Tableau connections should only have one fact table, there's no issue about loops.