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