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.