Technical Articles
Triggering Schedule (BW Events) in BI Platform from BW
This article will go through the SAP BW and BI Platform integration process to trigger schedule from BW in the BI Platform
It should be noted that this topic has been covered before by Vishal Mour in this post
https://blogs.sap.com/2017/11/08/sap-bi-4.2-sp05-triggering-schedule-in-bi-platform-from-bw-part-1/
I assume, however, that some steps can be elaborated in detail to help users execute the steps easily.
Prerequisite
Before we start the BW and BI Platform integration, x509 certificate based trusted authentication should be enabled for REST SDK.
For configuration details refer below blog
https://blogs.sap.com/2017/06/06/trusted-x509-authentication-support-in-sap-businessobjects-platform-rest-sdk-part-2/
Setup Process
Trust Between BW and BI Platform
Import WACS server certificate in BW trust store
- When WACS is configured for https, simple step to get WACS server certificate
- Launch WACS server https URL
Ex – https://<WACS_Server_Host>:<SSL_Port>/biprws - Export https certificate from browser and save in .cer format and save any root certificate
In the SAP BW system, go to transaction “STRUST” and import the WACS server certificate into the SSL client SSL Client (Standard) and click the Add to Certificate List button, click on Save.
Import BW server certificate in BOE WACS server trust store
In the SAP BW system, go to transaction “STRUST” and export the server certificates from the SYSTEM PSE and SSL client SSL Client (Standard), choose binary as the format with and save with .crt extension (ex – Cert1.crt and Cert2.crt).
Import the above exported BW certificates using the following command into the BI Platform WACS server keystore truststore (WACS truststore should already be configured, as mentioned in the prerequisites)
Command
<sap_bobj_installed_dir>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin > keytool import -alias BW1 -file Cert1.crt -keystore <wacs_trust_keystore>
<sap_bobj_installed_dir>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin > keytool import -alias BW2 -file Cert2.crt -keystore <wacs_trust_keystore>
Restart WACS server
Create and Test http Destination in ABAP
Go to transaction SM59
- Select “HTTP Connections to External Server” and Choose Create
Enter a name
Under Technical Settings, make the following entries
Target host – This is the host that you want to connect to (WACS Server Host)
Service no – Here, you specify the port (WACS Server https port)
- Under Logon/Security, make the following entries
SSL – Active
SSL Certificate – Choose “DFAULT SSL Client (Standard)”
Click on Save
Test Connection
Click on Connection Test, if all the configuration steps are performed correctly, the test connection will show success.
The success response indicates that the Trust has been established between BW and BI Platform
Note – For SSL Communication, SAP BI Platform uses version TLS 1.2/1.1 The same needs to be enabled in SAP BW system as well. Else due to cipher suite mismatch the connection might fail.
To enabled TLS v1.2 in SAP BW system, follow the blog below.
How to enable TLSv1.2 in SAP Netweaver ABAP
https://blogs.sap.com/2019/11/11/how-to-enable-tls-v1.2-in-sap-netweaver-abap/
Create BW Event and Assign to Report
- Login into CMC –> Events
- Under BW Events folder, create a new BW Event, provide the details and click ok. The event will be created
Note – We can create multiple BW Events based on the requirement, ideally one for each data source such as Cube, DSO etc on which your BI Platform report is created.
3. Right click report and select schedule —> Events —> BW Events
You should be able to see the list of BW events created under Available Events.
4. Select the right event and move it under Events to Wait for
This completes the BW and BI Platform Integration Configuration, as well as configuring BW Events in BI Platform
For Part 2 – How to configure Process Type in BW
Follow below blog
https://blogs.sap.com/2017/11/08/sap-bi-4.2-sp05-triggering-schedule-in-bi-platform-from-bw-part-2/
Learn More:
https://blogs.sap.com/2018/02/22/adfs-with-sap-business-intelligence-platform/
Hi Mohammed,
This was really helpful as it covers most of the points which I was missing in Vishal's blog which I did not find anywhere else. Could you please let me know what should be entered in WACS HTTPS properties for field 'Certificate Alias:' alias of PSE certificate (in your example 'BW1') or alias of SSL certificate (BW2') or both and if both how should I enter it?
Best Regards,
Marcel
Hi Marcel,
Thanks for your comment.
Please find my comments below.
Certificate alias is just another name that can be used for the certificate, and its user defined value can be any meaningful name. I mentioned the name of the server as the certificate alias in my case
Firstly, we are exporting two BW server certificates, let's say Cert1 and Cert2. Both of these certificates should now be imported into the WACS server certficate one by one using the commands above.
So, while importing these with the import command i just mentioned BW1 as alias for Cert1 and BW2 as alias for Cert2 (alias is a user defined value, can be any meaningful name)
Hope it helps.
Thanks
Ashraf
Hi Mohammed,
I did not notice previously that there is serverkeystore.jks and trustkeystore.jks. Should be the BW certificates imported to trustkeystore.jks file and the import command should looks more like below (instead of server_key store use trust_keystore file?
<sap_bobj_installed_dir>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin > keytool -import -alias BW1 -file Cert1.crt -keysore <wacs_trust_keystore>
Thank you in advance.
Marcel
Hi Marcel,
Yes, the BW certificates should be imported to trustkeystore.jks and the import command looks like below.
<sap_bobj_installed_dir>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin > keytool -import -alias BW1 -file Cert1.crt -keystore <wacs_trust_keystore>
I have also corrected in the blog.
Thanks
Ashraf
Hi Mohammed.
Thank you for u work.
Could you please answer me on one question:
in Vishal’s blog says:
Select the BW Event from the list of BW Events.
but when I click on the event selection button, I’m asked to enter a username and password.
which user should be?
Hi Andrei,
Thanks for your question.
1. Select the BW Event from the list of BW Events - What this means is that it lists the BW Events created in BI Platform. You choose the one from the list of events to be allocated to the BW trigger. So trigger in BW will trigger BW Event in BI Platform.
2. But when I click on the event selection button, I’m asked to enter a username and password - If your Test Connection (step in the above blog) is passed, it should not be prompt for a user.
Hope it helps.
Thanks
Ashraf
I am having the same issue and my Test Connection is OK
Any suggestins how to fix it?
Thanks
Josipa
Hi,
Could you please explain the problem briefly ?
Thanks
Ashraf
When configuring an Event in BW Process I am prompted with username and password instead of getting a list of Events setup in BO
Instaed of using WACS for the RFC connection I am using Tomcat Restfull service biprws.
RFC connection returns OK
I followed this note to establish connections between BO and BW
2812939 - How to configure BW Events-based scheduling in BI Platform - SAP ONE Support Launchpad
Hi,
It appears to me that there is a trust issue, enable ICM tracing to help troubleshoot.
Check that HTTPS client authentication is performed and that the Web Application Server is trusted by the BW system.
Hope it helps.
Thanks
Ashraf