Creating Hyperlinks to Uploaded Files

If you want a Websheet to contain a hyperlink to an uploaded file, the hyperlink must include the location and name that IBM® Cognos® TM1® assigns to the uploaded file.

When you add an uploaded file to a TM1 application, a copy of the file is saved on the IBM Cognos TM1 server and the file name is appended with a data and time stamp. For example:

Report_2006.xls_20070123212746.xls

If you do not include the TM1 assigned file name in the hyperlink, the link does not work in TM1 Web and an error displays, for example,

"File does not exist: TM1://planning sample/blob/PUBLIC/.\}Externals\upload_test_2.xls".

Procedure

  1. In Server Explorer, use the Properties pane to find the System Name, which is TM1 assigned name for the uploaded Excel file that will be the target of the hyperlink.
  2. Create the hyperlink to the uploaded Excel file using the following format: 
    TM1://ServerName/blob/PUBLIC/.\}Externals\
Filename

    where:

    • ServerName is the TM1 sever name where the Excel file is located.
    • Filename is the name that TM1 assigned to the uploaded Excel file.

    For example:

    TM1://sdata/blob/PUBLIC/.\}Externals\Report_2006.xls_20070123212746.xls
  3. In Excel, add the hyperlink to the worksheet where you want the link to exist.
  4. Add the worksheet to a TM1 application and then view the file as a Websheet in TM1 Web.