N_Disconnect slow for Integrated Login

[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?

[jameswebber]

I have a similar issue.
I'm using CAM AD security
IntegratedSecurityMode = 5

I'm using

Code: Select all

NET_CONN

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

Code: Select all

Run ("N_DISCONNECT")

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

Code: Select all

M_CLEAR

as per http://www.tm1forum.com/viewtopic.php?f=3&t=1150

error- accessing user info- on logout.jpg (60.89 KiB) Viewed 2617 times

[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?