With the ERP-based data warehouse system, you can create a variety of business intelligence applications. For enterprises of all sectors and ERP system modules, external suppliers can be established analysis, customer analysis. Can be established within the production, inventory, sales, personnel and financial analysis systems, and these systems can be cross-analysis, for example, certain employees in a certain period of time of a customer's multi-dimensional analysis of cross-sales, but also some high-level data mining analysis.
Establish a data warehouse based on ERP issues requiring attention
ERP and data warehouse were established aimed at the enterprise transaction processing and decision-support phase separation; and both aimed at better integration of the ERP's transactional data and external data into information needed for management decisions. And able to multi-dimensional data, the depth of these excavations.
However, to truly build a good ERP-based data warehouse is not an easy task. ERP-based data warehouse to establish the problems faced by the whole focus on two aspects: First, how the transaction processing logic model and data warehouse model correspond to up, and ERP transaction processing and external data into the data warehouse, that is, the data warehouse building; the second is how to build a data warehouse based on the business intelligence to support the enterprise management decision-making activities, namely, data warehouse applications.
The general databases tables will reach thousands of copies to data from the ERP to migrate to a data warehouse to build such a data conversion extraction procedures are very difficult. In the establishment of business intelligence applications, such as the report query, multidimensional analysis and data mining, in line with the specific needs of enterprises and a number of high-level business applications provide features to consider, there may be specific to each sector needs to develop their own analysis of the corresponding applications.
Conclusion
As the ERP and data warehousing are nearly a decade the emergence of new information technologies, therefore, the integration of ERP and data warehousing research is not a lot. Some ERP vendors have also introduced some of their own products in order to provide this support, but these are some specific ERP product launch data warehouse solutions. This direction is the future of enterprise information technology application development a very important direction of research has broad prospects and application value.
|
