New SAP BW Dataset Plugin

The SAP BW dataset needs to be connected in the designer, establish the server dataset, and then add the relevant tables in the server dataset to the FineBI business package for data analysis.

Note：1. SAP BW plugin need registration of authorization file。

Note：2. The new SAP BW Plugin is used to connect BW Cube and BW Query, separated from the previous Cube as a separate plugin.

1) Confirm that the XMLA service is enabled on the SAP BW server.

2) Test the SAP BW data connection in the FineReport designer in the local directory.

3) Create a remote connection between FineBI and FineReport to ensure that FineBI uses the server dataset to create a SAP BW data connection.

4) Add SAP BW dataset under Server > Server dataset in FineReport.

5) In the BI business package, select the SAP BW data under the server dataset.

1. Startup Service

1）Frist，be sure SAP BW Server have been startup the XMLA service，so that we can use XMLA connection in external software

Log in to the SAP system as the client：TCODE:SICF > default_host > sap > bw，as shown follow:

2）Right clickbw，select Deactivate service，clickOK，then right clickbwselectActivate service，clickOK，make sure all services are enabled.

2. Install plugin in both FineReport and FineBI 

Download address：https://community.finereport.com/plugin/?id=39

FineReport Designer plugin installation method reference: Plugin Management

FineBI Server installation plugin method reference: Server plugin management

Note：Both FineReport and FineBI need to install the same version of the SAP BW plugin.

3. Test connection to SAP BW in FineReport

BI connection to SAP BW requires the use of server datasets, so it is necessary to first ensure that FineReport has no problem connecting to SAP BW for testing.

1）Import the SAP package and native library, and ensure that the interface package and native library can be found by the running JVM.

a. Windows

FineBI is deployed in Windows system. Take Tomcat as an example:

Note 1: If the data connection fails, you can try to place the sapjco3.dll file in the bin directory of the system jre, for example: %JAVA_HOME%\jre\bin

Only the FineBI installation package is installed, no deployment:

b. Linux

FineBI is deployed in Linux system. Take Tomcat as an example:

Only the FineBI installation package is installed, no deployment:

c. FineReport Local Designer

2）Create SAP BW data connection in Local Designer , please refer to SAP BW data connection.

4. FineReport connects to FineBI remotely

5. Add SAP BW dataset  

1）Create SAP BW data connection in Remote Environment, click Server > Define Data Connection，please refer to SAP BW data connection.

2）Finereport is in a remote environment, click Server > Server Dataset in Finereport Designer.

3）Add the SAP BW dataset, as shown below:

For details, please refer to the FineReport help document SAP BW data connection

6. Add data to FineBI business package

1）After completing the above operations, log in to the FineBI data decision system with the administrator account. Click "Add Table", select "Database Table", as shown below:

III. Precautions

1. Problem Description

After using FineReport Designer Connects to FineBI Project Remotely, SAP BW plugin is installed in both BI and designer, but SAP dataset is not displayed when adding server dataset.

2. How to Resolved

The JAR package version of the report module of the FineBI project should be consistent with the JAR package version of the designer. The method of viewing the JAR package version of the report module of the FineBI project is as follows: