topic Need help Data Modeling in QlikView https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439145#M163637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 4 tables. PDV,INC,SUI,DMM.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; n°PDV&nbsp;&nbsp;&nbsp;&nbsp; n°Incident&nbsp;&nbsp; n° suivi</P><P>PDV&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>INC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>SUI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp; </P><P>DMM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P></P><P>How can create the star schema with fact table like DMM and dimension around like PDV, INC, SUI ?</P><P></P><P>Thanks for your help.</P></BODY></HTML> Fri, 15 Feb 2013 10:51:49 GMT 2013-02-15T10:51:49Z Need help Data Modeling https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439145#M163637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 4 tables. PDV,INC,SUI,DMM.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; n°PDV&nbsp;&nbsp;&nbsp;&nbsp; n°Incident&nbsp;&nbsp; n° suivi</P><P>PDV&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>INC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>SUI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp; </P><P>DMM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P></P><P>How can create the star schema with fact table like DMM and dimension around like PDV, INC, SUI ?</P><P></P><P>Thanks for your help.</P></BODY></HTML> Fri, 15 Feb 2013 10:51:49 GMT https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439145#M163637 2013-02-15T10:51:49Z Re: Need help Data Modeling https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439146#M163638 <HTML><HEAD></HEAD><BODY><P>Please find the attached file. </P><P></P><P>see if it is working for you.</P><P></P><P>HTH </P><P>Sushil</P></BODY></HTML> Fri, 15 Feb 2013 11:09:01 GMT https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439146#M163638 sushil353 2013-02-15T11:09:01Z Re: Need help Data Modeling https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439147#M163639 <HTML><HEAD></HEAD><BODY><P>Hi Jud,</P><P></P><P>It is just not to ask for star schema ,but you shoyld first get familiar with schema ,,,fact Dimension...and all aothe data warehousihg terms.</P><P></P><P>So i am giving you some link and go through them all and then analyse a best plan for your structure .</P><P></P><P><A class="loading" href="http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/" title="http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/">http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/</A></P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/servlet/JiveServlet/previewBody/1881-102-1-1865/Best Practices in Data Modeling.pdf" title="http://community.qlik.com/servlet/JiveServlet/previewBody/1881-102-1-1865/Best%20Practices%20in%20Data%20Modeling.pdf">http://community.qlik.com/servlet/JiveServlet/previewBody/1881-102-1-1865/Best%20Practices%20in%20Data%20Modeling.pdf</A></P><P></P><P></P><P>One of the easy way for your modell is just nPDV as same in all and load all table with same name column renamed.</P></BODY></HTML> Fri, 15 Feb 2013 11:36:55 GMT https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439147#M163639 sujeetsingh 2013-02-15T11:36:55Z Re: Need help Data Modeling https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439148#M163640 <HTML><HEAD></HEAD><BODY><P>Thanks for your help Sushil.</P></BODY></HTML> Fri, 15 Feb 2013 11:44:43 GMT https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439148#M163640 2013-02-15T11:44:43Z Re: Need help Data Modeling https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439149#M163641 <HTML><HEAD></HEAD><BODY><P>Hi Son ofSardar.</P><P></P><P>Thanks a lot for your link.</P></BODY></HTML> Fri, 15 Feb 2013 11:45:54 GMT https://community.qlik.com/t5/QlikView/Need-help-Data-Modeling/m-p/439149#M163641 2013-02-15T11:45:54Z