TM1 Forum

Does anyone know of a way of an excel file that has been posted in an application folder knowing which TM1 instance it was opened from?

It always seems very clunky when promoting workbooks that you have to go into them and change the instance name when you move them around.

It's likely that the user would be connected to more than one instance so any approach that relies on establishing which instance the user is connected to won't work 100% of the time.

Cheers,

You can use this technique. http://www.tm1forum.com/viewtopic.php?p=18355#p18232
Assuming you are running a DQP kind of setup then this is all you need to avoid any issue with promoting of application entries.

The alternative is to run a vbs to find/replace within the contents of files 8this can be done including ActiveX object properties so can update TM1 server property of action buttons as well as cell contents.

Thanks lotsa, should have used the search function.
The solution proposed, basically asking for the username of possible servers that you are connected to and using which gives a response is workable though we have perhaps five or six different options.

Anyone have anything more "elegant"? It still has to work of course!