Multidimensional Sales Analysis System Research Based On OLAP

In recent years,with the booming development of IT science,such as mobile Internet and Internet of things,the data volume accumulated in enterprises increased sharply,it is no doubt that this will generate huge impact on management accounting information,wise management decisions are so significant for the improvement of enterprise operating performance and its long-term development.Then enterprise management accounting confronted a common problem,that is how to analyze and extract the useful information from a large amount and seemingly haphazard data for enterprise operation and management decisions.Because of this,the comprehensive guidance of the construction of the management accounting system was released by ministry of finance in October2014 and series interpretation of guidance were followed,these files emphasized the importance and urgency of building management accounting system and encourage enterprises to use information method to give full play to the value of management accounting in enterprise management decisions.Take retail chains enterprise as an example,in a company with several hundred stores,tens thousands kinds of commodity,how to get better sales performance is one of the main targets.Choose the right kind of commodity to sale,how to grasp the sales trend,when to conduct sales promotion,how to arrange purchasing and inventory reasonably in order to deal with the sales of periodic characteristic,these are the crucial questions must be answered because they all have a significant impact on operating performance of enterprises,so it is vitally important for decision makers to conduct accurate and quick sales analysis,so managerial personnel’s can understand the operating situation clearly and then make a right decision.This paper proposed to build a multidimensional data analysis system based on OLAP,a new solution to solve these problems,when the multidimensional data analysis technology was applied to the retail chain sales management,management personnel’s at all levels can analyze and mining sales information quickly and accurately from multiple dimensions so as to assist decision makers to make right marketing decisions.The first part of this paper elaborated the selected topic’s background,importance,research overview,both at home and abroad,the main research contents,methods,innovation points and technical route.The second part summarized the relevant theory including supply chain process management,sales forecast,data warehouse,OLAP(on-line analytical processing).The third part first elaborated the analysis and designprocess of data mart model from the perspective of management accounting,historical sales data analysis and sales forecast,then completed data mart ETL(extract,transform,and load)by developing an ETL system based on Powerbuilder 9.0.The fourth part elaborated the realization of slice,cutting,drill and rotate multidimensional sales analysis based on the most advanced business intelligence(BI)software platform-Analyzer,and then explored the impact of multidimensional sales analysis laid on sales decisions from the side of supply chain process management and sales forecast.Multidimensional sales analysis can assist policy makers to formulate and adjust marketing,purchasing and inventory management strategy,so as to improve the efficiency of the supply chain process management,reduce the management cost,and realize the purpose of supporting sales decisions.Besides,it can provide accurate predict foundation for sales forecast and help decision makers to predict commodity market demand,This will help to reduce the uncertainty of understanding of the future market activities and management of blindness,then assist decision makers to make reasonable sales decisions and improve enterprise’s economic benefits eventually.The fifth part summarized and reviewed the research achievements and insufficiency of this paper,provided feasible suggestions for future studies in the end.