An Oracle blog about BI Publisher

BIEE Drilling Down and then Across

Slightly off topic today but if you are working with OBIEE in conjunction with BIP its not that far off. Some of you may know, I now get to play with the whole BI suite, I have been for nearly 2 years.

Today, I was working with BIEE and wanted to share what I thought was a neat trick. I have to thank Rob Lindsley on our team for the pointers to get it working. The problem I had was that I had set up a drill down hierarchy that took the user down a couple of levels to the bottom project number level. I needed for the user to then be able to click the project number to navigate across to another more detailed report on that project. By default, there is no link, you are at the bottom of a hierarchical drill!

There is nothing you can do in the data model (that Im aware of) but you can use a neat trick to get BIEE to allow you to navigate from the bottom rung of the hierarchy. Add the bottom level column to an Answer report. Go into the column properties and set the navigation target.


The trick is to then set the current column properties as the system-wide default for that column. You can then actually delete the column from your report.

Now as you drill down the hierarchy and reach what was the bottom you will still have a link for the user to punch over to the detail report, sweeeet! The other benefit is that whenever you add the column to a report the link will be available to the detail report, unless you want to override it of course.

Join the discussion

Comments ( 3 )
  • NIcolas GERARD Saturday, May 22, 2010
    Hy Tim,
    Thanks for this tip.
    I think that you may have another solution to continue to drill:
    When you are at the bottom of the hierarchy when you drill down, you can also set the the Preferred Drill Path to then drill through.
  • Victor Wednesday, October 20, 2010
    Hi Tim,
    The problem is when I link to report # 2, the column must exist in report #1. And when the column exists or is hidden, the drill down does not work.
    Is there any other way of drilling down (With a hidden column)??
    Or another way of linking the reports (with an unexisting column in report #1)???
    Thank you!
  • Eduardo Wednesday, January 16, 2013


    I have an income statement and I want to star a drill down on fixed expenses by account (my account hyerarqui has 8 leves), then base on the account I want to see that expense by CC.

    Can I do that? Can I do a drill down by account selecting the level 4 inmediatly instead of doing level by level? that is the way I have it righ now?

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.