Home » BI Answers

Hover Text on columns in OBIEE

16 May 2010 7,465 views 11 Comments
1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Loading ... Loading ...
Hi Frens,
Here I m back again…
This time i have got a real nice thing with me ‘Hovering text in OBIEE columns‘.
This requires HTML or Javascript coding in OBIEE column headers which is not permitted by default OBIEE config. So, to enable it, we need to insert the following tag in instanceconfig.xml file.
<HardenXSS>false</HardenXSS>

Before modifying the instanceconfig.xml take the backup of the file and stop the OBIEE Presentation services. Modify the instanceconfig.xml file and place the above tag anywhere between the server tags.
Now,start the Presentation Services again. Login to Answers and embed the below mentioned code in the header of the column where you want the text to hover when you display the report.
<b title=”Text to Hover”>column_name</b>

After doing this save the report and roll over your mouse to the column header where you have placed the code, you can see the ‘text to hover’ over the column header.

This can act good with some stern customers with such requirements.

Have a good time and keep posting…


11 Comments »

  • srinivas said:

    Obiee Roporting tool :

    We have to install specially(Custamisatioin) ?

    or It comes with oracle 11i ?

    # 4 June 2010 at 6:38 PM
  • Rohit (author) said:

    Hi srinu,

    OBIEE doesnt come with Oracle 11i, you need to install it separately.

    # 8 June 2010 at 10:49 PM
  • santu said:

    hI rohit..thanks man

    # 10 February 2011 at 7:47 PM
  • Neha said:

    I am trying to add the following property to a column on BIEE 11g

    Criteria -> Column Properties ->Column Format ->Column Heading

    column_name

    My question is that can I read “text to hover” from any external file instead of hard coding this value here?

    There are two ways in my mind to get this feature:

    1.By embedding a dynamic variable here and initialize that variable at RPD. This will also enable internationalization of this value.
    2. Somehow making use of DHTML/Javascript to read this value from an external XML file.

    Has anyone accomplished this functionality?

    Any inputs will be very helpful!

    Thanks in advance!

    # 15 July 2011 at 1:38 AM
  • Rohit (author) said:

    Hi Neha..

    I would have to say a nice requirement… Need to try this.. I am not sure about the second alternative that you suggested but can try the 1st one… Infact i did try that once but it didn’t work for me.. I am not sure if any new functionality is added in 11g for this….
    But will try again. Let me know if you get successful with this as I would really like to learn this….

    # 16 July 2011 at 4:15 PM
  • Barb said:

    I have a report in OBIEE 10g. I am able to create the hover-text but when I add it to a date or numeric field I loose my formatting. Does anyone know how to re-gain my formatting?
    I’m using the following in the column Properties / Data Format / Custom Text Format: @[html] @H</b

    Any help would be appreciated.

    # 31 August 2011 at 8:34 AM
  • Barb said:

    I see my html code gets changed when I submit online.This information get posted between these tages: @[html] @H
    title=”Date”

    # 31 August 2011 at 8:37 AM
  • Rohit (author) said:

    Hi

    I tried the same but I wasnt able to replicate what you said. The formatting was As-is even with the Hover Text appearing.
    Kindly list out the steps that you followed for the same.

    # 31 August 2011 at 4:56 PM
  • Barb said:

    I have added the following to the column formula:
    SUBSTRING(cast( “Order Details”.”Realistic Ship Date” as char) FROM 1 FOR 11)
    but this give me the date format of: 20-sep-2011. (I’m cutting off the time)

    I have added the following to the “Column Properties / “Data Format” / Custom Text Format field:
    @[html] @H
    This works very well for character fields but does not work for the date or numeric fields.
    I want the date to display in the following format: MM/DD/YYYY. Currently the date is defaulting to dd-mmm-yyyy (system default)

    I have added the following to the column formula:
    cast(“Order Dollars & Margin”.”Sales Amount” as char)

    I have added the following to the “Column Properties / “Data Format” / Custom Text Format field:
    @[html] { b title=”Sales_Amount”}@H{/b} –Brackets get replaced with signs.

    I want to be able to format my money with comma separators: 704,424.00 instead of 704424.

    If there is a better way to accomplish this I would be willing to give it a try.

    # 31 August 2011 at 7:27 PM
  • Rohit (author) said:

    Hi,

    I have tried the steps and I am not facing any issues. I am able to display the Hover Text both in Date as well as char formats. Moreover, I think you dont have to write HTML in Custom Text Format field.
    Steps to follow:
    1) Alter the instanceconfig file and add the tag false.
    2) Add HTML in column heading of your column(be it a date or any column).
    3) Select the format which you want to select for Date(in case of Date columns).
    4) Display results.

    This worked for me…
    Kindly let me know in case of issues…

    # 6 September 2011 at 6:46 PM
  • Pradeep said:

    Hi Rohit,

    I tried the above thing,but somehow its not working for me.The steps I have taken are

    1.Added the tag false in Instanceconfig file.and restarted the presentaton service.
    2.In Criteria->ColumnProperties->Columnformat->Custom Heading->
    C1 CustomerName
    I saved the report and wen I ran the above text is getting displayed under all the columns,pls let me know where I am going wrong

    Thanks in adv,

    # 18 October 2011 at 2:34 PM

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

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

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.