Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Creating hyperlink from report column

Received Response
71
Views
9
Comments
User_JL3CW
User_JL3CW Rank 6 - Analytics Lead
edited August 2024 in Oracle Analytics Cloud and Server

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.

pastedImage_0.png

Is this Privilege issue or any other.

Regards,

Chandra.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

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

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics Lead

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

  • Joel
    Joel Rank 8 - Analytics Strategist

    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
    User_JL3CW Rank 6 - Analytics Lead

    Hi,

    OBIEE Version: Oracle Business Intelligence 11.1.1.7.150120

    Regards,

    Chandra

  • Joel
    Joel Rank 8 - Analytics Strategist

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

    pastedImage_0.png

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics Lead

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

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    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
    Joel Rank 8 - Analytics Strategist

    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).

    pastedImage_0.png

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

    Also look at this

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics Lead

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