Page 1 of 1
N_Disconnect slow for Integrated Login
Posted: Mon Aug 10, 2009 1:22 am
by telula
Hello,
I have a workbook to enable users to log into TM1 using Integrated Login. There is a code to run N_Disconnect when we close this workbook.I find that eversince we used Integrated Login, closing the workbook causes the workbook to hang and crash.Is there a proper way to disconnect if we use Integrated Login?
Re: N_Disconnect slow for Integrated Login
Posted: Wed Nov 30, 2011 3:26 am
by jameswebber
I have a similar issue.
I'm using CAM AD security
IntegratedSecurityMode = 5
I'm using
to connect to cxmd via the front end spreadsheet.
If the user opens server explorer then drills downs to views/cubes etc.
If the user then logs out of CE using the excel front end which my VBA calls
The get a"error accessing user information" pop up for each level of the server explorer the user is drilled into.
See below:
Anyone know of a workaround for this?
I tried
as per
http://www.tm1forum.com/viewtopic.php?f=3&t=1150
- error- accessing user info- on logout.jpg (60.89 KiB) Viewed 2620 times
Re: N_Disconnect slow for Integrated Login
Posted: Wed Dec 07, 2011 4:17 am
by jameswebber
Guys I have found that the issue occurs when users have cubes or views open in server explorer and try to log off via the front end running
Run ("N_DISCONNECT")
Unfortunately my users want the sheet to close them out of server exploer
I tried
' Opens server exlorer then closes (just incase in was open for fix CE-44)
Application.Run "TM1StartOrionWithAutomation"
CreateObject("WScript.Shell").SendKeys "%{F4}", True
Run ("N_DISCONNECT")
But this doesn't work in citrix
I was going to use GetObject to find out if Sever explorer is open, anyone know the application name for server explorer?