Providing BI Plan For Small Corporations--Developing OLAP Exhibition Tool In Browser/Server Based On Analysis Services

In present, more and more enterprises have established business information system and accumulated huge amount of business data While a difficult problem confront these corporations' leaders that is how to discover the useful information in the data of disorder, which will be helpful greatly in customer relation management, decision-making and business affairs. How can we do? The answer is BI, Business intelligent, based on data warehouse, can satisfy all the requirements above.In the article, author made a deep study about how to realize BI in small corporations, and provided a BI scheme for them. The scheme will be introduced from the following aspects. At first, the author told of us what is BI, BI's development, its marketing and realization, also how to make it circulate very well and so on Secondly, author emphasized on data warehouse, which is an important part of BI, included how to establish data warehouse data structure in DVV and how to design it. In the third one, combined with Analysis Services, gave a particular description of OLAP, which is very important as data warehouse for realizing BI. Finally, developed an OLAP exhibition tool with B/S structure, and demonstrated the details of programming.The OLAP exhibition Tool, ProOLAP, is based on Browser/Server structure. With a simple designing, not required complicated installation and maintenance, by which the Users in client computers can browse business data saved in multidimensional database. The outer network and inner network of corporations can be linked up using the exhibition tool. In addition, the friendly interface of ProOLAP made it very direct and convenient when users look over business data and make decision.