Oracle Analytics and AI

Rohit Trehan

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:

Can we pass the URL through a variable?

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

Any suggestions ?

Thanks in advance

ArijitC

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.

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.

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>'