BusinessObjects Board

Schedule Webi Report based on Data in Database

building reports webintelligence
#1

Hi All,

I have a Webi report (XI 3.1)to be scheduled, based on the presence of latest data in a table in the database.
In short, if count(*)>0 then report has to be scheduled. please let me know how to achieve this.

Thanks,
Bob

bob96 (BOB member since 2012-02-02)

Schedule report if value above limit
How do I run a WebI report on an SQL-event
#2

There was a topic about this a while back but I wasn’t able to find it.

  1. Create two reports – report #1 will trigger #2, so #2 will be the “real” report that you want to see when there is data
  2. Set up Report #1 so that it generates a x/0 error when there is no data (essentailly, “select count(*)/0 from mytable”)
  3. Create a Schedule Event; this will fire when report #1 finishes successfully.
  4. Schedule #1 for whatever interval you want, and have it fire the Schedule Event when complete.
  5. Schedule #2 to run when the Schedule Event fires.

Once this is done, Report #2 will only run when Report #1 has completed successfully. If there is no data, #1 will fail and not fire the Schedule Event.

Joe

joepeters :us: (BOB member since 2002-08-29)

#3

You should be able to skip those steps by creating an object like the following

IF count()> 0 then 1 else count()/ 0 end

Then your schedule will run successfully if there is data, but ‘fail’ when there isn’t.

weaver (BOB member since 2008-10-17)

#4

https://bobj-board.org/t/189404

HTH

mcnelson :uk: (BOB member since 2008-10-09)

#5

Thanks Joe and Weaver. Will try both and see. Thanks Again!!

bob96 (BOB member since 2012-02-02)

#6

Thanks for the post mcnelson!!

-Bob

bob96 (BOB member since 2012-02-02)