Research And Application Of Decision Support Techniques In ERP

Enterprise information construction is growing faster and faster due to rapid development of information technology. Enterprises not satisfying with the business-based simple data processing propose a business intelligence demand for development guidance by digging knowledge out of data. The concept of decision support is just for this demand. Decision support can transform the huge and complicated data into knowledge so as to assist the decision making of business management, even to make business decisions automatically. So decision support has become an aim enterprises competing for.The technology of decision support includes Data Warehouse, OLAP(On Line Analytical Processing) and Data Mining. Data Warehouse integrates the data distributing in all parts of enterprise, and prepares a large scale of effective data for decision making. OLAP can analyze the data from different points and provide global view of enterprise's data for its managers. Data Mining digs valuable patterns and relations behind figures out of enterprise's data, so that it can offer some reference for the managers.This paper is based on the practical demand of one printing and dyeing company in Liaoning province. It properly processes the historical data, and integrates the data with a suitable mathematical model. Finally by the key technology of decision support, it constructs an analysis model of historical sales and a prediction model of new breed profit and, embeds theses models into the company's ERP system.The managers of the enterprise can use the analysis model to analyze dead or peak season of a breed to grasp information about different breeds' needs among different customers so as to make correct sales strategies, like periodical promoting sales, customer contact etc. The prediction model can be used before development of a new breed to predict sales prospect and profit so as to help decide weather or not to invest in this new breed.The models solve the problem that managers make decisions only by their own experience rather than data support. Results show the correctness of decision making improves greatly after using these models which proves that the models provide a powerful support for the company to make right development strategies.