TM1 Forum

I know that this is probably a stupid question, but for some reason I can't find out how to do it, but does anyone have the worksheet formula which retrieves the TM1 data server name (ie the DB in Server Explorer) ?

I am proper stumped !!!!

Unfortunately I need to promote stuff between environments but the instances are not called the same resulting in a bunch of spreadsheets which are going to need updating.


Cheers
Ajay

Ajay, there is no function that would return the server name per se, but you can use the TM1USER worksheet function to that effect. It returns an empty string if the user is not logged on to a specific server, so you can use a clever set of IF statements coupled with the TM1USER function to figure out what server(s) you are connected to.

Covered here
http://www.tm1forum.com/viewtopic.php?f=3&t=4065

Thats brilliant QML and LOTSARAM.

That's worked very nicely.

Cheers
Ajay