Creating hyperlink from report column

User_JL3CW

Hi all,

I have to show link in my report, i have written the following formula in a column

'<a href=https://efjj-test.bi.em3.oraclecloud.com/analytics/saw.dll?&Path=/Shared/Custom/Procurement/BPA%20Details%20report>'||'Link'||'</a>'

and checked 'Contains HTML Markup' and am unable to see HTML in Treat Text as. PFA screen shot.

Is this Privilege issue or any other.

Regards,

Chandra.

Robert Angel

Your administrator also has to give your security group rights to use html in report content.

User_JL3CW

I am not understand what you are saying. Please detail me.

Joel

How about helping us to help you by providing all the necessary information like the OBIEE version as this has some bearing on the solution that can be provided.

User_JL3CW

Hi,

OBIEE Version: Oracle Business Intelligence 11.1.1.7.150120

Regards,

Chandra

Joel

Does the user have the "Save Content with HTML Markup" privilege?

User_JL3CW

Yes, user has "Save Content with HTML Markup" privilege.

Sherry George

Check the above thread. you have to provide the 'Save System-Wide Column Formats' privilege as well.

ps: Be careful about to whom you are providing that privilege

Joel

Not sure why you don't have the HTML option in the Data Format dropdown. I don't have 11g handy to verify (screenshot below is from 12c).

Try selecting Custom and then add the @[html]@H format mask.

Also look at this

User_JL3CW

Please explain me "Grant access to your user on 'Save System-Wide Column Formats' Option"