Bi and ERP are complementary systems

  • Detail

Bi and ERP are complementary systems

how can new architecture systems such as business information (BI) and decision support generate new attraction to users in just one sentence? Bi is based on ERP, while decision support is a re extension of Bi. In other words, the new architecture enables industry users to create a "virtual" enterprise on top of the existing enterprise data warehouse. What does this mean

simply put, industry users can integrate existing data warehouse resources into a distributed Bi network environment. Like ERP, it is a top-down perspective. It can improve the implementation potential of relevant business goals of industry users, and allow users to reorganize a department level operation process in which the spindle line of a more refined flat cord section should be parallel to the swing shaft 103 line; Then create a real-time monitoring system for the implementation of the goals of the whole company

bi vs erp

it is quite economical to install data warehouse in ERP environment. Because, from the perspective of infrastructure, Bi database and ERP have a lot in common. Both of them use distributed architecture to store massive data, so there is a great possibility of integration between the two sides; Both provide deep access for a wide range of end users; Both have a high degree of distribution and application scalability, although this feature is not obvious in Bi; Both are based on the same premise. That is, use direct or indirect data as the information reference of prediction work

in the past 10 years, ERP technology and Bi have made significant development, but their development paths are more or less parallel. Both of them rely on information technology for their business judgment ability, but their functional characteristics are aimed at different aspects of business intelligence and performance tracking

although there are similarities, Bi and ERP are definitely not the same thing or two aspects of the same thing. They are complementary systems

their biggest commonality is that they make enterprises run more efficiently, respond more timely and integrate easily. Therefore, it is obvious that enterprises that have implemented ERP need Bi

raise user expectations

after the implementation of ERP by industry customers, a new business processing mode has been established. All business processes involved in ERP system are integrated and coordinated with each other, breaking the original division of departments. The information acquisition ability of all links in the company has been improved, the business processing bottleneck inside and outside the enterprise will be broken, and the response speed will be improved accordingly

bi can improve the information acquisition ability and control accuracy of industry users in key areas. First, the report format will be greatly improved. The integrated user data will undoubtedly make the report faster, more timely and more accurate. Secondly, information transmission will also be more and more real-time, and the turnover time in various departments will be greatly reduced. Finally, the problems and mistakes that may occur in the business processing process are also easy to find in time, so that the error correction work is more rapid and accurate

through Bi, isolated and scattered enterprise data are related to each other in the order of historical records, and can be stored in an efficient and easy to extract structure; Therefore, industry users can conduct rapid analysis according to different perspective methods. Unlike transmitting data, once information enters the data warehouse or local data mart, it cannot be changed. It becomes analytical data, not transmission data. Therefore, the analysis that industry users can do is no longer a simple summary. They can analyze the data in any depth according to their own analysis methods. This data warehouse is organized in a fast, flexible and variable form, and data access becomes extremely simple (users can access it without special application software, just as convenient as taking down a book from the bookshelf)

determine the business theme

the next step is to redefine the information and its application methods. Old concepts such as records and documents have become obsolete. However, since the application system migration of industry users, the change of ERP database application environment has not changed this mindset

in today's world, industry users are facing a new competitive environment, that is, a world in which business objects are accurately achieved. The executive power of business objectives does not depend on the difference of time or management level. Whether this objective is being implemented or has been implemented, it should be conveyed to all levels of the enterprise, such as department level, company level, etc. The realization of each small goal may have a big driving force for the whole company

business objective is actually an information "package", and its role depends on how industry users define it and how to deal with it. Industry users can regard it as a virtualized employee and give it specific job functions, that is, it can be competent for various applications

in order to understand business goals, we must first know the concept of metadata. Metadata is a kind of information used to describe actual data; It is mainly used for data exchange in applications and analysis processes. Metadata is a basic material for building databases, which will be used to build BI data models

business objectives are not only a template for information, but also define the business tasks that can be completed by data information and the tasks of the main executors (from this level, business objectives are a virtual employee). Here, the simplicity of defining a data model does not affect the effective measurement range of experimental force: 2% - 100% FS; Some are exaggerated. The end users involved in the data warehouse can get these task information; The middle managers of each department can set up the required analysis functions by themselves; So as to break the limitations of department segmentation and help the decision-making level to manage. Just imagine, if a company CIO uses the "cost accounting" theme report for local inventory transportation cost analysis, and a grass-roots warehouse keeper can also use it in time in his job, then the timeliness and accuracy of the company's commodity transaction information will be greatly improved. This CIO can determine in a timely manner whether the company reduces the number of products in the company's catalog

how to realize

when actually building the system, industry users don't have to worry too much. Bi can start with a very small system, and it only needs to add information to ERP instead of rebuilding a system. The uniqueness of Bi platform is that in a highly integrated ERP environment, it is usually hidden at the bottom. For simplicity, the main data source of Bi is undoubtedly ERP database. This will also provide inexhaustible development momentum for the extruder industry. Bi is a well-organized table driven system. In the system, ERP database and ERP application system are closely combined through the interface, and metadata flows between them; Extractors extract the appropriate information from the transmission system, and then put the information into the business goal oriented database system (the programming interface API also works at this stage)

next is the Bi engine, which includes information source management and conversion system, loading system, etc. The information source management system is mainly used to track where information comes from and where it goes, and it also defines all transmission activities; The conversion and loading system is mainly responsible for the necessary data standard operation. Then there is metadata, which is a series of information definitions using functional terms. From here on, advanced functions such as modeling, analysis, and related topic display begin to run. It must be emphasized here that the information in the data warehouse is mainly used for data analysis, and it cannot be modified or upgraded by Bi users. (end)

Copyright © 2011 JIN SHI