0 Replies Latest reply: Mar 8, 2012 11:47 AM by Damien Lesage RSS

    A question of Modelling with multiple fact tables? Need help or direction

      Hello,

       

      I have what I think is a modelling issue. My current knowledge doesn't allow me to find a working and sustainable solution. I'm sure ou can help me find that solution, or at worst provide me direction to find it.

       

      So here is my question.

       

      I currently have the following model :

      Model.png

      Basically, Target and ProductionInf would be fact tables and the others tables would be dimensions.

       

      I need to design a graph that would look like the following which consists in comparing target value with actual production value:

      Graph_example.png

       

      My target is defined by location and month.

      My production is defined by machine and every 10-minuts.

       

      To do this graph I would need to join my target table to my calendar (the field OBJ_MONTH is a date).

       

      Unfortunately, I have two different level of aggregation and a direct link would create a loop.

       

       

      Do not hesitate to ask me questions if you think I was not clear enough.

       

      I provide a QlikView app and source files with faked data in hope it will help for helping me.

       

       

      Thanks for your help!!!

      Damien.