topic star schema with several fact tables in QlikView https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161378#M35284 <HTML><HEAD></HEAD><BODY><P>How does QV handles a star schema with several fact tables that forms a loop among them? like Business Objects Loop in fact tables. for example,</P><P>dim_period, dim_product, dim_market connected to fact_1</P><P>similarly, dim_product, dim_market connected to fact_2 etc.</P><P>I read in other thread that " <STRONG>QlikView will not let you create any kind of loop in your data structure</STRONG>."</P><P>Does QV prevent the situation from happen by CONCATENATION or there is some other logic behind it?</P></BODY></HTML> Sat, 22 May 2010 16:39:00 GMT 2010-05-22T16:39:00Z star schema with several fact tables https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161378#M35284 <HTML><HEAD></HEAD><BODY><P>How does QV handles a star schema with several fact tables that forms a loop among them? like Business Objects Loop in fact tables. for example,</P><P>dim_period, dim_product, dim_market connected to fact_1</P><P>similarly, dim_product, dim_market connected to fact_2 etc.</P><P>I read in other thread that " <STRONG>QlikView will not let you create any kind of loop in your data structure</STRONG>."</P><P>Does QV prevent the situation from happen by CONCATENATION or there is some other logic behind it?</P></BODY></HTML> Sat, 22 May 2010 16:39:00 GMT https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161378#M35284 2010-05-22T16:39:00Z star schema with several fact tables https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161379#M35285 <HTML><HEAD></HEAD><BODY><P>Hi, if you refers to reference circular , i recommend you this link <A href="http://www.quickqlearqool.nl/?p=910">http://www.quickqlearqool.nl/?p=910</A></P><P>Regards</P></BODY></HTML> Sun, 23 May 2010 04:57:23 GMT https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161379#M35285 2010-05-23T04:57:23Z star schema with several fact tables https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161380#M35286 <HTML><HEAD></HEAD><BODY><P>Hi nims,</P><P>I think that the solution for this kind of structure is "Linktable".</P><P>I have'nt experienced it yet but one guru of qliview(Oleg, i guess) made a nice documentation on it, downloadable here : http://www.naturalsynergies.com/user_files/Loading_Multiple_Fact_Data_Structures_in_QlikView.ppt</P><P>It would be nice for all of us if we could have a qvw example for this ? Isn't it ? Oleg Or John or Rob,...</P><P></P></BODY></HTML> Mon, 24 May 2010 13:46:05 GMT https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161380#M35286 2010-05-24T13:46:05Z star schema with several fact tables https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161381#M35287 <HTML><HEAD></HEAD><BODY><P>Cesijas the link you provided point to this post. Is it a joke or did'nt you see it ?</P><P></P></BODY></HTML> Mon, 24 May 2010 13:49:56 GMT https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161381#M35287 2010-05-24T13:49:56Z star schema with several fact tables https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161382#M35288 <HTML><HEAD></HEAD><BODY><P>My apologies the correct link is <A href="http://www.quickqlearqool.nl/?p=910">http://www.quickqlearqool.nl/?p=910</A></P><P></P></BODY></HTML> Mon, 24 May 2010 15:45:48 GMT https://community.qlik.com/t5/QlikView/star-schema-with-several-fact-tables/m-p/161382#M35288 2010-05-24T15:45:48Z