Reports Scheduling problem

[Former Member]

We had a problem of reports appearing blank due to no data in db. After some time db data available. But reports already run.

Is there not something that we can instrument that tells the reporting engine when to fire and run the reports?

If that is not an option, then what about something in the reports that checks for data and reschedules if there is no data?

Please suggest.

Thanks in advance.

Regards,

Ramesh.

[former_member142702 · Accepted solution]

Hi

you can instruct BO to wait for external events (file triggers) before actually running schedule reports.

Which version of BOBJ do you use?

Regards,

Stratos

[Former Member · Accepted solution]

We are using XI R2.

How to configure external events (file triggers)? any documentation and samples available.

Thank You.

Ramesh.

[former_member142702 · Accepted solution]

Hi

you can configure those in the CMC. Take a look at the admin guide:

http://help.sap.com/businessobject/product_guides/boexir2/en/xir2_bip_Admin_en.pdf

Configuring external events is rather straightforward. You need the name of the file, which will trigger the event when created. Usually the file resides on a network drive.

Regards,

Stratos

[Former Member · Accepted solution]

Could you give a sample event configuration.?

Thanks for your help.

[former_member142702 · Accepted solution]

Hi

the workflow is pretty simple. Take a look at the admin guide.

Regards,

Stratos

[Former Member · Accepted solution]

Thanks alot.

[Former Member · Accepted solution]

Thanks -- appreciated.

But whenever the event files pushed to BO server, all daily reports triggered automaticaly with out waiting for the scheduled time. I surprised with this. Why it's not triggering at the scheduled time with events. Please suggest steps to troubleshoot.

Thanks.

[Former Member]

Thanks -- appreciated.But whenever the event files pushed to BO server, all daily reports triggered automaticaly with out waiting for the scheduled time. I surprised with this. Why it's not triggering at the scheduled time with events. Please suggest steps to troubleshoot.

Thanks.

[former_member142702]

I assume that there existed already instances of your scheduled report which have reached the time at which they are supposed to run and were just waiting for trigger.

Regards,

Stratos

[Former Member]

I cleaned the instances of other scheduled reports. Then did testing. Still before the scheduled time the report runs immediately after event file appears in the folder.

forexample : I scheduled a report A to run daily at 5:00AM, with events. the event file came at 4:00AM, and the report is triggered with out waiting for the time 5:00AM

Is this the expected behaviour in BO?

Thanks.

[Former Member]

Can anyone help me regarding this.