topic MS CRM Data Modelling in QlikView https://community.qlik.com/t5/QlikView/MS-CRM-Data-Modelling/m-p/186238#M50407 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am urgently looking for some help with the modelling of my QlikView solution's tables, please.</P><P>I am extracting tables from MS CRM, but these tables have different relationships to what I'm used to. They seem to all link to eachother, or they are supposed to: Accounts to Activities, Activities to Opportunities, Opportunities to Accounts, Users to ALL.</P><P>I am finding it hard to come to a star schema, or any design that would not give me a loop, while still being able to provide what the users would want.</P><P>I have a solution in mind and will be testing it shortly, I just wanted to find out if there is anyone else out there that has also had issues with the modelling of MS CRM data in QlikView.</P><P>Please help!</P><P>Thanks!</P><P>Regards-</P></BODY></HTML> Tue, 29 Mar 2011 08:59:56 GMT 2011-03-29T08:59:56Z MS CRM Data Modelling https://community.qlik.com/t5/QlikView/MS-CRM-Data-Modelling/m-p/186238#M50407 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am urgently looking for some help with the modelling of my QlikView solution's tables, please.</P><P>I am extracting tables from MS CRM, but these tables have different relationships to what I'm used to. They seem to all link to eachother, or they are supposed to: Accounts to Activities, Activities to Opportunities, Opportunities to Accounts, Users to ALL.</P><P>I am finding it hard to come to a star schema, or any design that would not give me a loop, while still being able to provide what the users would want.</P><P>I have a solution in mind and will be testing it shortly, I just wanted to find out if there is anyone else out there that has also had issues with the modelling of MS CRM data in QlikView.</P><P>Please help!</P><P>Thanks!</P><P>Regards-</P></BODY></HTML> Tue, 29 Mar 2011 08:59:56 GMT https://community.qlik.com/t5/QlikView/MS-CRM-Data-Modelling/m-p/186238#M50407 2011-03-29T08:59:56Z