Opening a websheet object that was uploaded to the TM1 server

You can open a websheet object that was uploaded.

Procedure

  1. In Server Explorer, use the Properties pane to find the TM1® assigned name for the uploaded Excel file.
    Figure 1. Example of an assigned name for an uploaded Excel file in Server Explorer
    Uploaded Excel file in the Properties pane of Server Explorer
  2. Set the value parameter using the following format: 
    value="TM1://ServerName/blob/PUBLIC/.\}Externals\
TM1_Filename

    where:

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

    For example:

    value="TM1://sdata/blob/PUBLIC/.\}Externals\Report_2006.xls_20070123212746.xls

    The complete HomePageObject parameter line looks like this:

    <add key="HomePageObject" value="TM1://sdata/blob/PUBLIC/.\}Externals\
Report_2006.xls_20070123212746.xls;Type=websheet;Description=My
Uploaded Websheet;AllowOverwrite=true" />