PowerExchange for SAP NetWeaver User Guide for PowerCenter

10.5.7
- 10.5.9
- 10.5.8
- 10.5.6
- 10.5.4
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Step 2. Create an SAP BW OHS Source Definition

Create a mapping with an SAP BW OHS source definition. When you create an SAP BW OHS source definition, use a connection string or a host name to connect to SAP. To connect to SAP using a connection string, use a connection string specified as a DEST entry in the

sapnwrfc.ini

file.

The following table lists the connection parameters you enter to connect to SAP:

Connection Parameter	Description
Connection String	Required. DEST entry defined in the sapnwrfc.ini file for a connection to a specific SAP application server or for a connection that uses SAP load balancing.
User Name	Required. SAP source system connection user name.
Password	Required. Password for the user name.
Client	Required. SAP client number.
Language	Optional. Language you want for the mapping. Must be compatible with the PowerCenter Client code page. If you leave this option blank, PowerCenter uses the default language of the SAP system.

To connect to SAP using a host name, use a host name and a system number that you specify in the Connection Properties window.

The following table lists the connection parameters you enter to connect to SAP:

Connection Parameter	Description
Host Name	Required. Host name of the machine where the SAP application is running.
System Number	Required. SAP system number.
User Name	Required. SAP source system connection user name.
Password	Required. Password for the user name.
Client	Required. SAP client number.
Language	Optional. Language you want for the mapping. Must be compatible with the PowerCenter Client code page. If you leave this option blank, PowerCenter uses the default language of the SAP system.

When you connect to SAP, the Import InfoSpokes from SAP BW wizard displays the InfoSpokes that you can import as SAP BW OHS source definitions. You can enter a filter condition to filter the InfoSpokes you want to appear.

The format of InfoSpokes depends on the DataSource they belong to. You can import an InfoSpoke from one of the following DataSources:

DataStore

InfoCube

InfoObject(Texts)

InfoObject(Attributes)

Previous versions of SAP NetWeaver BW refer to DataStore as ODS Object.

When you import multiple InfoSpokes, the Designer creates separate SAP BW OHS source definitions for each InfoSpoke. You can import multiple InfoSpokes at a time. Each mapping can include only one SAP BW OHS source definition.

When you import an SAP BW OHS source definition, Designer client replaces the slash (/) in the business name of the Source Qualifier with an underscore (_).

You can filter InfoSpokes based on the name or the description of the InfoSpoke. When you enter a filter condition, you can enter an exact name or description. Or, you can perform wildcard search. Use the following filter syntax rules and guidelines:

If you want to filter on a description, enter a filter condition of 20 characters or fewer.

Use the percent sign (%) as a wildcard search for multiple characters. For example, to find an InfoSpoke whose name begins with the letter “I”, enter

as the filter criterion.

Use an underscore (_) as a wildcard search for single characters.

The following table describes the information displayed when you select an InfoSpoke:

Field	Description
Name	Name of the record. A record can be user-defined or SAP defined. An SAP-defined record is uniquely identified by a Request ID, Data Packet ID, or Record ID.
Description	Description of the field.
Datatype	Datatype of the object.
Precision	Precision of the object.
Scale	Scale of the object.