Research On Application Of Online Analytical Processing Based On MS Analysis Services

With the development of science and technology, people's requirement for the obtainment, processing of information becomes higher and higher, DSS arises at the historic moment. Data warehouse and Online Analytical Processing technology are two new-type decision supported technologies. Data warehouse is a kind of data administrative technology, which emphasizes on the integrated data-facing theme, so it can offer more effective support for making policy and analysis. OLAP is a kind of multidimensional data analysis technology, which emphasizes on the data analysis in data warehouse, and provides aid decision information for managers. These two kinds of technologies are combined mutually, which open up a new way for DSS. They are also received more and more concerns now.This paper begins with the relevant basic technology about data warehouse and OLAP, then sum up and analyses the methods of optimizing the performance of the two technologies. These works are prepared for the following OLAP application.The MIS of Chonqing Liangbai Limited Company has completed for about three years. The company urgently needs a OLAP system to analyses the large amount of data in the database and provide effective information for decisions. In the OLAP system developed for the company, Microsoft SQL Server 2000 and Analysis Services are used for database development, and VB6.0 is used for UI development .In the processing of development, relevant technologies of application of OLAP are summarized.Finally, a General OLAP Data Analysis System is given on condition that the data warehouse and the MD-database are built in advance. The frame of the system is composed of UI layer, application server layer, OLAP server layer, data transformation services layer and operation database layer. The DTS and the achievement of user's query are the two important parts in the system. Their frames of how to develop are also put forward. The purpose of the research on the General OLAP Data Analysis System is to provide a flat on which companies can easily accomplish all kinds of analyses.