I am urgently looking for some help with the modelling of my QlikView solution's tables, please.
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.
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.
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.
