1 Reply Latest reply on Oct 8, 2015 8:33 AM by Gianni Ceresa

    How to model multiple fact table




      i have 2 fact tables and five dimention tables.


      fact tables - f1,f2

      dimention table - d1,d2,d3,d4,d5


      d1,d3 and d5 are joining to both f1 and f2.


      d2 is joining to only f1 and d4 is joining to only f2



      anyone suggest me best way to model this in bmm and display at least one column from all dimentiomn and fact tables in the report.