Creating an InfoSource for Characteristic Data

In Chapter 1, we learned that ETTL is a challenging task. BW uses InfoSources and transfer rules to define the mapping and transformation rules that govern the ETTL process.

In this section, we use IO_MAT as an example to show how to define an InfoSource and transfer rules for characteristic data. In Section 3.6, we will discuss how to define an InfoSource and transfer rules for transaction data.

Work Instructions

Step 1. Right-click the newly created Application Component demo, and then select Create InfoSource….

 

 

SCREEN 3.7

graphics/03fig07.gif

Step 2. Select the option Master data/texts/hierarchies, and then click graphics/continue.gif to continue.

 

 

SCREEN 3.8

graphics/03fig08.gif

Note

In BW, characteristic data can consist of master data, texts, and hierarchies. Selecting this option ensures that the InfoSource to be created will apply to a characteristic. Section 7.1, "BW Star Schema," discusses master data, texts, and hierarchies and explains their relationships to characteristics.

Step 3. Enter IO_MAT, and then click graphics/continue.gif to continue.

 

 

SCREEN 3.9

graphics/03fig09.gif

Step 4. Click graphics/continue.gif) to pass the message.

 

 

SCREEN 3.10

graphics/03fig10.gif

Step 5. Now we need to tell the newly created InfoSource where to find the data and what the transfer rules are. Right-click Material number, and then select Assign DataSource….

 

 

SCREEN 3.11

graphics/03fig11.gif

Note

A DataSource is not only a structure in which source system fields are logically grouped together, but also an object that contains ETTL-related information. Four types of DataSources exist:

  • DataSources for transaction data
  • DataSources for characteristic attributes
  • DataSources for characteristic texts
  • DataSources for characteristic hierarchies

Chapter 11, Generic R/3 Data Extraction, discusses how to create a DataSource.

Step 6. Enter the source system created in Section 3.1, SS_DEMOFF, in the field Source system, and then click graphics/continue.gif to continue.
 

SCREEN 3.12

graphics/03fig12.gif

Note

DataSources are associated with source systems, so we must first tell BW where to find the DataSources.

Step 7. Click graphics/yes.gif to pass these two messages.

 

 

SCREEN 3.13

graphics/03fig13.gif

Note

When we created IO_MAT in Section 2.3, we elected to create master data and texts as shown in Screen 2.16. When the source system is a file system, as in this example, because of this selection, BW creates two DataSources: IO_MAT_ATTR for master data, and IO_MAT_TEXT for texts. In the next section, when we load the data, we will see the difference between these two DataSources.

SCREEN 3.14

graphics/03fig14.gif

Step 8. Click graphics/activate.gif to activate the transfer rules.

 

 

Note

The icon graphics/characteristic.gif in the Tp column indicates that the transfer rule is a simple one-to-one mapping. By default, BW defines simple one-to-one transfer rules. In this case, we accept the default definition. We will show how to use ABAP to define transfer rules in Section 3.7, "Creating an InfoSource for Transaction Data."

SCREEN 3.15

graphics/03fig15.gif

Result

We have created an InfoSource and transfer rules. A status message Transfer rules IO_MAT_ATTR_AH activated will appear at the bottom of Screen 3.15.

Now that the InfoSource and transfer rules are in place, we can create InfoPackages to load the characteristic data.

Part I. Guided Tours

Business Scenario and SAP BW

Creating an InfoCube

Loading Data into the InfoCube

Checking Data Quality

Creating Queries and Workbooks

Managing User Authorization

Part II. Advanced Topics

InfoCube Design

Aggregates and Multi-Cubes

Operational Data Store (ODS)

Business Content

Generic R/3 Data Extraction

Data Maintenance

Performance Tuning

Object Transport

Appendix A. BW Implementation Methodology

Object Transport

Appendix B. SAP Basis Overview

Object Transport

Appendix C. Glossary

Appendix D. Bibliography



SAP Bw. A Step-By-Step Guide
Sap Bw: a Step By Step Guide for Bw 2.0
ISBN: B000LZM8CM
EAN: N/A
Year: 2002
Pages: 106

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net