Creating an SAP BW Data Source Connection

  To create an SAP BW data source connection:

1. Click Connection on the main SQR Production Reporting Studio screen.

   The Create Data Connection wizard is displayed.

2. On the first page, enter a name to identify the data connection.

   For example, you could enter SAPBW to identify a connection to an SAP BW data source.

3. On the second page, select DDO to identify the data source provider.

4. On the third page, select an SAP BW data source and specify whether to enable properties attributes.

   The wizard displays the available registries and data sources. To connect to an SAP BW data source, you must first add the data source to the Registry.properties file in the DDO Registry Editor.

   To filter, slice, order, and report on the properties of a characteristic or key figure while building reports, select Enable Properties Attributes. (See Defining Filters, Defining Slicers, and Defining Order By Clauses for detailed information.)

5. (Optional) On the fourth page, enter login parameters.

   If you do not enter a username and password here, you are prompted to enter a username and password each time you connect to the database and create a report. If you do not enter a username and password here, however, you are not prompted to enter them again.

   The server name and database name parameters are not used when connecting to SAP BW.

6. Click Finish to exit from the wizard.

   The SAP BW data source you defined appears in the Data Connection dialog box.

7. Highlight the SAP BW data source and click OK.

   Tip:

   If you are in Windows and get a “Login Failed” message after you create the SAP BW data source, ensure that the sapjco.jar, sapjcorfc.dll, and librfc32.dll files are in the Hyperion\products\biplus\lib directory.