1 Reply Latest reply: Feb 22, 2016 3:50 PM by Stefan Wühl RSS

    Design - Tables with multiple links and loops

    Olivier Hoff

      Hello All,

       

      I'm facing a problem with the design of my model in qlik sense : I have in my datawarehosue several (dimension) tables that have multple links withe other tables.  For example :

       

      Capture.PNG

       

      Here the problem is that

      - A contact is linked to 1 company and 0 or 1 organisation --> I cannot break the link between company and contact

      - An organisation is linked to 1 company


      This is very simplified, but the 3 tables also have multiple links to my fact table (purchase).


      So I have a loop. My first idea was to load my Organisation table twice with 2 different names. But this happends on a lot of other tables in the dwh, so I want to make sure I'm doing the right thing here.


      Would there be any other solution than loading the tables multiple time? Do you guys think I have a design issue in my datawarehouse?


      I'm a bit lost here, so I'd really appreciate any comment/help.


      Thanks a lot,

      Olivier.