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.

BIEEDrill1.gif

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.

Comments:

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. Cheers Nico

Posted by NIcolas GERARD on May 21, 2010 at 07:11 PM MDT #

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!

Posted by Victor on October 20, 2010 at 08:11 AM MDT #

Hi
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?

Posted by Eduardo on January 16, 2013 at 03:54 PM MST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today