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.
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
Hi Murray,
I am not really an expert on BW side. I would suggest you to report a ticket to SAP support.
Thanks,
Vishal
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
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
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
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
Dear Vishal
On the step "Select the BW Event from the list of BW Events" asks for a username and password. which user?
Hi Andrei,
Did you figure out the Event Selection issue? I am also getting the logon screen.
Hi Andrei / Vijayalayan,
Did you figure out the Event Selection issue? I am also getting the logon screen.
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
Hi Daniel,
in our case 2 points solved the problem:
good luck,
Moritz
Hi Moritz,
Is it for release BW/4HANA 2.0? I get the same error.
Thanks
Hi Siddharth,
as the post was sent we were on BWonHana but now we are on BW4 and it still works...
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
Hi Christian,
do you have solution for your problem with changing BO event IDs during promotion?
I just ran into the same problem...
Klaus
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.