TM1 Forum

Hello guys.

Does anyone know what could be the issue here? This image below shows a downloaded websheet, a snapshot.
I connected to our DEV environment though. Somehow, I got connected to the TEST environment, and it's proven by the Server Manager function in our TEST env., the data we're getting. Weird.

On Perspectives it's working fine. But on web, the TM1USER() returns my camid for TEST environment. We have these sheets running all correct before in our previous TM1 version. No formula was changed.

Image below shows EDP TEST as the server I am connected on. Although EDP DEV is the one I logged on to.
These two instances reside in same machine. EDP PROD is in a separate machine.

As always, thanks in advance!

This is normal or expected behaviour. If the different instances share the same
- admin host
- authentication method
- username
- password

... then for each TM1User function TM1Web will attempt to log in with the same credentials as the "primary" instance (that the user logged in from).

Where multiple instances are then authenticated against it it then up to the report designer (i.e. you) to implement logic in the IF functions to determine the instance name, what the priority order should be to establish the instance to use in the DBRW & SUBNM references. (Typically I use DEV>TEST>PROD with the logic that this minimizes risk should a user be authenticated against multiple instances. But others may prefer the priority logic in reverse.)

I guess you have DEV & TEST on the same admin host. In TM1Web to only connect to a single instance at a time you need to separate the admin hosts.

hey bunchukokoy,

Did you solved this problem i am also facing the same problem.

if you have solved this can you please share the solution.

thank you.