Hyperlink object in Universe

[Former Member]

Hi,

I need assistance please with creating a hyperlink object in Universe Designer.  I'm a newbee at creating hyperlinks in Designer, and would very much appreciate your help!

The goal is to have the hyperlink launch the document stored in our SharePoint repository.  The document name is stored in the database, and the hyperlink works in Crystal Reports (Format field=>Hyperlink=>

"http://sharepoint.abc.net/Sites1/SPlrffrx/1234%20Document%20Library/"+{Document.Name}+"?OpenDocument".  I need the same functionality at the universe level so that the hyperlink could be used in various Webi reports, and available to select on future reports. 

I attempted to create the hyperlink and it just launches our SharePoint site - see sample code below:

'<a href="http://sharepoint.abc.net/Sites1/SPlrffrx/1234%20Document%20Lib/"||Document.Name||+OpenDocument/opendoc/openDocument.jsp?>'||Document.Name||'></a>'

Details:

DB type - DB2

BO version - XI R3 SP4.1

Thanks in advance for your help!

[Former Member]

Please try the derive table approach suggested in the below and see if it works for you.

http://www.forumtopics.com/busobj/viewtopic.php?p=552786&sid=442e6068b2355cba21f6853b0a048036

Thanks

Mallik