One of the coolest functions of OBIEE is the bursting option called Delivers. If you’ve worked with Cognos before you know that they have a similar functionality. I can tell you from experience that OBIEE delivers is much more versitile than Cognos’ bursting tool. That comparison will make for a good blog post in the future but I won’t go into that right now.
OBIEE delivers is not set up to work “out-of-the-box” like its competitor. However, I see this as good news for us consultants in that we have more control to setting up the relational repositories (Oracle, SQL Server, MySQL, etc.) as well has some other port configurations. At any rate, getting the configuration set-up , diving into to delivers to produce a few iBots, and sending out the alerts via SMTP is straightforward.
Have a look at the two documents below to get up an running from beginning to end.