TM1 Forum

Hi All,

I am currently having issue migrating tm1 websheets where I am referencing a file using UNC path in TM1 10.2.2

### This Works - if its placed in the application folder

http://TM1WebHostName:9510/tm1web/UrlApi.jsp#
Action=Open
&Type=WebSheet
&Workbook=Applications/MyFolder/MyFile
&AdminHost=host
&TM1Server=Tm1ServerName

## But this does not - if referenced on network share

http://TM1WebHostName:9510/tm1web/UrlApi.jsp#
Action=Open
&Type=WebSheet
&Workbook= //tm1server/sharepath/filename.xlsx
&AdminHost=host
&TM1Server=Tm1ServerName

In version 10.1.1 I was able to see this file:

http://TM1WebHostName/TM1Web/TM1WebMain.aspx?
&action=OpenObject
&type=Websheet
&value=\\cusydcogapp104\TM1\Data\}Externals\NonTM1UsersReports\MyReport.xlsx

It appears the parameter = value is no longer available?

In short all I want to do is open up an excel file within a folder. Is there something missing from my syntax? Under 10.1.1 all was working fine.

Cheers

Zark

Between 10.2.0 and 10.2.2 the URL API got incrementally rolled out so there may still be bits and pieces that weren't re-implemented. Remember the underlying stack has totally changed between 10.1.x and 10.2 and there were casualties along the way e.g. the way integrated login used to work etc. I don't think you are doing anything wrong other than trying to use functionality that might not be there - best to raise an official support call.

Thanks Robin. I have raised a ticket with IBM support to see whether they can advise a solution or workaround.

Cheers

Hi All,

I have been in touch with IBM and they have logged this as a defect under: APAR PI28510. Hoping now that this is released in the next fix pack.

Cheers

Shock

They considered this a defect? I am a bit surprised that you can specify //tm1server/sharepath/filename.xlsx, because to me this seems to be a security issue (at least from an external front-end server perspective).

Hi All,

Fix has been found and resolved. See example below:

# Full compter name needs to be used

ie use: computerName.domain
instead of: computerName

#######

http://computerName.domain:9510/tm1web/UrlApi.jsp
#Action=Open
&Type=WebSheet
&Workbook=\\tm1server\sharepath\filename.xlsx
&AdminHost=computerName.domain
&TM1Server=host

Cheers

Shock