topic Re: Qlikview on star schema in QlikView https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805654#M1044531 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can read some of this documents also</P><P></P><P><A href="https://community.qlik.com/docs/DOC-7454">The Optimal QlikView Data Structure</A></P><P></P><P><A href="https://community.qlik.com/thread/102887">Star Schema or Snow Flaxe schema?</A></P><P></P><P><A href="https://community.qlik.com/message/563248">What is Star schema in qlikview?</A></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 24 Nov 2014 08:17:01 GMT its_anandrjs 2014-11-24T08:17:01Z Qlikview on star schema https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805652#M1044529 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to know if there are best practices from the perspective of designing qlikview model on a data mart built at SQL Server.</P><P></P><P>Is it suggested to create an denormalized flat table at Qlikview?</P><P></P><P>Kindly provide feedback on it.</P><P></P><P>Thank you.</P><P></P><P>Sincerely,</P><P>Harshraj Sanghvi</P></BODY></HTML> Mon, 24 Nov 2014 08:07:12 GMT https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805652#M1044529 2014-11-24T08:07:12Z Re: Qlikview on star schema https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805653#M1044530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See this: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4556">http://community.qlik.com/docs/DOC-4556</A></P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Mon, 24 Nov 2014 08:11:05 GMT https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805653#M1044530 daveamz 2014-11-24T08:11:05Z Re: Qlikview on star schema https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805654#M1044531 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can read some of this documents also</P><P></P><P><A href="https://community.qlik.com/docs/DOC-7454">The Optimal QlikView Data Structure</A></P><P></P><P><A href="https://community.qlik.com/thread/102887">Star Schema or Snow Flaxe schema?</A></P><P></P><P><A href="https://community.qlik.com/message/563248">What is Star schema in qlikview?</A></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 24 Nov 2014 08:17:01 GMT https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805654#M1044531 its_anandrjs 2014-11-24T08:17:01Z Re: Qlikview on star schema https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805655#M1044532 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Qlikview works better in Star Schema, because number of joined will be reduced during the runtime.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 24 Nov 2014 08:17:42 GMT https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805655#M1044532 jagan 2014-11-24T08:17:42Z Re: Qlikview on star schema https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805656#M1044533 <HTML><HEAD></HEAD><BODY><P>In QlikView 11 for Developers we can see all the best practices in data model.</P></BODY></HTML> Mon, 24 Nov 2014 08:18:29 GMT https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805656#M1044533 vardhancse 2014-11-24T08:18:29Z Re: Qlikview on star schema https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805657#M1044534 <HTML><HEAD></HEAD><BODY><P>Follow my post</P><P><A href="https://community.qlik.com/docs/DOC-4556">Best Practices for Data Modelling</A></P></BODY></HTML> Mon, 24 Nov 2014 08:25:16 GMT https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805657#M1044534 sujeetsingh 2014-11-24T08:25:16Z Re: Qlikview on star schema https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805658#M1044535 <HTML><HEAD></HEAD><BODY><P>Not always. Most of the times, yes, but not always. It depends on your data.</P></BODY></HTML> Mon, 24 Nov 2014 08:26:39 GMT https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805658#M1044535 daveamz 2014-11-24T08:26:39Z Re: Qlikview on star schema https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805659#M1044536 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this image for comparison between various schemas</P><P></P><P></P><P>Jagan.<IMG alt="Untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71924_Untitled.png" /></P></BODY></HTML> Mon, 24 Nov 2014 08:29:21 GMT https://community.qlik.com/t5/QlikView/Qlikview-on-star-schema/m-p/805659#M1044536 jagan 2014-11-24T08:29:21Z