4 Replies Latest reply: Apr 1, 2012 6:12 AM by Haree RSS

    Tool tip in OBIEE report

    Haree
      Hi all,

      I have an requirement to display tool tip in OBIEE report.

      When I scroll on the report data, tool tip should show the column heading.

      Thanks in advance,
      Haree.
        • 1. Re: Tool tip in OBIEE report
          user248025
          Hi,

          Solution:
          To get a tool tip for the column data of an analytics or Dashboard, follow the steps below :

          For text variables follow the steps below:

          a) On the Criteria, Right-click on the required text column and select Column Properties

          b) Once you see window for "Column Properties" click on tab "Data Format".

          c) Check mark "Override Default Data Format" and set:

          Treat text As = Custom Text Format
          Custom Text Format = [html]<p title=\""Type your tool tip here" \">@
          (Where @ is the text sign)

          For Numeric values follow the steps below:

          a) On the Criteria, Right-click on the required text column and select Column Properties

          b) Once you see window for "Column Properties" click on tab "Data Format".

          c) Check mark "Override Default Data Format" and set

          Treat Numbers As = Custom
          Custom Numeric Format = [html]<p title=\""Type your tool tip here" \">#

          ( Where # is the number sign )

          also

          References
          http://docs.oracle.com/cd/E17904_01/bi.1111/e10544/appbuir.htm#BGBIHJHD

          OBIEE 11.1.1.5: How To Get Mouse Over Tool Tips On Analysis Results or Dashboards [ID 1382310.1]
          • 2. Re: Tool tip in OBIEE report
            Haree
            Its working fine.

            Thanks a lot Davarasu.

            Thanks,
            Haree
            • 3. Re: Tool tip in OBIEE report
              Haree
              Hi Devarasu,

              Thanks for helping on this.

              But when i apply Tool tip for a column its cell width and height is getting increased.

              How to control it ?

              Thanks,
              Haree
              • 4. Re: Tool tip in OBIEE report
                Haree
                Hi all,

                I got the answer. use

                [html]<font title='Your message'>#,##,##,###

                Its working fine.