the data model issue can differ from one dashboard to another, ideally the star-schema model is the best one that compromise between performance/RAM usage and further maintenance on the schema.
however i cannot tell in your case, it depends on the size of dashboard and the need behind it, sometimes you cannot follow the star-schema perfectly and end up having a snow-flake data model.
i recommend checking the book Qlikview 11 for developers it will give you a very good insight on the data modeling and best practices.
i got 2 synthetic keys and i replace with key,zzkey both syn keys removed like f1 and f2 and f3 as key,
in same way i removed second syn key name is zzkey. now with addition of another table i am getting dottedline relation ship between zzkey and addition table name is 'pom'
table1: having fields key,abc
table2: zzkey,def
table 3 having def,key
here i am getting def relationship in dotted lines what i have to do?
i did here def as df and discoonected the relation ship between table2 and table 3
pls tell me ami correct ? is there any other way to do ? pls urgent?
