2 Replies Latest reply on Jan 16, 2012 6:17 AM by Peter Hopwood

    Is it possible to use multiple fact tables with different data granularities and multiple common dimension tables to build a rep

      Hi, I am new to Tableau, and I am using Tableau Desktop version 6.1

       

      Is it possible to use multiple fact tables with different data granularities and multiple common dimension tables to build a report in Tableau?

       

      For example:

       

      - I have one fact table F_Sub_Solution_Data that joins to D_Geo_Theater ,D_Geo_Region,D_Country,D_Partner,D_Solution,D_Sub_Solution and D_MQHY dimension tables with Metric_value metric

      And I have onather fact table F_Theater_Data that joins to D_Geo_Theater ,D_Geo_Region,D_Country,D_Partner,D_Solution,D_Sub_Solution and D_MQHY Ddimension tables with Agg_Metric_Value metric

       

      This is the dimension hierarchy :

       

      D_Geo_Theater ----> D_Geo_Region -----> D_Country -----> D_Partner ------> D_Solution ------> D_Sub_Solution

       

      F_Sub_Solution_Data Conatins data like :

       

      Partner_Id Year_Id Month_Id Solution_Id Sub_Solution_Id Metric_Name Metric_Value

      1 1 10 1 1 Qualified 1

      1 1 10 1 1 Committed 0

      1 1 10 1 1 Demo Ability 1

      And

       

      F_Theater_Data contains:

       

      Theater_Id Solution_Id Year_Id Month_Id Metric_Name Agg_Metric_Value

      1 1 1 10 Committed Solution Partners 100%

      1 1 1 10 Demo Ability 48%

      1 1 1 10 POC Ability 0%

      1 1 1 10 Technical Training 25%

       

      For the moment I did not figure out how to describe such database design in Tableau and I think this is

      Please can anybody help me out?

       

      Thanks.

      Param