To be able to use OLD DB for OLAP with SAP Business Intelligence, 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 Business Intelligence OLE DB for OLAP Providers are as follows:
● BW OLE DB for OLAP providers between the data provider and the third-party client as the data consumer. The OLE DB for OLAP Providers maintains and modifies data displayed by the data provider.
● OLAP-BAPIs
The graphic below shows the arrangement of components:
The SAP Business Intelligence 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 BI server and multiple function module APIs.
Note that all components that are integrated on the SAP 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.
If you are using Windows 95, you also need to install DCOM95 before installing the OLE DB driver. You can find the required program on the BW delivery CD for the front end under \msredist\DCOM95.EXE.
To access a BI system via OLE DB for OLAP, you need to install a BI front end. The SAP BI front end setup contains components required by the SAP BW OLE DB for OLAP Providers.
Installing SAP BI front end setup components
Install the following components on your desktop PC:
Component |
Description |
Mdrmsap.dll |
SAP 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 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 BI server using OLE DB for OLAP Drivers
Set the following parameters:
Parameter |
Description |
Provider |
Technical name under which the SAP components are installed: 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 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