three. CIF Case - SAP BW
The main feature is that ERP vendors provide the entire architecture, which saves a large number of design work and reduces the cost of design and development, and encapsulates the business package in BW, reducing long-term maintenance. ERP's data resources are very rich and valuable. It should be an important source of data warehouses. SAP BW is to incorporate data warehouses into ERP applications.
SAP BW Overview
a. SAP BW History
The following is a brief version history of SAP BW
· BW 1.2B - InfoCubes and And Business Content
· BW 2.0B - introduced ODS
o mysap.com interface
· BW 2.1C - Analysis Components
· BW 3.0 - As the analysis of the analysis application is enhanced from the ODS to the data warehouse.
From the short development history of SAP BW, it is gradually and perfect, getting closer to the architecture of CIF.
SAP BW and business framework
b. Basic structure
SAP BW products have been this point that provides a unified data platform, on the one hand, from R / 3, CRM, B2B, APO (Advanced Excunization Plan) to obtain data supply, and with KM (knowledge management) constitutes business Intelligent elements. From the basic design idea, it is an implementation of the CIF. SAP BW can also access users from the web, and BW allows enterprise users to access from Portal.
2. SOURCE SYSTEM for SAP BW
Source Systems is a SAP BW data provider, a referenced system.
Source System has four kinds of SAP BW:
MySap.com components, SAP BW Completely integrate with MySap.com world, it is transmitted as a central data warehouse tool, predefined extraction structure and program (also a data source) by SAP, which makes the data source by mysap.com The components directly load SAP BW.
A great advantage of SAP BW is that it has an open architecture to apply external OLTP and other legacy systems.
Data Provoider: Get data from different systems, SAP BW provides an interface that exists existing external systems.
Database: Database of an external system.
3. Application implementation of SAP BW.
a. Info Source, Info Object, Info Provider Info Object
SAP BW system sect
As shown, Source System will provide data for Info Source, and the data information of Info Source is expanded in digital structure, which is open in our application. Info Object is the minimum data unit in SAP BW, which is obtained from the Info Source.
Info Provider is the container of Info Object, all OLAP applications are obtained by INFO Provide. The data can also be tissue in which the dimension modeling is performed so that the OLAP query.
b. SAP BW ETL.
SAP will also be part of BW as a BW component. The following is a data extraction flowchart. The most original data can come from the file or from the My SAP R3 system. There is a copy of the transfer structure in Infosource, then pass some rules (sometimes Common) Go to Communication Structure, then reach Cube, Info Object, and other target data by some rules.
Data extraction flow chart
We can also define some rules to extract data.
Define transmission rules
Although SAP BW is not perfect, if the function of ETL is not strong enough, the support for external systems is also very limited, but its architecture is getting closer and closer to the framework proposed by the CIF. I believe that it will continue to improve, which can make DW potential Fully exerted. However, few architectural providers will be a serious crisis for companies to maintain advantage in era, the company's strengths.
four. Data warehouse integrate with enterprise applications.
The demand for changes and integration of your decision support environment is an exponential growth. This century is recognized as a "information age" and information will become the most important strategic enterprise resource. The company must use this strategic resource as a change of management models, renewing work, and how to expand internal business processes and cooperation with suppliers, partners and customers.
The world has experienced various systems such as MIS, MRP, MRPII, SCM, ERP, CRM, play an important role in addressing information management issues in different periods, and how to deal with more complex information management problems in the 21st century, such as one Information integration, information sharing within the enterprise, information sharing; system integration established in various phases in the enterprise. These seamless integration of information with different sources is obviously difficult. Therefore, the emergence of the new information management system in the 21st century.
1. Information integration and sharing within the company.
Traditional enterprise application
As shown in the figure, traditional applications are independently developed before and after, without rarely considering their relevance, in a sense, they also constitute a "corporate information factory", but they are independent, without implementing information shared. This leads to incompleteness and non - conceitment of data and affecting the anti-exhibition of the company.
Application internal contact and information sharing
In fact, the business is interrelated. For example, a customer first visits the web page, then use the order system to book the goods, the order passes through the sales system, and the financial system starts to start, the inventory system needs to confirm the order information, and then arrange delivery And distribution matters. The financial system will handle the financial system after the transaction is completed. In this process, corporate information entities include customers, products, and transactions. If companies need fast corresponding customers and market needs, they need to put them together. If we have two two two two two two two two two two two two two two two two, it will be very high. However, if we can take into account those cross-core entities when designing applications, on the one hand, the information is consistent, and the design can be reused.
2. Information integration and sharing between enterprises.
The second level of information integration is the information integration between enterprises, which is based on the information integration within the enterprise.
The real information sharing between the company and the partner is shown. In order to meet the requirements of the reflection within the shortest time, an architecture that supports the partner sharing core entity is an inevitable and reaches high accuracy.
3. Integration of data warehouses and enterprise applications.
The CIF consists of many existing interior consistently related to each other, so that the CIF is running normally, and each component must be built on a consistent frame. In the field of CRM, e-commerce and ERP, the process is based on data collection. Data can enter enterprise systems through a variety of contact points. Data collection points in the initial operating system will become a client data gateway entering the enterprise. If defective data enters this contact, it can be transferred to all shared operating systems, including decision support systems.
Enterprise Information Factory (CIF) structure can be used to plan establish and maintain a successful enterprise data basis (Figure 1). When the business process develops to the need to support new, dynamic Business Intelligence (BI) and Customer Relationship Management (CRM), the function becomes more unstable, and it is difficult to understand and complicated. Fundamentally, this integration and extension will penetrate the complete innovation of the management system and business processes.
To develop enterprise applications, considering data integration and future effective use of data in the future, avoid information island. The trend of modern enterprise information development will be information integration, business intelligence and rule system. Enterprises face the changing environment, which should make full use of the effective resources - data, many successful ERP systems, such as SAP's BW and PeopleSoft's EPM. Although the technology used by SAP is not the most advanced, the R3 system considers the application's system integrity and information integration integration and noticed the huge potential of the data warehouse and the design of this product, making it in the market. The aircraft. Fives. summary.
When developing enterprise applications, you should first consider from your system and overall perspective. Considering the integration and sharing of information, do a good job in long and overall, with an ancient story, you can explain the arguments of this law. Three blinds encountered an elephant, and everyone screamed. The first person grabbed an ears of elephants say: "It is a big and rough thing, and it is wide and broad, like a carpet." The second person held the elephant's nose: "I touched It is the truth of the truth, it is a steward of the hollow. "The third blind man holds an elephant front leg saying:" It is strong and solid, like a column. "These three blinds and many companies The supervisor of manufacturing, marketing, and research has the same point. Every executive clearly sees the company's question, but there is no one to see how its department's policy interaction with other departments. According to these people think, they will never know the whole picture of an elephant.
Enterprise data is an elephant, and CIF will use the producer and consumer information in a system, reliable, accurate, unified and timely manner, let us see the overall sight of the company data. .
References:
Master the SAP BW.
Systematic thinking introduction (Winberge)
SAP BW CASE STUDY.
Building Data Warehouse -inmonMon
Data warehouse- using the wal-mart
ERP & CIF (Inmon)
CRM & CIF (inMon)
The corporate information factory and
Enterprise
Infrastructure (inMon)
