topic Multi Fact data model in QlikView https://community.qlik.com/t5/QlikView/Multi-Fact-data-model/m-p/700031#M674816 <HTML><HEAD></HEAD><BODY><P>Hello, i have the following data model with2 fact tables and 5 dim tables, as you can see it is creating a synthetic key problem. The database is for an online ticketing system where users can buy and sell tickets for sporting events and concerts.</P><P>Can you please advise what steps i can take to resolve this issue. Thanks<IMG alt="Qlikview_tickit.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/62601_Qlikview_tickit.png" style="width: 620px; height: 392px;" /></P></BODY></HTML> Thu, 17 Jul 2014 19:43:09 GMT 2014-07-17T19:43:09Z Multi Fact data model https://community.qlik.com/t5/QlikView/Multi-Fact-data-model/m-p/700031#M674816 <HTML><HEAD></HEAD><BODY><P>Hello, i have the following data model with2 fact tables and 5 dim tables, as you can see it is creating a synthetic key problem. The database is for an online ticketing system where users can buy and sell tickets for sporting events and concerts.</P><P>Can you please advise what steps i can take to resolve this issue. Thanks<IMG alt="Qlikview_tickit.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/62601_Qlikview_tickit.png" style="width: 620px; height: 392px;" /></P></BODY></HTML> Thu, 17 Jul 2014 19:43:09 GMT https://community.qlik.com/t5/QlikView/Multi-Fact-data-model/m-p/700031#M674816 2014-07-17T19:43:09Z