6 Replies Latest reply: Jan 28, 2013 5:31 PM by Johan Ohlsson RSS

    Issues with data model

      Hi,

       

      Below I've attached a picture over a universe in Business Objects. I would like to re-create this in QlikView but have problem with how to handle the 2 facts table (F_SoldInsurance and F_PossibleInsurance). All FK to different dates exists only in one of the fact tables (F_SoldInsurance). If I would like to make calculations with measures from both F_SoldInsurance and F_PossibleInsurance and then be able to filter over time what is the best approach here to model this?

      Unfortunately it’s not possible to join them. 

       

      TIA  

       

       

      Universe.PNG