1 Reply Latest reply on Apr 2, 2015 10:08 AM by brad.earle.1

    multiple facts multiple dimensions

    Karthik Anivilla

      Hi ,

      I have a multiple fact multiple dimension model that needs to be done in Tableau in the same data model. So , i am looking for best way to implement it.Each fact is associated to common dimensions as well some dimensions specific to the fact. The model looks something like the below :

       

      Dim1->Fact A ->Dim 2 <-Fact B->Dim 4

                               Dim 3

       

      Dim 2 and Dim 3 are the common dimensions where as Dim1 is linked to Fact A and Dim4 is linked to Fact B

      Please suggest the ideal model to be followed in Tableau.

       

      Thanks

      Karthik

        • 1. Re: multiple facts multiple dimensions
          brad.earle.1

          What's wrong with the model as you have it?  Do outer (left) joins from the fact table to the dimension tables.

           

          If you have two Fact Tables and there isn't a one to one relationship, you may have to have several connections in order to achieve the right level of detail for what you are attempting to visualize (or you'll have to use aggregates and window calcs to attempt to fix it).  IMO, since you have data creation access, the approach I'd take is to create views within your datasource that align the data for the level of detail you expect to see in the viz.  It might mean that you have a few views -- then link them together using action filters in a dashboard -- navigating to more detail, but with the action, fewer records returned.