File contentsConnection to multidimensional databases based on SAP NetWeaver BW requires that the SAP GUI for Windows software including the required OLE DB driver is already installed. The required software can be downloaded from the SAP Service Marketplace site (registration is required). The bitness should be the same as for the Prognoz Platform 9 version in use. After installation, the saplogon.ini configuration file should be set up The file path can differs, for detailed information see the SAP GUI Logon Configuration article. If the file is missing, create it.
In the file sections it is necessary to add or change fields with the same indexes:
In the [Server] section create the filed with the SAP NetWeaver BW server name.
In the [Description] section determine description field containing the link to the SAP NetWeaver BW server. The link will be used by the ADOMD catalog for connection.
To create connection to SAP NetWeaver BW, follow the steps:
In the object navigator select the Other > ADOMD Catalog button in the New Object button drop-down menu on the Home ribbon tab or the Create > Other > ADOMD Catalog item in the object navigator context menu.
If required, change name and identifier of created object. Click the Next button to go to the Parameters wizard page.
Select the SAP BW driver, in the Server field determine description that was determined in the [Description] section of the saplogon.ini file. In the Client filed determine the client number. According to the role of the specified client, the data access will be granted in the following. To connect, determine user authentication method, if required, determine user name and password. All information required for connection, you can get from the SAP NetWeaver BW database administrator.
Click the Check Connection button. If connection is successful, click the Next button to go to the Information Providers page. On this page one select catalogs or information providers, and ADOMD catalog objects are created based on their information. By default, the All element is selected, all cubes created on server are created. If required, the list of created elements can be reduced, to do this, select required catalogs or separate information providers. The list of selected objects is saved, on updating the ADOMD contents the information only about selected elements is updated.
For the ADOMD catalog created in repository, select the Refresh context menu item. Wait for the Prognoz Platform 9, basing on metadata from server, creates all required objects - ADOMD dictionaries and ADOMD cubes:
See also: