The Design Of Manufacturing Bom-based Business Intelligence System

With the increasingly competitive business, how to properly and timely to changing market conditions and business situations to make business decisions is placed in front of all the company's management is an important issue. With the deepening of global information, more and more manufacturing companies to implement the ERP (enterprise resource planning), CRM (customer relationship management), SCM (supply chain management), EIP (Enterprise Knowledge Portal) and other applications, has been gradually formed the basis of its own database. How to integrate these basic data, mining and refining, for corporate management to business analysis and decision-making, has become the development trend of enterprise information. As a result, business intelligence applications in manufacturing organizations become more and more attention to the manufacturing sector, has become an important direction of development of the manufacturing business intelligence to optimize business management and better use of internal and external information source. Manufacturing the product structure can be used to describe the concept of the tree, the final product must be from a fixed number of parts or components, these relations are very clear and fixed. ERP is to achieve an effective tool for enterprise information. ERP system bill of materials (BOM) is a technical description of the product structure file. Is the main carrier of information transmission, it manages the technical documentation is the core data. Through the excavation and use of BOM. Can effectively manage and utilize a variety of businesses over the years accumulated historical data, statistical information.Manufacturing ERP system in this paper, a list of materials (BOM) of the features and business intelligence applications in manufacturing, the manufacturing sector is given a suitable model for the application of business intelligence and data warehousing in the BOM based on the use of SQL Server tools to realize the 2005 multi-dimensional analysis of manufacturing information and online analytical mining. Data mining association rule mining is the main technology, based on purchasing BOM, found that supplier relationship between the characteristic attribute is a scientific and feasible, based on this thinking, combined with the cost of manufacturing BOM for the display and control of procurement costs is a novel and effective research methods.Finally, to enable managers to better understand the data, the deep significance of the data for better analysis, the use of C # language with Microsoft SQL Server 2005 Analysis Services API for multi-dimensional analysis of the results are displayed with the query.