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

    How to model multiple fact table

    user12255470

      HI,

       

      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.