Dynamic Server Name

[tomok]

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?

[Paul Segal]

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.