Art of BI: OBIEE Delivers/IBots – Custom link in an Email
Author: Christian Screen | | July 22, 2009
By default hierarchy, drill-down links are removed when an OBIEE Delivers IBot notification is sent out via email. The report becomes for the most part static in the email whereas if you viewed the report in the interactive Dashboard or in Answers you would by default have the link action associated with it.
OBIEE Delivers Email Inbox
Here is the default behavior of a simple answers report. The left-most column is modeled with a hierarchy and drill-down is enabled when viewed in Answers/Dashboard.
Here is what we want to provide to our users in an email notification. As you can see, in the Outlook Express status bar, this link is pointing to a Google™ search and we have actually pulled in the column value into the URL that the user will click and be able to navigate.
Let’s Put It Together
1. Once you have your report built, we will need to modify the column properties of the column you want your link to be on. This needs to be a text/character column from my testing in order to get it to work correctly and have the override functionality that you need. Click on the column properties “hand” icon to get started.
2. Click the “Data Format” tab. Click the “Override Default Data Format” checkbox so that it is checked. Change “Treat Text As” dropdown to “Custom Text Format”. Now paste in the “Custom Text Format” field the code below. Or, modify the code below to fit your custom link needs, and paste it in.
Your final Data Format window should look like this:
3. Click “OK” to close the column properties box. Save your Answers request/view. You are done.
What’s so Cool About This? How the Hell do I Link to an Answers Report?
Well, I’ve shown you the basics, but I did take you outside of the world of OBIEE/Answers when I sent you over to Google. If you need the email report link to send you back into Answers you will need to know what the URL of your Answers/Dashboard web server is and also the relative path to tha report report (i.e.: http://corpintranet.net:9704/analytics/saw.dll?Go&nquser=Administrator&nqpassword=Administrator&Path=/shared/Paint%20Demo/Sales%20Summaries/Regional%20Analysis/Forecast%20Variance).
You can even exclude the nquser and nqpassword if you want the user to log-in if they are opening the report on the network or if you have it externally faciing. Venkat has a great article on the topic of using the GO attribute of the saw.dll URL to open reports also. Another great descriptive post is here.
Let me know if you’ve got any questions or something cool to add to this. I look forward to your comments.
Check out these BI Publisher tips including functions & calculations so you can understand more about the production and support of BI Publisher reports.
Ultimately the goal of commentary in OBIEE is to have a system for persisting feedback, creating a call to action, and recognizing the prolific users.