Research Of The Application Of Multidimension Data Analysis In The Medium And Small Enterprises Based On OLAP

The information technology makes the quantity and the capacity of the Database more and more stupendous, people always found them lack of helpful information . Business intelligent which is an effective solution of the Businesses, makes an important role. For the minor enterprise, the well and applicable solution can help it to get helpful information to raise the profits, and save the costs on the other hand. so it make sense to research the application of Business intelligent in the minor enterprise.The article gives the concepts of the DW and OLAP, expound the development and the current situation of them, through to compare the DW and the traditional Database, The article points the fault of the traditional Database in the process of analysis and strategic decision, indicates the importance of the using of OLAP in the DW.The combination of OLAP and DW is an important research orientation of DW, the article researched the multi-dimensions of the data processing method, and proposed a new OLAP solution, this solution recur to the inherent database, with the detailed analysis and according to the design proposal of DW , through organization and processing, makes the original data integrated,consistent,detail data to establish decision analysis system to the minor enterprise. to do this can satisfaction the wants of different enterprise and save the costs of the minor enterprise at the same time.The article combines with the actual project ProductXSFX, expounds the process of its design and realization, and also gives the application result, inspect and verify the feasibility of this solution.