BusinessObjects Board

BO Refresh through Scheduler

scheduling XI Scheduler
#1

Hi,
I am using BOXI R2.

My requirement is below.
After report refreshed at night, mail should trigger to the business users with report in .PDF format along with record count.

If report is blank (0 records) then the respective .pdf file should not be attached in the mail and in the message body the blank record message should be printed.

Thanks
Byomakesh

Byomakesh :india: (BOB member since 2009-08-01)

#2

[Moderator Note: Moved from Semantic Layer / Universe Designer to XI Scheduler]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

Unfortunately, there is no way for the scheduler to know whether there is data in report or not. So, while it’s a simple thing to schedule a report so that it is automatically emailed in PDF format when it’s complete, there is no way in BusinessObjects itself to only send the report if it has data.

There may be third-party tools available to do this, or you could write a program using the SDK that would do something like the following:

  1. Run the query that the report uses to determine whether there is any data.

  2. If there is data, schedule the report to run and send to email.

-Dell

hilfy :us: (BOB member since 2007-04-16)

#4

Haven’t thought this through all the way…

What if you added a query to the report that failed with a sql error if there were no records in the report? You then setup notification of a failure with the message you want in the email.

The sql error could be generated with something like trying to perform a function on a number. Again, it needs to be tested but something like

to_number(case when RowCount() = 0 then ‘A’ else RowCount() end)

If RowCOunt() = 0 then you get a alpha which can’t be cast to a number. This should cause the report instance to fail.

jwhite9 :us: (BOB member since 2006-07-28)

#5

Hi,

Maybe this can help:

Marek Chladny :slovakia: (BOB member since 2003-11-27)