2 Replies Latest reply on Sep 7, 2018 11:37 AM by Shakib Mohammad

    Data Modeling ( 2 Fact and multiple Dim)

    Shakib Mohammad

      Hi Team,


      Does anyone come across below situation and encountered similar kind of issue?


      When I am joining fact 2 with Dim 1 and Dim 4 and creating a sheet using these table then no data is popping up. but, in the database query is returning the result.


      1> When I am joining Fact 2 with Dim 1 then data is coming fine, but when I do join with Dim 4 then no data.


      Any idea how to tackle this issue or any specific rule to follow for below modeling?


      Any help would be appreciated.