The Application Based On OLAP Technology In Mobile BASS

On-Line Analytical Processing (OLAP) is a kind of software technology, which makes the analysts access the data conformably and interactively from many aspects, and observe the data deeply. With the increasing severity of the market competition, more and more corporations pay attention to the veracious and timely decision-making. Liaoning Mobile Limited Co. decided to build a Business Analyse Support System (BASS) to support the market decision-making and the management analysis. However, facing to almost ten millions of users and nearly 2.4 billion bill a month, it is an important question that how to realize the exact and flexible analyse rapidly. This paper is focused on researching for realizing to apply the OLAP on the business analyse support system of Liaoning Mobile.First, this paper analysed the status quo, characteristics and advantages of OLAP and the designing idea of the business analysesupport system of Liaoning Mobile, and introduced the nine models of the operation-analyse system on the main subject of users, operation, income, emulants, the service quality, marketing manage, VIP, new operation, data operation and coorperation service. The logical and perfect realization project of OLAP is put forware by introducing detailedly the realized steps of the OLAP modules of the business analyse support sysytem of Liaoning Mobile the main productive modules, the realization of the dataflow, the abstract, transform, load from source data and the transform process of the income subject Ods—St data. Further more, the frame of the business analyse support system of Liaoning Mobile based on OLAP is described clearly, as well as how to build a cube space is displayed vividly by a application fact.Final, this paper emphasized optimization of OLAP in order to resolve the conflict between the huge data and its exhibition. The system adopts the optimization of the source data, the memory, cube, parameters and other technical instruments so as to effectively decrease storage of data, reduce the dealing time and increase execution speed of the real time query and consequently achieve the satisfactory, rapid and flexible analyse-exhibition effect andsimultaneously put forward a method which settle how to use OLAP technology effectively to tackle the huge data in telecommunication industry.