Developing Online Analysis Process Program Based on Analysis Service

This paper discusses the necessity of developing online analysis process program and the OLAP environment in Microsoft analysis service.Based on analysis service,this paper details how to develop online analysis process program with Multi-dimensional expressions combined with ActiveX data objects(Multidimensional),including building OLAP database,connecting to the OLAP database and executing MDX query.