https://community.qlik.com/t5/QlikView/Fact-Table-and-Slowly-Changing-Dimension/m-p/202528#M60190 <HTML><HEAD></HEAD><BODY><P>I have build a Fact table for a CRM system. See the image below. <IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-800_sourceID:800" /></P><P>I have two problems:</P><P></P><OL><LI>The field "Accountmanager" in the table "Company" needs to be a Slowly Changing Dimension (type 2)</LI><LI>I need to keep the history of every sales record to determine the average sales cycle</LI></OL><BR /><BR /> <P>I found an example (<A href="https://community.qlik.com/forums/p/21690/83004.aspx#83004" target="_blank">see this thread</A>) which I think I can use for problem 1. But I don't know how to implement it in my existing datamodel.</P><P>Anyone who can help?</P><P></P></BODY></HTML> Wed, 06 Jan 2010 12:36:08 GMT dpietersz 2010-01-06T12:36:08Z https://community.qlik.com/t5/QlikView/Fact-Table-and-Slowly-Changing-Dimension/m-p/202528#M60190 <HTML><HEAD></HEAD><BODY><P>I have build a Fact table for a CRM system. See the image below. <IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-800_sourceID:800" /></P><P>I have two problems:</P><P></P><OL><LI>The field "Accountmanager" in the table "Company" needs to be a Slowly Changing Dimension (type 2)</LI><LI>I need to keep the history of every sales record to determine the average sales cycle</LI></OL><BR /><BR /> <P>I found an example (<A href="https://community.qlik.com/forums/p/21690/83004.aspx#83004" target="_blank">see this thread</A>) which I think I can use for problem 1. But I don't know how to implement it in my existing datamodel.</P><P>Anyone who can help?</P><P></P></BODY></HTML> Wed, 06 Jan 2010 12:36:08 GMT https://community.qlik.com/t5/QlikView/Fact-Table-and-Slowly-Changing-Dimension/m-p/202528#M60190 dpietersz 2010-01-06T12:36:08Z