To be able to use OLD DB for OLAP with SAP NetWeaver Business Warehouse, you need to install the required front end components and prepare the connection to the BW server via OLE DB for OLAP.
This applies for the 32 bit client version with installation by SAP GUI. SAP also provides a 64 bit version. See SAP Note 1496637 for details.
The main components in the implementation of SAP NetWeaver Business Warehouse OLE DB for OLAP Providers are as follows:
The graphic below shows the arrangement of components:
The SAP NetWeaver Business Warehouse OLE DB for OLAP setup installs a provider DLL (dynamically linked library) on the desktop on which the third-party client application is installed. This DLL is registered under the name MdrmSap in the system registry. The provider DLL uses RFC to set up a connection between the BW server and multiple function module APIs.
Note that all components that are integrated on the SAP NetWeaver BW OLE DB for OLAP Providers and which are required by the client application must be installed by the third party application itself.
It is usually necessary to install Microsoft's Redistribution Setups for Microsoft Data Access Components (MDAC) including the OLE DB and ODBC drivers. If not delivered with the client-specific software, you can find the required components at www.microsoft.com/data/download2.htm.
To access a BW system using OLE DB for OLAP, you need to install a SAP GUI (including the SAP BEx Suite). The SAP GUI setup contains components required by the SAP NetWeaver BW OLE DB for OLAP Providers.
Installing SAP GUI front end setup components
Install the following components on your desktop PC:
Component | Description |
---|---|
Mdrmsap.dll |
SAP NetWeaver BW OLE DB for OLAP provider DLL |
Mdrmdlg.dll |
Service DLL to create a connection to the SAP server. |
Scerrlkp.dll |
Error handling DLL |
Mdxpars.dll |
MDX parser DLL |
Librfc32.dll |
SAP RFC library |
Wdtlog.ocx |
SAP RFC logon dialog |
Saplogon.ini |
SAP connection parameter file |
The SAP NetWeaver BW OLE DB for OLAP Providers is registered under the progID (program ID) MDrmSAP.
To install these components, you need administrator rights on the desktop PC.
Establishing a connection to the BW server using OLE DB for OLAP Drivers
Set the following parameters:
Parameter | Description |
---|---|
Provider |
Technical name that the SAP components are installed under: MDrmSAP. |
DataSource |
System name. This name must concur with the name in the SAP logon. |
UserID |
User name in system |
Password |
User password in system |
SFC_CLIENT |
Number of productive client in the BW server system |
SFC_LANGUAGE |
Logon language |
A typical example of a provider string could be:
DataSource=JXX;UserID=MyName;Password=MyPassword;Provider=MDrmSAP;SFC_CLIENT=005;SFC_LANGUAGE=DE