Research On Financial Analysis System For Large-scale Construction Enterprises Based On OLAP

With the maturity of computerized accounting,the core function of enterprise financial work is turning to financial analysis and financial management. In this process,the original accounting oriented financial software has no longer fulfilled the enterprises'new requirements; therefore,how to achieve effective management and decision support based on the accounting data is becoming the focus of enterprise managers'attention.Aiming at large-scale state-owned construction enterprise,the paper firstly analyzes the present situation of financial analysis regarding large-scale construction enterprise,including the characteristics of accounting,as well as the process,characteristics and existing problems of current financial analysis. Based on this,the idea of applying OLAP and data warehouse technology to current financial analysis is presented,and its necessity and feasibility are discussed,also the advantages of applying OLAP technology are demonstrated.Secondly,the paper studies the diversified methods of financial analysis regarding large-scale construction enterprises,and their functions and purposes as well. Three frequently utilized financial analysis methods are briefly introduced,from which we choose the Dupont System of financial analysis as the comprehensive financial analysis. Combined with the actual situation of large-scale construction enterprises,this paper extends the structure of Dupont System of financial analysis,analyzes and discusses the frequently used financial analysis indexes.Consequently , Combined Dupont System of financial analysis with OLAP technology,the prototype of financial analysis system based on OLAP technology in large-scale construction enterprises is designed,including data model of data warehouse and multidimensional dataset of OLAP.At the end of this paper,we summarize the current study and propose the further research direction of this subject.