The Research Of Application Business Reporting Data Based On Data Warehouse Technology

In this paper, We discuss and research the Audit services which is based on the data warehouse technology. Based on the Audit services research focus on the existing data source, and which developed ETL, multi-dimensional data model, application functionality and other research. All the above research will have some specific reference effect to the system practice.With the rapidly development of information technology, enterprise information has become a concept of core competence. And how to effective management data which is got from operating process, to provide a basis for decision-making. It is a important subject of information management.Since1970, facts and information database model has become the mainstream of database management. But this kind of model which is rapidly response to the service as target, there are some deficiency for application of the subject-oriented database analysis.Therefore, it is very difficult for building analysis business system which is based on the fact and information database. Data Warehouse emerges as the times require. Now, Data warehouse has entered a rapidly development process. When the modern enterprise has taken the value of information, data warehouse has become a necessary choice.If an enterprise hope to win and take the advantage position in the fierce competition, it must find internal rule and values information from huge data though the complex and changeful environment and make a oriented make-decision and at the same time execute it through contrast, analysis ways.The more and more information demand from business caused the database warehouse rapid development.From2006, CNPC has set up data warehouse system and accomplished the second phrase. The article will focus on the how to build auditing business data warehouse which has been accomplished. Data warehouse provide data support for the auditing business, and make the financial and audit management data into the value information and knowledge through high level analysis, automatically and intelligently ways ,which is a effective channel to realize audit business information.