how to create event trigger to kick off another report

[Former Member]

Hi i am having two reports, first report runs for 10 minutes , i want the second report to run automatically after first report is completed. how to do that?

[fritzfeltus]

Create a schedule event in the CMC.

Click Schedule on the report that needs to be triggered by the first report. Set recurrence and other options.

Add the event to the "Events to wait for" list in the Events section.

Schedule the first report to run, choose a recurrence and set needed options, and add the event to the "Events to trigger on completion" list in the events section.

Admin guide also has a section on creating schedule events

http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_bip_admin_en.pdf

[Former Member]

i did the way u told but the second report is not running once the first report is success or failure.

fro report1 I added the event to the "Events to trigger on completion" list. and added the event to the "Events to wait for" fro my second report.

my recurrence for the second report is "now".

[fritzfeltus]

the event needs to be triggered within the start and end time (try scheduling "once" with a specific time interval).

From the admin guide:

Scheduling objects based on an event

When you schedule an object that waits for a specified event, the object will

run only when the event is triggered, and only when the rest of the schedule

conditions are met. If the event is triggered before the start date of the object,

the object will not run. If you have specified an end date for this object, and

if the event is not triggered before the end date occurs, the object will not

run because not all of the conditions will have been met. Also, if you choose

a weekly, monthly, or calendar schedule, the object will have a specified time

frame in which it can be processed. The event must be triggered within this

specified time for the object to run. For example, if you schedule a weekly

report object that runs every Tuesday, the event must be triggered before

the end date of the instance (the end of Monday, in this example).

[Former Member]

Hi Fritz,

I've created the schedule the same way you mentioned. ( Recurrence : Once with Start date - Today , End Date - some date in 2024).

The schedule which waits for the event is in Pending state.

I created the event for Success

Thanks,

Bharath