TM1 Forum

Anyone found a better way of disconnecting from TM1 via VBA? N_DISCONNECT kills all servers and doesn't give the system a chance to recognise that the user has fully disconnected from the server so relogging as a different user creates an issue where the security is as per last user, MDX is as per last user, etc.

Anyone have a better way of doing it?

TIA

garry cook wrote:N_DISCONNECT kills all servers and doesn't give the system a chance to recognise that the user has fully disconnected from the server so relogging as a different user creates an issue where the security is as per last user, MDX is as per last user, etc.

Maybe running the M_CLEAR macro (flush client cache) between disconnect en reconnect will help solve some issues?

Michel