topic Help with removing synthetic keys in QlikView https://community.qlik.com/t5/QlikView/Help-with-removing-synthetic-keys/m-p/30959#M5140 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Can someone help me removing the synthetic keys from the attached data model ? I have 2 facts SPR and SPR Account , i have 2 dimensions Geo and TDM .. which has to be shared by both the facts.</P><P></P><P>Please help</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 31 Jan 2018 16:38:25 GMT stevejones1 2018-01-31T16:38:25Z Help with removing synthetic keys https://community.qlik.com/t5/QlikView/Help-with-removing-synthetic-keys/m-p/30959#M5140 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Can someone help me removing the synthetic keys from the attached data model ? I have 2 facts SPR and SPR Account , i have 2 dimensions Geo and TDM .. which has to be shared by both the facts.</P><P></P><P>Please help</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 31 Jan 2018 16:38:25 GMT https://community.qlik.com/t5/QlikView/Help-with-removing-synthetic-keys/m-p/30959#M5140 stevejones1 2018-01-31T16:38:25Z Re: Help with removing synthetic keys https://community.qlik.com/t5/QlikView/Help-with-removing-synthetic-keys/m-p/30960#M5141 <HTML><HEAD></HEAD><BODY><P>I doubt you need to remove that synthetic key for performance reasons. I reckon it'll be purely cosmetic.</P><P>See this blog post for more information: <A href="https://community.qlik.com/qlik-blogpost/3064">Synthetic Keys</A></P></BODY></HTML> Wed, 31 Jan 2018 16:54:10 GMT https://community.qlik.com/t5/QlikView/Help-with-removing-synthetic-keys/m-p/30960#M5141 Gysbert_Wassenaar 2018-01-31T16:54:10Z Re: Help with removing synthetic keys https://community.qlik.com/t5/QlikView/Help-with-removing-synthetic-keys/m-p/30961#M5142 <HTML><HEAD></HEAD><BODY><P>But if i want to remove how do i remove ? </P><P></P><P>Link table ? canonical Dates?</P><P></P><P>what is the best option and why ?</P></BODY></HTML> Wed, 31 Jan 2018 17:17:29 GMT https://community.qlik.com/t5/QlikView/Help-with-removing-synthetic-keys/m-p/30961#M5142 stevejones1 2018-01-31T17:17:29Z