TM1 Forum

Yes that was the part that was causing my issue. I switched out what was in that parameter and it connected. Rookie mistake! Thank you all for your help!!

I had added the declare statement before the subroutine that is supposed to be establishing the connection to TM1 but it still didn't work. I believe my problem might be with these two lines: TM1SystemAdminHostSet hUser, "YourAdminHost" vServerName = TM1ValString(hPool, "YourTM1Instan...

Paul - Our production server uses IntegratedSecurityMode = 3 so unfortunately the N_CONNECT function won't work. upali - I tried using the code you linked, changing the "YourAdminHost" and the "YourTM1instanceName" but that also did not connect. I'm trying to run this code from T...

Hi all - I've been tasked with creating a excel report that connects to our TM1 production server that uses Integrated Login security. On development I was able to use the N_CONNECT function because we have a lower security. However for production I'm using the following code which runs but it doesn...