Repository Variable in web action link

2660624

Hi,

I have repository variable initialized to one url. I want to use that variable in action link to navigate to web page. Variable is working fine when used in column formula.

I have used the variable as below but its not working. I have also used @{biServer.variables['SWN_profile_option_value']} but without success.

Do anybody know how to use the repository variable  in action link to  navigate to web page.

Thanks,

Milan

[Deleted User]

Why don't you just put it into a column and then use that column value?

2660624

Can I pass the column values if I does so?? I have to pass two column values for that action link.

Joel

I think @Christian Berg point is that you could generate the URL in a column formula. For example:

and setting the data format accordingly as below:

to give:

2660624

I can do that but that's not what I am looking at. We have used the web action link in multiple reports. The url which we are using now got changed and in future too it will change. So

instead of changing the url in each report we used the repository variable so that we can change the url in just one place.

{biServer.variables.my_repository_variable} . But its not working.

Regards

Joel

you say it's not working but you'll need to provide a bit more information than that. Do you get errors, OBIEE version, does the variable work in standalone? etc etc

2660624

I am not getting any error but its taking me to web page having same url name as repository variable name as shown below.

OBIEE version is 11.1.1.9.

Yes variable works fine in standalone as i tested in column formula as  .

Regards

Jerry Casey

Joel Acha's solution works for me using this syntax:

Results look like this:

It takes me to the correct website.

Jerry Casey

That's '<a href=@{biServer.variables.variablename}>weblink</a>' without the red squiggles. I'm in 11.1.1.9.5.