The Research And Implementation Of Oil Manage Analysis System Based Olap Technology

The oil management enterprise's data quantity is quite big .if we use the manual method to collect data and carry on the analysis, we will waste much time, manpower and many financial resources, which affects the benefits of enterprise in great degree.This project designs and finishes a business analysis system according with real situation of the enterprise, which solves the problem barreling the enterprise's development. Firstly, the paper introduces the research background and the present development situation of local and foreign country, and discusses the data warehouse and the principle of OLAP technology. Then the paper introduces the implementation of this system in detail. This system uses MS SQL Server 2000 Analysis Services to build sale analysis, store analysis .etc, all six subject field. It Uses the data transformation services to input and output the data and does schedule automatically. In the process of transformation, the system can identify, wash and transform data. After the analysis to the MDX query technology and OLAP dimensional analysis approach, we can make decisions and analysis aiming at the data in the data warehouse. The system can carry out the multi-dimensional cube design, the maintenance and renewal of data, the multi-dimensional analysis operation. At last, we can show results using the PivotTable Services.The system applies simple operation, stable movement and the great capacity, which satisfies all level departments' needs for the report-creation and the data analysis. Finally, the system does the decision-making scientifically, enhances the enterprise's benefit and improves the management level. The conclusion shows that the result of analysis can give powerful support to managers' decisions.