Extra Pages

▼

Tuesday, September 22, 2009

OBIEE Tooltip Text in Column Heading

On the forums every now and then the question on how to achieve this:
image
comes along, and most of the time the conclusion is that it can’t be done without some serious JS hacking. Here is a workaround which takes a little bit less effort:
First create an extra column containing your ToolTip text and column header like:
'<div title="This text explains the contence of the column">1-01  Revenue  (Sum All)</div>'
image
Set the display format to HTML:
image
Put the result in a pivot table:
image
Till Next Time

Edit: Here is an even quicker method:
http://obieepractice.blogspot.com/2008/11/column-headerooltip-mouse-over.html
at

6 comments:

  1. Michal NovySeptember 23, 2009 at 9:01 AM

    What if you want to use number or date formatting of the column? I think it is not available if you use HTML format.

    ReplyDelete
  2. John MinkjanSeptember 23, 2009 at 10:50 AM

    Michal,

    The original column is still availibe, only the header is replaced.

    Regards

    john

    ReplyDelete
  3. Kwl_PranayJainSeptember 24, 2009 at 3:05 PM

    hi John you have given solution for a pivot view.. what if i want to do the same for a table view which has write back columns..??

    ReplyDelete
  4. SharathOctober 2, 2009 at 11:35 PM

    John,
    Good post.
    There's this other interesting method I came across too.

    http://obieepractice.blogspot.com/2008/11/column-headerooltip-mouse-over.html

    ReplyDelete
  5. John MinkjanOctober 21, 2009 at 7:41 PM

    @Sharath,

    Thanks for the tip!

    regards

    John

    ReplyDelete
  6. sandolinicAugust 3, 2010 at 10:47 AM

    thank you! really cleaver.

    Nicola

    ReplyDelete

Note: Only a member of this blog may post a comment.