Rename TM1 admin host
-
- Posts: 3
- Joined: Fri Oct 12, 2012 6:57 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007
Rename TM1 admin host
I've read other posts on guys trying to rename the TM1 admin host at the root node in Server Explorer but no-one has come up with a way to do this. Is this at all possible? We have four different admin hosts with multiple instances on each and it's frustrating having to always go back to File\Options... to see which host we're connected to. I'd prefer to be able to rename the host in some way. Short of that, I may have to put in a dummy instance under TM1 on heach host to indicate which admin host we're connected to? Any ideas? Thanks.
-
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Rename TM1 admin host
Since changing admin hosts will disconnect any open sessions on the old admin host I don't think there is any way to toggle admin hosts without going into the options dialog. But I do like your idea of a dummy server that has no purpose other than to advertise the admin host name, I just might do this myself.
You do know that you can connect to multiple admin hosts by separating with a semi-colon? Or is it that you can't do this because the servers are identically named as opposed to containing an environment identifier?
You do know that you can connect to multiple admin hosts by separating with a semi-colon? Or is it that you can't do this because the servers are identically named as opposed to containing an environment identifier?
-
- Community Contributor
- Posts: 312
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Re: Rename TM1 admin host
I use dummy instances to differentiate identically named servers, and it works without any problems. I do it primarily to enable all the user reports to run using the one server name no matter which server they are actually connected to.
Paul
-
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Rename TM1 admin host
Paul Segal wrote:I use dummy instances to differentiate identically named servers, and it works without any problems. I do it primarily to enable all the user reports to run using the one server name no matter which server they are actually connected to.
If that's the only reason for not having distinct server names there's a simple trick using the tmuser function to automatically detect the server name. It should be in the tips and useful code somewhere.
-
- Posts: 3
- Joined: Fri Oct 12, 2012 6:57 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007
Re: Rename TM1 admin host
Hi guys,
Thanks for the replies. Lotsaram, I tried connecting to multiple admin hosts but we are actually using identically named instances on the various hosts (Dev, QA and Production servers with identical instances on each) so connecting to multiple hosts in this instance is not helping but I appreciate the hint.
So it appears that we are stuck with creating a dummy instance to identify the admin host? Would be great if we could just rename the root level TM1 node....
Thanks for the replies. Lotsaram, I tried connecting to multiple admin hosts but we are actually using identically named instances on the various hosts (Dev, QA and Production servers with identical instances on each) so connecting to multiple hosts in this instance is not helping but I appreciate the hint.
So it appears that we are stuck with creating a dummy instance to identify the admin host? Would be great if we could just rename the root level TM1 node....
- wissew
- Posts: 54
- Joined: Tue Jun 17, 2008 7:24 pm
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2; 11
- Excel Version: 2003 SP3 - 2013
- Location: Beaverton, OR
Re: Rename TM1 admin host
Here's a suggestion:
Use QA & Dev as a prefix to the TM1 server name. All will be available when you list multiple hosts as the admin host. You will just need to add a find and replace to your migration process for templates and reports. You can move TM1 objects (*.pro, *.cub, etc.....) between data directories with out having to change anything.
Use QA & Dev as a prefix to the TM1 server name. All will be available when you list multiple hosts as the admin host. You will just need to add a find and replace to your migration process for templates and reports. You can move TM1 objects (*.pro, *.cub, etc.....) between data directories with out having to change anything.
-
- Posts: 3
- Joined: Fri Oct 12, 2012 6:57 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007
Re: Rename TM1 admin host
Thanks Wissew for that. I'll look into it. With the amount of changes on the templates (around 60 - 70 sheets per instance) the effort in changing the server name with find/replace might be more than the trouble of having a dummy instance. Appreciate the suggestion though!
-
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Rename TM1 admin host
Reread the hint I gave you and do a quick search in the tips. If you set up your Excel sheets correctly then there is no need to find/replace to transfer between environments with differently named servers.mvanrooyen wrote:Thanks Wissew for that. I'll look into it. With the amount of changes on the templates (around 60 - 70 sheets per instance) the effort in changing the server name with find/replace might be more than the trouble of having a dummy instance. Appreciate the suggestion though!
-
- Posts: 73
- Joined: Fri Apr 23, 2010 11:35 am
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2007 2010
Re: Rename TM1 admin host
Resurrecting this as it's not TOO old.
But... I'd like to use the semicolon separation of server names and have two different admin host names, so I can clearly see which 'servers' I'm connecting to. At the moment I'm using the workaround of prefixing UAT servers, but it's a bit ugly. Far better in archtiect to see....
TM1
server 1
server 2
server n
TM1UAT
server 1
server 2
server n
rather than
TM1
server 1
server 2
server n
UAT server 1
UAT server 2
UAT server 3
I guess there's no documented way of doing it though (tempted to try and hack the TM1 binary, but that would be mental).
But... I'd like to use the semicolon separation of server names and have two different admin host names, so I can clearly see which 'servers' I'm connecting to. At the moment I'm using the workaround of prefixing UAT servers, but it's a bit ugly. Far better in archtiect to see....
TM1
server 1
server 2
server n
TM1UAT
server 1
server 2
server n
rather than
TM1
server 1
server 2
server n
UAT server 1
UAT server 2
UAT server 3
I guess there's no documented way of doing it though (tempted to try and hack the TM1 binary, but that would be mental).
“The way I see it, you should live everyday like its your birthday”
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.