Sunil S. Ranka's Weblog

Superior Data Analytics is the antidote to Business Failure

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”&gt;
<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”&gt;
<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”&gt;
<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”&gt;
<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.

Advertisements

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

  7. Chris Hanley said

    Hi,

    Are you literally creating multiple reports or just one where you reference the Drill Down level? If you are using only one report – how would one display the “Drill Down Level” within a column of the report?

    Thanks,
    Chris

  8. pugazh said

    Hi….

  9. OBIEE beginner said

    Hi Nice to see this blog.

    Even My Business wants this same drill down at the column level. Will you please share me the concept of making it.Looking forward for your reply.

  10. Puja said

    Hi..I tried in same exact way as you posted..but here are issues:
    1. I did not find any hyperlink in breadcrumbs..I was able to see plain values… I could not click on any of the bread crumb path.

    2. Does all report parameters get passed on to the report if we click on breadcrumb to movue one level up?

  11. Deepti Singh said

    Hi,
    I have read “How To Implement Breadcrumb in OBIEE / Siebel Analytics”.I have understood it but I have doubt on how to implement it,where need to wirte the javascript and can we go back in steps like from month -> quarter,quarter -> year.

    Thanks,
    Deepti

  12. krishna mohan marisarla said

    Hi,

    Can you please provide me the solution for Bread Crumbs navigation.

    My requirement is:

    HomeDashboard>Dashboard1>Dashboard2>Dashboard3>Dashboard4>Current Dashboard

    this has to change dynamically based on selecting user

    Can you just tell me about this how to implement this and what is the java script for this

    Regards
    Krishna Mohan

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: