topic help with data model for stocks in QlikView https://community.qlik.com/t5/QlikView/help-with-data-model-for-stocks/m-p/380642#M491404 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I need to create a data model for stock control .The database is from sage 200 .I have a query regarding this.The stock control module has Stock item,Bin Item and Warehouse Item tables and their quantities constantly change.I am creating a data model with dimensions on one side and all events on one side so should I create separate event tables for stockitem,binitem and warehouseitem or integrate all into one event called stocks.Will give you more information if you require.thanks in advance.</P></BODY></HTML> Fri, 24 Aug 2012 11:47:16 GMT 2012-08-24T11:47:16Z help with data model for stocks https://community.qlik.com/t5/QlikView/help-with-data-model-for-stocks/m-p/380642#M491404 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I need to create a data model for stock control .The database is from sage 200 .I have a query regarding this.The stock control module has Stock item,Bin Item and Warehouse Item tables and their quantities constantly change.I am creating a data model with dimensions on one side and all events on one side so should I create separate event tables for stockitem,binitem and warehouseitem or integrate all into one event called stocks.Will give you more information if you require.thanks in advance.</P></BODY></HTML> Fri, 24 Aug 2012 11:47:16 GMT https://community.qlik.com/t5/QlikView/help-with-data-model-for-stocks/m-p/380642#M491404 2012-08-24T11:47:16Z Re: help with data model for stocks https://community.qlik.com/t5/QlikView/help-with-data-model-for-stocks/m-p/380643#M491405 <HTML><HEAD></HEAD><BODY><P>I personally haven't worked with SAP but from personal experience a centralised fact table for item movement is fairly normal</P></BODY></HTML> Fri, 24 Aug 2012 12:05:30 GMT https://community.qlik.com/t5/QlikView/help-with-data-model-for-stocks/m-p/380643#M491405 2012-08-24T12:05:30Z