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!
Websheet connected to wrong server
-
- Regular Participant
- Posts: 197
- Joined: Thu Dec 03, 2009 8:47 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2.x
- Excel Version: 2010
- Location: Singapore
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Websheet connected to wrong server
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.
- 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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 25
- Joined: Mon May 20, 2019 9:54 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Websheet connected to wrong server
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.
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.