Start local Excel file from tm1

[nlashin]

Hello, colleagues!

I faced with situation when i need to start Excel File from tm1. For example, in drill process from cell which contain excel file path. First of all, i need to open excel.exe and then set file path as parameter by using ExecuteCommand function. But the problem is that i need start local Excel.exe, but not at the server.

Maybe you have some ideas how we can solve this problem.

Best regards, Lashin Nikita
Russia, Moscow

[declanr]

Don't see you being able to do this in a drill process since the process will always be running on the server with no knowledge of which PC it was initiated from.

You haven't specified which of the many TM1 clients you are using in this scenario?

[nlashin]

It will be nice if it will work in TM1Web.
Maybe tm1 have other possibilities to open excel file which based at the server. (in excel)

[lotsaram]

I don't know what you need a drill process for. All you need to do is present a DBRW cell containing a string value hat is a hyperlink or UNC path to the Excel file. As long as TM1 Web sees the hyperlink as being an external reference then excel will launch automatically and the file will open in Excel. I have used this a lot in the past to present downloadable, pre-saved, canned reports to users via TM1 web.

If the hyperlink is internal (within the tm1web virtual directory or whatever the tomcat equivalent name for that is) then TM1 web will not launch Excel but will open the url as a websheet.

[nlashin]

Please, could you explain how to convert a value in the link and go to Excel. The screenshot below:

121.JPG (82.93 KiB) Viewed 5131 times

[declanr]

=Hyperlink(link,Name)

From memory though putting a hyperlink formula inside an active form can produce sketchy results depending what version of TM1 you are on.

[nlashin]

Works fine. Thanks!