OBIEE Column Formula as href

OBIEE_Drool

Hello,

I have a report in which when I click on a column's data (here data is URL), it opens up an image. But, it opens up in the same window. How can I use a column formula as href and open the URL in the column data (when clicked) in a new tab?

I am using this formula with column's data format set to HTML:

'<a href='||"Table Name"."Column Name"||'target="_blank"></a>'

This doesn't work. Can someone please advise?

Thanks in advance.

Gianni Ceresa

Hi,

This as already been answered at least once (this exact same need) on here ...

First: why don't you use a column format instead of writing HTML in the formula?

When you say "This doesn't work" what do you mean? What happen? The link doesn't work or it just doesn't open in a new window?

Why don't you have anything between <a...> and </a> ? Without your link is just not visible... Don't you miss a space between ' and target ?

OBIEE_Drool

Gianni,

Yes, it has been addressed couple of times but couldn't find the right solution. Hence, a request,

1.  Do you want me to check "Contains HTML Markup" in Column Format?

2. If I don't have any HTML in my formula  and go back to actual column formula, it works after setting HyperText as column's data format. But, when I click the data in the column, it opens in the same window. I want it to open it in a new window hence I had to use HTML code. This code doesn't work.

3. I did not understand by what you meant 'not having anything'?

Thanks.

[Deleted User]

3188216 wrote:

This doesn't work. 

Yes it does.

12.2.1.0.0: http://slc02okg.oracle.com:7780/analytics/saw.dll?Answers&path=%2Fshared%2FOTN%2FURLs%20work%20in%20a%20new%20tab

11.1.1.9.0: http://slc02ojq.oracle.com:7780/analytics/saw.dll?Answers&path=%2Fshared%2FOTN%2FURLs%20work%20in%20a%20new%20tab

Prodney / Admin123 for both

[Deleted User]

ad 3.) he means <a href...></a> renders as NOTHING. <a href...>BlaBla</a> renders as BlaBla

OBIEE_Drool

Thanks Christian. But here's the problem, if I replace your URL with my column name, it doesn't work. Because my column contains data that are URL's. Please see below:

'<a href="http://www.google.com" target="_blank">This is a URL</a>'

with

'<a href="Table Name"."Column Name" target="_blank">This is a URL</a>'

[Deleted User]

You had the missing bit before - why don't you do it as you've initially written?!

'<a href="' || "Table Name"."Column Name" || '" target="_blank">This is a URL</a>'

It's not rocket science, just logic.

Gianni Ceresa

Try at least to respect the syntax a bit ....

'<a href="' || "Table name"."Column name" || '" target="_blank">this is is a URL</a>'

EDIT: Christian, same reaction in the same time

[Deleted User]

Man you're too slow :-P

OBIEE_Drool

I guess I learnt it the hard way. Appreciate it.

[Deleted User]

It's all about concatenation and proper usage of ' vs " in the right places. If this solves your issue can you please mark the appropriate responses as helpful and/or correct. Right now the thread is still open and marked as

This question is Not Answered.