Dynamic Server Name

Post Reply
Posts: 2718
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA

Dynamic Server Name

Post by tomok » Thu Sep 26, 2019 3:36 pm

We just went to the IBM Cloud a month ago and we are running across an issue with the dynamic server name formulas we use to keep from having to edit reports and republish every time we migrate up the chain. The formula is like this:

In column A I have the name of one of our servers and in column B I have the following formula: =IF(TM1USER(A1)<>"",1,0)
Below the list of servers I have a formula like this: =IF(B1=1,A1,IF(B2=1,A2,IF(B3=1,A3))), which returns the active server you are logged into. This worked great in both Perspectives and TM1Web on-premise because we had a separate environment for DEV, UAT and PROD. Now that we are on the IBM cloud we only have two environments, DEV and PROD. So, we are running both a DEV and UAT service in the Cloud on the DEV environment. Now to the problem. TM1Web insists on "returning" the UAT instance in all the formulas, even when we only log into the DEV service. None of the formulas in the reports have a hard-coded reference to UAT, they all point to the named range that determines the logged into server. I know that if you have a hard-coded reference to a server then TM1Web will attempt to log into that server and return the value from that server. I did not know that the relative server formula routine would default everything to UAT when not logged into UAT. Does anyone have any ideas how to remedy this other than removing the relative server formula and hard-coding the server name?
Tom O'Kelley - Manager Finance Systems
American Tower

Paul Segal
Community Contributor
Posts: 267
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Dynamic Server Name

Post by Paul Segal » Thu Sep 26, 2019 5:08 pm

Hi Tom,

I don't have a solution for you, I'm afraid, but I'd be interested in your migration to Cloud experience when you have a spare moment, as it's something we're about to embark on.

Post Reply