Skip to Content
Author's profile photo Vishal Mour

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

This is the second part of the blog post on how to trigger schedule in SAP BI Platform from BW system.

In the first blog we have looked into the integration steps between SAP BI Platform and BW system, as well as configuring BW event in BI platform. In this blog we will have a walk-through on the process chain creation and configuring SAP BI Platform specific process type in SAP BW system.

 

Create a Process chain with BI Platform specific process type in BW

Goto tx rspc and select process chain

Right Click on Process Chains > Choose Create Display Component

 

Provide Application Component and description

 

New BW application component is created.

Right click on the newly created component and choose Create Process Chain

Provide Name and Description

Click OK

 

Create new Start Process

 

Provide process name and description

Click OK

 

Click Edit Conditions

Choose Immediate if you want the process chain to be executed immediately.

Save.

 

Then Save again.

 

Click OK

 

Process chain is created as shown below.

Double click on the Process Chain

 

You will be able to see the following. Start process type is also displayed.

 

Expand the “Load Process and Postprocessing” folder.

Double click on “Trigger Event in BusinessObjects Explorer for BW Data Change”

 

Create New and provide the Variant and description

Click OK.

Select the Destination from the list of destinations. This should be the same destination created in step 2 in the first blog

Select the BW Event from the list of BW Events.

Click on Save.

 

Click OK.

Process chain with Trigger BOE Event process type is created.

Activate and Execute the process chain.

 

Whenever “Trigger BOE Event” Process Type runs as part of the Process Chain, BW Event selected in the process type will be triggered in the BI Platform system. And as a result of the trigger of this event, corresponding associated reports will be scheduled.

Assigned Tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Steve Murray
      Steve Murray

       

      Hi Vishal

      We've just patched our BW system to 7.4 SP19 and the new process type "Trigger event in BusinessObjects explorer for BW data change" does not appear as an option in RSPC. Is there another note we need to apply?

      Many thanks

      Steve Murray

      Author's profile photo Vishal Mour
      Vishal Mour
      Blog Post Author

      Hi Murray,

      I am not really an expert on BW side. I would suggest you to report a ticket to SAP support.

      Thanks,

      Vishal

       

      Author's profile photo Marcello Orru
      Marcello Orru

      Hi Vishal,

       

      Great post! I have a question regarding the final status of the BW process chain..

      If the the event triggers the scheduling correctly but in BO for some reason the scheduling job fails, the process chain's status will be green or red?

       

      Thanks,

      Marcello

      Author's profile photo Vishal Mour
      Vishal Mour
      Blog Post Author

      Hi Marcello,

       

      Thanks for the feedback.

      If the schedule is successfully triggered in BO, the status in process chain will be green. This is irrespective of whether the schedule was successful or it failed.

       

      Cheers,

      Vishal

      Author's profile photo Gleb Shpak
      Gleb Shpak

      Hi Vishal,

       

      Is it possible to automatically schedule SAP Analysis for Office Documents with variable parameters?

      e.g.

      I have an Analysis for Office Sales Report based on Month X.

      I want that the BI-Platform automatically schedule the report every month (that already works) and then automatically change the month value to the current month.

       

      Is it possible?

       

      Kind regards

      Gleb

      Author's profile photo Moritz Kelm
      Moritz Kelm

      Dear Vishal,

      in your blog you write that minimum requirement for this is BW 7.40 SP19.

      However, the SAP Note 2517347 states that SP 20 is required.

      Is it possible to get it running with SP19 as well?

      Thanks

      Moritz

      Author's profile photo Andrei Kolesnikov
      Andrei Kolesnikov

      Dear Vishal

      On the step "Select the BW Event from the list of BW Events"  asks for a username and password. which user?

      Author's profile photo Vijayalayan Krishnan
      Vijayalayan Krishnan

      Hi Andrei,
      Did you figure out the Event Selection issue? I am also getting the logon screen.

      Author's profile photo Aldo Yair Gamboa Ponce
      Aldo Yair Gamboa Ponce

      Hi Andrei / Vijayalayan,

      Did you figure out the Event Selection issue? I am also getting the logon screen.

       

      Author's profile photo Daniel Purucker
      Daniel Purucker

      Hi everyone,

      did you had any success on the logon screen issue? I'm facing this as well, and have no clue waht to input.

      Thanks, Daniel

      Author's profile photo Moritz Weber
      Moritz Weber

      Hi Daniel,

      in our case 2 points solved the problem:

      1. In our connection we had the port 443 from tomcat, we changed it to the port from wacs https (See in CMC -> Server -> WACS -> Properties)
      2. We created a user on bo side with the name of the CN of the SSL - certificate (including spaces an everyting else 😉 )

      good luck,

      Moritz

      Author's profile photo Siddharth Chamoli
      Siddharth Chamoli

      Hi Moritz,

      Is it for release BW/4HANA 2.0? I get the same error.

       

      Thanks

      Author's profile photo Moritz Weber
      Moritz Weber

      Hi Siddharth,

      as the post was sent we were on BWonHana but now we are on BW4 and it still works...

       

      Author's profile photo Christian Hofmann
      Christian Hofmann

      Hi @all

      We are running a 2-tier SAP BO Landscape and a 3-tier SAP BW landscape. We implemented triggering as well - test are successful so far.

      Right now we are facing an issue regarding transporting of BW Process Chains, as  the BO Event-ID changes during promotion of the event on BO Side.

      Therefore the run of the process chain will fail in BW production system.

      Has anyone else run into this issue? How did you resolve this?

       

      Thanks!

       

      Christian

      Author's profile photo Klaus Franz
      Klaus Franz

      Hi Christian,

      do you have solution for your problem with changing BO event IDs during promotion?

      I just ran into the same problem...

      Klaus

       

      Author's profile photo Praveen Singam
      Praveen Singam

      HI Vishal,

      My requirement is to trigger Publication report (publication on one of Webi report) in BO from BW Process chain. I followed the steps by creating BW Event(Enabled Alert also) and used the created BW event in the  Publication report. I created process chain and added the process type "Trigger Event in SAP BOBJ" and gave destination and event required, I executed the process chain and also received the Alert that the report is triggered. But when I see history of schedule , I could not see the status as running. Please help me in this issue.

      Regards,

      Praveen.