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
72
Views
9
Comments
User_JL3CW
User_JL3CW Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 5:55PM 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 & AI Strategist

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

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics & AI Lead

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

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI 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 & AI Lead

    Hi,

    OBIEE Version: Oracle Business Intelligence 11.1.1.7.150120

    Regards,

    Chandra

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

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

    pastedImage_0.png

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics & AI Lead

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

  • Sherry George
    Sherry George Rank 7 - Analytics & AI 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 Acha
    Joel Acha Rank 8 - Analytics & AI 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 & AI Lead

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