SAP Action Note Creates a InfoCube: A simple sales business scenario

Hara po:http://blog.vsharing.com/eap/a822259.html

1. Creating data

Created four Excel tables, namely client, material, sales data, and sales organization. In order to keep the header consistent (because it is not clear how the BW Association reads), the header is in Chinese. The four table headers are as follows:

Customer ID/Customer name/customer address

Item Number/Item Name/Item description

Customer identification/Sales rep identification/Item number/sales unit/unit/Sales/transaction date

Sales area/Sales office/Sales REP/Sales Rep identification

2. Data modeling (see here is the original PO, but did not see the figure so just by its own literal understanding)

The InfoCube is modeled on a star-shaped structure. The fact table is in the middle, and the dimension table is around the fact table. "In this case, there are three dimensions of ' customer ', ' material ' and ' Sales rep ' (actually there are two common dimensions, ' time ' and ' units ')."

3.ETTL process

"1. When extracting data, complete the removal of data from the source system (for example, the R/3 system). The key to this step is to identify the right data, so a good understanding of the source data system is the basis.

2, data transmission, there are rules of different sources of data systems to move a large amount of data into the Data Warehouse, the key here is to plan a realistic data transmission plan, and has a reliable fast network.

3, data conversion, the data to be formatted, so as to ensure that the data in the Data Warehouse consistency. There are many challenges to be faced with, different names, different data types, different file systems, different file formats, and so on, all of which need to be handled correctly in data conversion.

4, data loading, is the correct and fast loading of data into the fact table. The key to this process is to develop a stable and good error handling program.

Ettl is a complex task that takes a lot of time. Any error can jeopardize the quality of the data, and the quality of the data directly affects the decision-making of the enterprise, therefore, for the Data Warehouse project, can be completed in the planned time and the agreed budget has a great challenge. ”

4. Create InfoCube

In BW, the customer's mark, item number, sales rep ID, Unit of measure, and transaction date become characteristic, and the Customer name and customer address are attributes of the customer's identity (although they are actually characteristic). The sales unit price, sales volume, and sales revenue are known as the main features (key figure), and the features and main features are called InfoObject.

That is, create seven characteristics and three key figure in a total.

Then create a infocube in the InfoProvider, in the design I put three key figures into the key figures folder, the customer, the item and the sales representative of the three ID into Dimension 1, and rename the dimension 1 is the ID or number dimension.

5. Load data into cube

SAP Action Note Creates a InfoCube: A simple sales business scenario