Sunil S. Ranka’s Weblog

beginning of Blogs

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

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.

6 Responses to “How To Implement Breadcrumb in OBIEE / Siebel Analytics”

  1. Good one Sunil!

    Thanks for sharing!

    Regards John
    http://obiee101.blogspot.com/

  2. 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)

  3. 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.”

  4. 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?

  5. Rashi Nigam said

    hi Sunil,

    Your blog is very interesting & useful for people on this BI tool.

    Please keep updating it.

    thanks
    Rashi

  6. 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.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>