topic Re: Multiple Facts and Different Dimensions in QlikView https://community.qlik.com/t5/QlikView/Multiple-Facts-and-Different-Dimensions/m-p/435269#M1164485 <HTML><HEAD></HEAD><BODY><P>In Qlikview while doing the data model we should try to get the star schema so that the performance of the application is more. So if you have mulitple fact tables then try to make that as a single table either by joining or concatinating. And for dimensions based on the requirement join those dimensions individually to the fact table. hope this helps . If you have any problem while doing the data model try to post us a sample application so that we can help you with that.</P></BODY></HTML> Mon, 24 Sep 2012 19:47:27 GMT Anonymous 2012-09-24T19:47:27Z Multiple Facts and Different Dimensions https://community.qlik.com/t5/QlikView/Multiple-Facts-and-Different-Dimensions/m-p/435268#M1164484 <HTML><HEAD></HEAD><BODY><P>QlikView Version 10 x64 Edition.</P><P></P><P>We are migrating SSRS to QlikView.</P><P></P><P>Our SSRS Report consists of data from Multiple Facts and different dimensions having different granularity. How do I make this work in QlikView?</P></BODY></HTML> Mon, 24 Sep 2012 16:39:02 GMT https://community.qlik.com/t5/QlikView/Multiple-Facts-and-Different-Dimensions/m-p/435268#M1164484 2012-09-24T16:39:02Z Re: Multiple Facts and Different Dimensions https://community.qlik.com/t5/QlikView/Multiple-Facts-and-Different-Dimensions/m-p/435269#M1164485 <HTML><HEAD></HEAD><BODY><P>In Qlikview while doing the data model we should try to get the star schema so that the performance of the application is more. So if you have mulitple fact tables then try to make that as a single table either by joining or concatinating. And for dimensions based on the requirement join those dimensions individually to the fact table. hope this helps . If you have any problem while doing the data model try to post us a sample application so that we can help you with that.</P></BODY></HTML> Mon, 24 Sep 2012 19:47:27 GMT https://community.qlik.com/t5/QlikView/Multiple-Facts-and-Different-Dimensions/m-p/435269#M1164485 Anonymous 2012-09-24T19:47:27Z