Design And Implementation Of HANA Integrated Query System Based On Asset Lifecycle Management

Petrochina Marketing Company Petroleum oil and gas enterprises belong to asset intensive enterprises,pre built asset lifecycle management system to effectively alleviate the asset management due to lowering the efficiency of the pressure,and very fruitful in the assets of the whole process,comprehensive and meticulous management and improve the petroleum enterprise asset management and overall operation quality and benefit.As a sales unit,one of the main units of oil companies,its asset management types,a wide range,large stock,chain length,involving more professional,making asset management difficult and effective pressure.In order to support the formation of corporation strategy,planning,execution and control assessment of the closed-loop management environment,promote the upstream and downstream business collaboration and data sharing,realize the production report in accordance with the regional corporation needs automatically,then enhance the management personnel of all levels of daily work efficiency,implement an interface operation,excellent asset management system,to strengthen the assets management is very important for improving the economic efficiency of the oil companies.The thesis is based on the asset lifecycle,enterprise resource management,project management,system engineering theory arid some basic theory,using quantitative and qualitative methods,the practice and theory of combining research in petroleum enterprise asset management and control integrated query system implementation.According to the actual needs of enterprises,first has carried on the design of business process,and through the analysis of petroleum enterprises to realize the asset lifecycle management period,in ERP2.0 based on ERP1.0(Enterprise Resource Planning)system based on switching,through the analysis of assets linked to the feasibility of the platform platform integrated query system HANA,developed a comprehensive and detailed implementation plan.Finally,the implementation effect and key factors of success are summarized.Firstly,this paper expounds the research background of the system,the research status of the whole life cycle of the sales unit,how to use HANA to achieve system query optimization,and the main work of this paper.Each of the two aspects of business and technology needs analysis,to seek out a system;then BIEE architecture design,business logic and review financial statements and asset master data BW model of system design;detailed implementation of permissions design,integrated query system query statements and other functional modules,including interface,the operation data and key process code;describes the test results of software testing and the structure adjustment plan,and summarizes the problems existing in the system and the next step of work.Finally,the whole process of system requirement analysis,system design and system implementation is summarized,and the system is prospected according to the field application.The implementation and application of the HANA real-time query system can provide a shared,timely and real-time comprehensive platform for the oil enterprises to query the assets and performance monitoring.On the one hand,it strengthens the management of assets and improves the economic benefit of the oil enterprises.On the other hand,it improves the efficiency of the user's end of the month asset query.Rate and level,and has been recognized by the majority of business office staff.