Dynamic Websheet Hyperlinks

[alexhancock]

Hello,

I am using TM1 10.1 creating a TM1 Application Web application which uses websheets to display information. We would like to link through from a websheet to a Cognos report - this can be achieved by simply inserting the hyperlink in Excel.

However, the reports are prompted and all the prompt values could be passed through from the information on the websheet itself. However, when using the HYPERLINK excel function, the dynamic link is created and works in Excel but is not recognised by TM1Web. Has anybody been able to create dynamic URLs which are accessible in websheets, and if so how?

Many thanks,

Alex