By default hiearchy 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.
The main reason that the drill-down hieararchy link is disabled in an email notification is because OBIEE uses relative paths to know which report to link to or which path to drill-down on. With the addition of JavaScript, especially for the drill-down capability, it just cause errors when a user click on this time of linkage from an email. Relative paths are only viable when they are on the same web root as the page launching the link. Clearly an link in an email falls outside of that scope. It would be like someone sending you a link to a product the found on Amazon but the only link they sent you in an email is “/product/hasbro-gi-joe-tunnel-rat” instead of http://www.amazon.com/product/hasbro-gi-joe-tunnel-rat. For more information on Relative Paths, click here.
OBIEE Delivers Email Inbox
Here is the default behavior of a simple answers report. The left-most column is modeled with a hiearchy and drill-down is enabled when viewed in Answers/Dashboard.



