Schedule a report only when the report will return data

[system]

We have requirment that need to run a Webi report only when the report will return data. We are using BOXI R3.

Action :- Create an alert in Business Objects based on the number of records returned in a query. The report can contain any data.

The report should be sheduled when the below example query returns a number > 0.

select count(*) from Table.Column
where Date = trunc(sysdate)

I’m pretty sure we can do this with an event but would like to see if there isn’t some other way to do this.

Please advise how to schedule a report only when the report will return data with alert option.

Thanks in advance!

---

badesudh2 (BOB member since 2009-05-04)

[system]

Take a look at this topic:

BO generated emails

Hi All, We schedule some webi reports and send out the reports by email. Sometimes the reports do not have data return. Are there any methods to generate emails that only the reports contain data? Please give some advices many thanks. jiang (BOB member since 2007-01-12)

HTH

---

mcnelson (BOB member since 2008-10-09)

[system]

I tried the steps you mentioned.However, I still get an email when teh report has no data

Can you please let me know what needs to be done

---

badesudh2 (BOB member since 2009-05-04)

[system]

This is how I do it:

I have an object (created in the Universe) that will return an error in the circumstances when I don’t want the report to run (a count of a certain dimension):

case when count(@Select(Report\Object))=0 then 1/0 else count(@Select(Report\Object)) END

I put this object in a separate query in my report.

HTH

---

mcnelson (BOB member since 2008-10-09)

[system]

Thanks for your idea and its working .

We don’t want to deploy using this method because it does generated a failed job. We have a daily alert that is sent to the user whenever they have a job that failed. It would get confusing to them and they wouldn’t know if it was really a failure or a staged failure when no data is returned.

Want to check the following

1. If SAP ’ve added anything new that might allow us to do something like this in SAP 4.0 scheduling features.
2. If we can create a SQL based check to trigger the event in SAP 4.0 events.

Please advice.

---

badesudh2 (BOB member since 2009-05-04)

[system]

Glad it’s working - wasn’t my idea though!

Sounds like you’ve scheduled your report through the CMC with a Failure notification on it; personally I’d just take the failure notification off it, once I’d tested it thoroughly.

Not sure about 4.0 I’m afraid, have no experience of it. Haven’t read of any notable improvements to the scheduler component though. Maybe someone else can advise?

Kind Regards,

NMG

---

mcnelson (BOB member since 2008-10-09)