Auto email based on the measure object

building reports webintelligence
1

Hi Experts,

I have a WEB I report with Revenue measure object, my requirement is if revenue >$1K then report needs to send email to some of the users.

Is BO have such kind of facility??

Thanks,

Tims_Bo :india: (BOB member since 2008-07-26)

2

Hi Experts.

Has any one come across this kind of situation??

Thanks,

Tims_Bo :india: (BOB member since 2008-07-26)

3

Not really, unfortunately.

There is a possible work-around, using file-based events. Set up a job in your database (not in BOXI) that runs a query similar to your BOXI report (just enough to get the measure in question) and generates a simple text file in a folder somewhere that BOXI can see. Create an event in BOXI that is triggered when that file shows up. Create a schedule that runs based on that event. Make sure you clean up the trigger file, so that it can all run again next time.

You can set up the job to generate different files for different conditions. Then, create an event for each file, and a schedule for each event. This allows you to only notify a small group of people if all is normal, a larger group of people if the measure is a little outside the desired range, and a different group of people if the measure is far outside the desired range.

Lugh (BOB member since 2009-07-16)

4

Lugh, this is something interesting answer…I am not sure whether it is going to work or not, but I will definately find the way of this question…

Thanks a lot!!!

Tims_Bo :india: (BOB member since 2008-07-26)

5

Why doyou need Business Objects for this? Write a unix shell script to run sql query against database. Check result and send email if revenue is greater than $1K or whatever.

You also can run this script for every 10 min.

Hope this helps.

Regards,
Girish

girishoak (BOB member since 2007-02-14)

6

I am not fully aware of shell scripts and moreover we wanted to make it by automatic email if revenue>1K then email should go to particular users…

Thanks,

Tims_Bo :india: (BOB member since 2008-07-26)

7

Is it possible to write a batch file? even batch file should serve the purpose.

You can always make the script to sleep for few minutes and rerun again. You will have to run it manually only once at the beginning and it will keep running till end of the world or till you shut down machine or keel that script.

You can make the script sleep by providing sleep time in miliseconds (e.g 10 min = 60000).

Regards,
Girish

girishoak (BOB member since 2007-02-14)

8

Well, the advantage to adding BO to the mix here is that you can email an actual report to the people involved. A UNIX shell script is pretty much only going to be able to send plain text, or a pre-existing file.

Lugh (BOB member since 2009-07-16)