| The competition becomes more and more drastic in rag trade. The domestic enterprises faced to many problems such as how to integrate various informations in industry chain effectively. As the scale of enterprises become larger. The problem that how the operator provide the right information at the right time to the decision-makers in the enterprise and how the decision-makers get the right information exactly will become more urgent and complicated.As the rapid development of information technology and the demand of enterprises become more diverse and complicated. The technology of data warehouse is presented. Data warehouse provides a data platform. We can do data analysis, data mining and report processing to support the decision-making based on this platform. Although many enterprises provide solutions of data warehouse, the research of this technology is still going on. OLAP is the typical application of data warehouse. It can process the data in the data warehouse to show the multimensional data view to users. At the same time, OLAP provides the more convenient operation including slice, dice, drill and so on. The users can observe the data from different levels.First, this papar set forth the background of research and summarize the current research, discuss the target and meaning of this research. Then, through integrating the achievement of many scholars' research. The author analyzes the theory of data warehouse and OLAP as well as the relationship among data warehouse, OLAP and data mining. Based on this research and coinbine the background of rag trade and demand of a certain company, the author bring forward a whole solution of the sales management system based on OLAP. This solution contain two parts: one is sales management system (OLTP) another is sales OLAP analysis system based on WEB. I constructed the whole structure to ensure the practicality and technic feasibitiy of this system. After that, the author use Visual Basic.Net and SQL Server 2000 develop and realize all function modules. Based on this system, the author use ASP, MDX and ADO MD develop and realize the sales OLAP system. Finally, the author analyzes the effect of system application.The main contribution of this papar is researching the application principle of data warehouse and OLAP in the sales management system based on the demand of a certain company in rag trade in our country, setting up a data warehouse's 3 level models and 4 topics of dimensional analysis models, providing a whole solution of sales management system based on OLAP and finally developing and realizing the system. The achievement of this research supports the decision-making in sales and marketing, assists the decision-maker establishes the right strategy. Especially, it improved the decision level and marketing competitive capacity of the companies' sales and marketing business. The achievement of this research has a certain reference value of implementing the data warehouse solution in rag trade or other industries. |
