A kind of encapsulation method and system of business intelligence etl

Abstract

The invention relates to a business intelligence ETL encapsulating method and system. The method can build a data cube customized by an ERP user based on a plurality of ERP data sources. Because industries, accounting systems, management systems, ERP suppliers, data source quantities and the like of enterprises are different, and the current situation of the business intelligence ETL field is that standard encapsulation is conducted on special ERP system universal part data, or IT professionals are needed to customize ETL logic in a database code level, so that realization and maintenance of ETL has little effect or high in cost, and the popularization of business intelligence in the ERP systems of middle and small-sized enterprises is greatly restricted. By means of the method and system, a common ERP user does not need the assistance of the IT professionals and can complete establishment, configuration and construction of a business intelligence database and renewal of the data cube for business intelligence analysis. Related articles of the financial statement in the business intelligence ETL encapsulating method and system are not found through Chinese and English retrieval.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a business intelligence ETL packaging method and system. Background technique [0002] ETL (Extraction-Transformation-Loading, Extraction-Transformation-Loading) is an important part of BI (Business Intelligence, Business Intelligence). Since BI presentation tools (such as: Tableau, MicrosoftBI, Qlikview, etc.) are very mature and perfect, a business intelligence The implementation period and effect of the project are largely determined by the design period and effect of the ETL module. If the data required by the enterprise cannot be accurately extracted and stored on demand, then the business intelligence project will inevitably become a mirage. [0003] The inventors found that in the existing practice of business intelligence, there are the following problems: due to the different industries, accounting systems, management systems, ERP system suppliers, the number of data sourc...

AI Technical Summary

Problems solved by technology

[0003] The inventors found that in the existing practice of business intelligence, there are the following problems: due to the different industries, accounting systems, management systems, ERP system suppliers, the number of data sources, as well as the customer's focus and analysis mode, etc. , business intelligence projects are usually project-based delivery, that is, according to the analysis purpose of the customer, design a BI analysis model, and according to the analysis model, professional IT personnel write code to implement ETL, and maintenance also needs to be implemented through code

[0004] In the field of ERP business intelligence analysis, due to the professionalism of the ERP field, especially the financial field, it is usually difficult for IT personnel to understand the professional knowledge of ERP, and ERP users are usually unable to master the IT code language required by ETL, resulting in technical barriers and problems. Communication barriers lead to a long implementation period for the ETL part of the business intelligence project, difficult data proofreading, and unsatisfactory results. It is also difficult to adjust and maintain the business intelligence system after it goes online. Even changes to ERP system data may lead to hardened ETL modules that are hard to find Errors, the ETL code needs to be modified from time to time to execute the ETL logic correctly

The current situation of the above-mentioned ETL has led to high implementation costs of business intelligence projects and difficulties in popularization

Images