|
ERP was growed up on the basis of MRP II. For the optimal allocation resources of inside and outside the enterprises, realize the flow of information, logistics, capital, the value of highly integrated, is a key point of enterprise information in the last 10 years. SAP system which is the leading software of ERP. With the application of the in-depth, enterprise management will no longer satisfied with the existing use, thereby further stressed that the data analysis and decision support.The Decision Support System (DSS) is now to be converted to the business intelligence (BI). A good BI solution, the first of all is to build the data warehouse (DW), and based on this to do on-line data analysis (OLAP), data mining (DM) and the front-end display.This paper build the internal data warehouse system with SAP ERP system as the goal, based on the analysis of the business needs,such a sales forecast on sales, production and supply chain management, and other aspects of the theme of a typical launch. Through data modeling, data warehouse definition, and related technologies such as the use of SAP: BAPI, RFC, design ETL (data extraction, cleansing, transformation and loading) tools, from the ERP system to extract raw data, the processing load to Data Warehouse.For analyzing the current sales behavior’ s and predict the productive plan, the material demand rate of accuracy and so on enhanced several percent, and the application pattern has also made the primary study to the data warehouse in the enterprise, and made the preliminary technological strength for the next introduction business intelligence.
|