How To Implement Breadcrumb in OBIEE / Siebel Analytics
Posted by sranka on December 7, 2008
Hi All,
Feeling accomplished as one more battle with Business has been won. Had a long debate over UI and usability of reports. Business kept complaining for certain navigation, and all I could say was, definitely will look into it. After every single discussion, felt helpless and incompetent. Spoke with folks at oracle support and got the same answer, “We don’t support this feature.”
Business had valid concern, all the needed was a mechanism to navigate back to the page they came from. In short they need the “BREADCRUMBS”.
The challenge was how to implement some thing like breadcrumb. Thought of many ways, even went to the extend of re writing some of the internal javascripts, but data and report persistent failed every time. At times I could navigate to the page, but the data integraty was lost between the pages.
One night got a dream that breadcrumbs are working on the application, but I knew the dream was too good to be true.
With all the knowledge of internal javascript, began my journey of debugging and wallahaa, got answer to the BREADCRUMB, thing which was sounding next to the impossible was possible now. See the image below ::
Bread Crumb
As the imagesI could click on UNITED STATES and could go back to level 1 of report, no need to clicking browser back button 4 times.
Below is the piece of code I used in the narrative view of the breadcrumb report. I know it may be difficult to understand, but I am open to work with individuals and can be reached email address provided in — About Me — page.
Following is the Javascript Code :
<span onclick=”javascript:PortalPageNav(event,’/shared/attach rate/_portal/2attach rate’,'Sales View – Detail’)” class=”Nav”><u>@1</u></span>
<img src=”https://www.microstrategy.com/graphics/Homepage/Feb05/icon_arrow_red.gif”>
<span onclick=”javascript:PortalPageNav(event,’/shared/attach rate/_portal/2attach rate’,'Sales View – Drill Down Level 2′)” class=”Nav”><u>@2</u></span>
<img src=”https://www.microstrategy.com/graphics/Homepage/Feb05/icon_arrow_red.gif”>
<span onclick=”javascript:PortalPageNav(event,’/shared/attach rate/_portal/2attach rate’,'Sales View – Drill Down Level 3′)” class=”Nav”><u>@3</u></span>
<img src=”https://www.microstrategy.com/graphics/Homepage/Feb05/icon_arrow_red.gif”>
<span onclick=”javascript:PortalPageNav(event,’/shared/attach rate/_portal/2attach rate’,'Sales View – Drill Down Level 4′)” class=”Nav”><u>@4</u></span>
<img src=”https://www.microstrategy.com/graphics/Homepage/Feb05/icon_arrow_red.gif”>
<span onclick=”javascript:PortalPageNav(event,’/shared/attach rate/_portal/2attach rate’,'Sales View – Drill Down Level 5′)” class=”Nav”><u>@5</u></span>
Apologies for any confusion, but breadcrumbs are confusing, please ping me or call me for this implemetation. I would be more than happy to help out on the implementation aspect.
This entry was posted on December 7, 2008 at 9:00 am and is filed under OBIEE. Tagged: Breadcrumb obiee, breadcrumbs, Breadcrumbs in OBIEE, OBIEE, OBIEE breadcrumbs, Siebel Analytics, Sunil Ranka, sunil s ranka. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
John Minkjan said
Good one Sunil!
Thanks for sharing!
Regards John
http://obiee101.blogspot.com/
Mogens Nielsen said
Hi!
I found your page via this link OBIEE 101. I have just started using OBI and I am still learning – so bear with me if this is a stupid question.
I am trying to implement your code in a report i OBI (standard edition), but it is not working as intended. In my report the @2 variable contains the result in the second column (and @3 contains the result in the third column and so on). Is it possible to get the column header instead? In addition, the links that show up are not clickable.
I implemented your code by copy/pasting it into the ‘narrative’ field in the narrative view of my report. I have placed this narrative view above my pivot table.
Also, the tags are not showing anything in my narrative view. But the url to the images are correct and show up in my browser.
Any help is deeply appreciated!
Regards
Mogens Nielsen (Norway)
Mogens Nielsen said
Sorry, that should be
“Also, the img-tags are not showing any images in my narrative view. But the url to the images are correct and show up in my browser.”
Jay said
Hey Sunil,
Great share. I was looking for a breadcrumb solution months back but had to settle for column selectors instead.
Just to clarify, are you creating 5 different reports? One for each level? And every single report should have this narative view with the same Javascript?
Is breadcrumb dynamic where as you drill-down breadcrumb is displayed appropriately or will it always be the same with all 5 levels listed?
Rashi Nigam said
hi Sunil,
Your blog is very interesting & useful for people on this BI tool.
Please keep updating it.
thanks
Rashi
Rajesh Nadipalli said
Just a note, the “@1″ and “@2″ in OBIEE work only if they are single value fields. If you have multi select prompts there is no clean way to show bread crumbs.