Financial Analysis System Based On Olap And Data Warehouse Technology

The goal of OLAP(On-Line Analytical Process) and Data Warehousing is to enable enterprises to gain competitive advantages by providing fast and better support of data analyses on data stored in corporate databases. At the same time, according to more and more perfect to the electronic financial account, the core function of the financial work is turning to financial analysis and financial management. In this processing, the original oriented accounting financial software can't suit to the new enterprise requirement. So it is becoming the enterprise manager's focus to how to implement effective management and decision support base on the accounting data. In this paper, the author develops a financial analytical system for enterprise. In this system he applies OLAP and Data Warehousing technology.In this article, the author attempts to apply the OLAP and Data Warehouse technology to the designing and developing of the financial analysis system for enterprise. He implements the system in two way: oriented KPI(Key Performance Index) and oriented data set. He implements the system in three layers: first, in the semantic definition layer, it establishes the data structure construct and semantic model; Second, in the data processing layer, it integrates the financial data and the other business data into the convenience analysis form according to ETL (Extract Transform Loading) action; Finally, in the presentation layer it implements slice, rotation and drill down/up action. So it meets the requirement of financial analysis and financial management for enterprise.In this article, the author explains the whole process developing and implementing a financial analytical system about requirement analysis, financial model design, function model design and so on. He finishes a lot of research and practice on the topic how to apply OLAP and Data Warehouse technology into financial analysis for enterprise.