SAP BI 4.2 SP05 : Triggering Schedule in BI Platform from BW – Part 1

DISCLAIMER

This document summarizes the planned enhancements in the next SAP BI 4.2 Support Package 5 in BIPlatform. As the SAP BI 4.2 SP5 content is still subject to change, please consider the below legal disclaimer statement:

The information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP. This presentation is not subject to your license agreement or any other service or subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation and SAP’s strategy and possible future developments, products and or platforms directions and functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information in this document is not a commitment, promise or legal obligation to deliver any material, code or functionality. This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchant ability, fitness for a particular purpose, or non-infringement. This document is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP´s wilful misconduct or gross negligence.

All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions

Overview

The idea here is to provide a tighter integration between SAP BW system and SAP BI Platform. With this integration, it will be possible to Trigger Report Schedule in SAP BusinessObejcts Platform based on “Data Load” event in BW. This approach provides an alternative of the existing File Based Event Scheduler specifically for reports based on BW data sources.

A new Event Type has been introduced in SAP BI Platform called as BW Events, which is available in CMC, Infoview and new BIL. From BW we have  introducing a new Process Type called as BOE Trigger Event.

Feature Availability *This list is tentative and subject to change*

These changes will be available from:

SAP BusinessObjects BI Platform 4.2 SP05 release.

From BW:

730 release – SP18

731 release – SP22

740 release – SP20 (Refer https://launchpad.support.sap.com/#/notes/2517347 as shared by Moritz Kelm)

750 release – SP11

BW/4 HANA 1.00 – SP08

752 release – SP01

Details:

This is the first part of two part blog series.

In this blog I have done a walk through of Integration Steps between BW and BI Platform as well the BW event configuration and assignment in SAP BI Platform.

In the second blog I have done a walk through of the Process Type configuration in BW system.

Integration Steps:

Pre-requisite: X509 certificate based trusted authentication should be enabled for REST SDK. For more details on the you can refer BI Admin Guide 4.2 SP04 or refer below blog:

https://blogs.sap.com/2017/06/06/trusted-x509-authentication-support-in-sap-businessobjects-platform-rest-sdk-part-2/

1. Establishing Mutual Trust Between BOE and BW

Import BOE (WACS) server certificate in BW trust store (tx:strust)

Similarly import BW server certificate in BOE (WACS) server trust store.

WACS trust store should already be configured, details should be present under:

2. Create and Test: http Destination in ABAP

Go to transaction SM59 and mark the “HTTP connections to External Server” node and press create:

Enter details as shown below: WACS Server Host and https port and change to the “logon and security” tab:

Activate SSL and choose “DFAULT SSL Client (Standard)”:

If you execute connection test it will show success:

The success response indicates that the Trust connection has been established between BW and BI Platform.

Please 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.

3. Create BW Event in CMC

New Event type called as BW Events is introduced.

Double click BW Events folder.

Create a new BW Event, provide the details and click ok.  You can also enable Alerts for this event.

The event will be created:

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.

4. Assigning BW Event to Report

Right click report, and select Schedule. Goto Events -> BW events.

We should be able to see the list of BW events created under Available Events.

Select the right event and move it under Events to Wait for.

Set a recurrent schedule for the report.

5. Create a user in BOE

Logon to CMC -> Users and Groups. Create a new user having account name as BW system name.

In the below screenshot: W4D is the BW system name:

Assign appropriate Rights to this user. The user should be able to:

• View BW Events
• Trigger BW events

In the next blog we will look into how to configure Process Type in BW