Oracle Analytics Cloud and Server

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

Passing a URL through a Repo Variable in an Action link

Received Response
1
Views
1
Comments
Rohit Trehan
Rohit Trehan Rank 3 - Community Apprentice

Hi OBIEE supporters and friends,

I am facing a roadblock and need help.

I am trying to do the following:

Step 1:

Column Interaction for OBIEE - > Action Links -> Navigate to a Web Page

Step 2:

pastedImage_0.png

Can we pass the URL through a variable?

I tried through a Repository variable but it’s not working.

Any suggestions ?

Thanks in advance

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    I was not able to use repository variable or presentation variable in the column interaction section to describe an URL. But able to use it little different way achieving the same result.

    I have a session variable called USER_CC, I have assigned value http://google.com to it.

    Now in column properties I have declared it as html.

    pastedImage_0.png

    In formula section defined this

    '<a href="@{biServer.variables['NQ_SESSION.USER_CC']}">'||"WMBEXRMD_ENTITY"."ALIAS"  ||'</a>'   where "WMBEXRMD_ENTITY"."ALIAS"  is the actual column.

    pastedImage_1.png

    So, each member on the column will take you to google page.

    You can also use a presentation variable like this

    '<a href="@{pv_link}{http://google.com}">'||"WMBEXRMD_ENTITY"."ALIAS"  ||'</a>'