Link Webi Report to External URL using URL contained in Dim Object

686 Views

I am trying to create a link in my WebI report to an external URL which is stored in a Dimension object.

The object is simply a string format which contains a link to a Lotus Notes database

Example:

Notes:///CA2573920000079B/0B4D8972EDD5DE7CCA257109000682B7/32250ACFEAF2B80FCA2573AB00831255

When I put the link into Internet Explorer I get the appropriate Lotus Notes databse, however, when trying the same in WebI using the following formula:

="<a href=[Notes url1] target='_blank'>Test</a>"

I get the following URL when clicking the link from InfoView

http://auyhoz04.an.orica.net:8080/businessobjects/enterprise115/desktoplaunch/viewers/cdz_adv/[Notes%20url1]

If I hardcode the URL into WebI

="<a href='Notes:///CA2573920000079B/0B4D8972EDD5DE7CCA257109000682B7/32250ACFEAF2B80FCA2573AB00831255' target='_blank'>Test</a>"

It works without a problem.

I'm sure I'm missing something simple...is anyone able to help?