Preparing the SAP BW Environment

SAP BW remote communications require:

  • SAP BW BASIS 6.4 or higher and SAP BW 3.1C or higher.
  • Installation of the SAP RFC/SDK 4.6 or higher on the Server system.

    The Server requires the SAP RFC SDK to communicate with the SAP Application Server. The location of the RFC SDK depends on the platform specific search path.

    Platform dependent search path for shared libraries (RFC SDK):

    • Windows:
      • Directory where the executable is located.
      • Current directory.
      • Windows system directory and Windows directory.
      • Environment variable PATH.
    • AIX:

      Environment variable LIBPATH.

    • On z/OS:

      Environment variable LIBPATH.

    • All other UNIX platforms:

      Environment variable LD_LIBRARY_PATH.

      If the server does not start, and indicates that some NLS libraries cannot be found, try:

      EXPORT NLSUI_7BIT_FALLBACK=YES
    • SAP BW 3.5 users. SAP Note 11682 has been implemented. Required environment settings include:

      On all platforms (RFCSDK points to the SAP RFC SDK Shared libraries):

      SAP_HOME=$RFCSDK/lib

      On Solaris (for other platforms, please read OSS note 11682 for defining path):

      LD_LIBRARY_PATH=$SAP_HOME

      If the server does not start, and indicates that some NLS libraries cannot be found, try:

      EXPORT NLSUI_7BIT_FALLBACK=YES
    • Support for IBM iSeries platform. This release introduces support for RFCSDK 640E as of OS Release V5R2 on SAP R3 and BW. When configuring the adapter, the RFCSDK 640E must be specified/added to the current library list.

      Related adapter configuration options for SAP BW on IBM platforms can be found in Configure the Adapter on IBM Systems Using EBCIDC Character Sets and SAP BW Adapter Supporting Mixed Code Page Environments.

  • A TCP/IP connection to the SAP BW source system.

The following SAP Authorization profiles are required at a minimum. This list may change depending on your SAP BW Release and/or site specific Authorization Profiles.

List of Authorization Objects, Fields, and Required Values

S_RFC: Authorization check for RFC access

Field

Value

ACTVT (Activity)

16 (execute)

RFC_NAME (Name of RFC to be protected)

RSAB, RSOB, SYST,BAPI_IOBJ_GETDETAIL,RSBAPI_IOBJ

RFS_TYPE (Type of RFC object to be protected)

FUGR,FUNC (function group)

S_RS_ADMWB: Administrator Workbench - Objects

Field

Value

ACTVT (Activity)

03 (Display), 16 (Execute)

RSADMWBOB (Administrator Workbench object)

INFOOBJECT

S_RS_COMP: Business Explorer - Components

Field

Value

ACTVT (Activity)

03 (Display), 16 (Execute)

RSINFOAREA (InfoArea)

* (All or specific InfoAreas)

RSINFOCUBE (InfoCube)

* (All or specific InfoCubes)

RSZCOMPID (ID of a reporting component)

* (All)

RSZCOMPTP (Component type)

CKF, REP, RKF, STR, VAR

S_RS_COMP1: Business Explorer - Components: Enhancements

Field

Value

ACTVT (Activity)

03 (Display), 16 (Execute)

RSZCOMPID (Name (ID) of a reporting component)

* (All)

RSZCOMPTP (Type of a reporting component)

CKF, REP, RKF, STR, VAR

RSZOWNER (Owner (Person Responsible) for a Reporting Component)

* (All)

S_RS_ICUBE: Administrator Workbench - InfoCube

Field

Value

ACTVT (Activity)

03 (Display)

RSICUBEOBJ (InfoCube Subobject)

DATA

RSINFOAREA (InfoArea)

* (All) or specific InfoAreas

RSINFOCUBE (InfoCube)

* (All) or specific InfoCubes

S_RS_ISET: Administrator Workbench -InfoSet

Field

Value

ACTVT (Activity)

03 (Display))

RSINFOAREA (InfoArea)

* (All) or specific InfoAreas

RSINFOSET (InfoSet)

* (All) or specific InfoSets

RSISETOBJ (InfoSet-Subobject)

DATA

S_RS_ODSO: Administrator Workbench - ODS Object

Field

Value

ACTVT (Activity)

03 (Display))

RSINFOAREA (InfoArea)

* (All) or specific InfoAreas

RSODSOBJ (ODS Object)

* (All) or specific ODS Objects

RSODSPART (Subobject for ODS Object)

DATA

Accessing Multiple Systems

The query adapter can operate across multiple BW systems. For each system, the query adapter requires one BW logon consisting of client, user, and password. This logon must be:

  • RFC-enabled.
  • Authorized for all clients that you may access.

Authorizations in SAP-BW are specific to the local security policy. In addition to the authorizations documented in this manual, additional authorizations will be required in most instances. Please contact your SAP-BW basis administrator.