Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 210 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Tooltip - Correction in HTML code
Hi !
Please have a look at below column formula picture -->
OS = Windows 8
OBI - Ver 12.2.1.0.0
Browser - Mozilla and Chrome
[Data format = HTML in Column properties ]
With this I was able to display a Team Number when I hover a mouse over Team (Name)
ex - I hovered my mouse over Team USA
However I want to make some changes in the verbiage of the tool tip.
It should display me like this -- Team ID is 11 - (at least)
( or Team ID of USA is 11) -> This will look nice )
For some reason I am not able to achieve this, some mistakes that I am making at HTML code.
Can anyone please help ?
Regards
AM
Answers
-
<span title="Team ID of USA is ' || "Cric Team"."Team ID" || '">' || ....
0 -
No :-)
But below is going closer
Regards
AM
0 -
"No"? ORLY? </sarcasm>
'<HTML><span title="The parent Brand name is ' || "Products"."Brand" || '">' || "Products"."LOB" || '</span><HTML>'
That bit above is precisely what I just proofed in SampleApp.
0 -
Super !!!!
Thank you..
It worked.
Though I have just compared/copy-pasted, for my understanding , I want to know - the meaning of quotes
( I am assuming they are single quotes ..:-) Sorry but Can you please explain ? :-)
Regards
AM
0 -
The first one already would have worked. That's why I posted code and not screenshots like you. Makes it a lot easier to read and parse.
1877648 wrote: for my understanding , I want to know - the meaning of quotes
Ok so I guess that means you didn't write any of this code. Single quotes - i.e. ' - are string terminators telling the interpreting engine when a string starts and when it ends.
If you try to modify someone else's code or copy+paste stuff from websites/blogs try to understand what it is they are doing rather than just randomly changing things.
0 -
Agreed. But frankly speaking I am still not clear with the quotes that I have used here. I am trying to understand them.
0 -
' either starts or ends a string
" is an indication for Oracle BI to interpret sth as a column. Hence the "Dimension Name"."Column Name" notation.
You are concatenating things because the browser needs to be handed a valid piece of HTML code since the browser doesn't know how to interpret "Dimension Name"."Column Name". It would just be text to it.
So your formula has to produce sth which in effect reads to the browser as
<HTML><span title="Team ID is 42">Earth<span><HTML>
0 -
Okay, I got it now. That is very well explained !
Thank you. This is really helpful.
0 -
If you get a chance install SampleApp so you can have a look at a working, running application which showcases just about any OBI functionality you could think of with real examples:
http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html
0