The Application Of OLAP In Decision Support System Of Postal Savings

With the development of modern financial industry, the management concept of banking has transformed greatly. Now banks gain benefits through providing customers with first-class financial service, rather than the deposit and lending spreads. The China postal savings face challenges of competing with the state-owned four big commercial banks as well as foreign banks. In the intense competitive environment, in order to master the market trends exactly, detain the financial customers effectively and provide the wonderful service pattern, the postal savings should speed up the development of data warehouse as well as the construction of the decision support system, so that the managers in the China postal savings can discover the valuable information from the giant customer database and carry out the management of the enterprise and some analyses.Based on the analysis of OLAP and DW, the essay mainly refers to the design of the decision support system in postal savings, especially the real problems of the application of OLAP to the decision support system. Also, it focuses on the calculation and optimization of the CUBE, the optimization of multi-dimensional inquiry and the realization of Component Object Model.Through detailed analysis and much research, the essay particularly explains the application of OLAP in decision support system and has come up with a solution, which is of much value and significance to the construction of the client management system in the postal savings.