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
N_DISCONNECT sucks
-
garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
-
Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: N_DISCONNECT sucks
Maybe running the M_CLEAR macro (flush client cache) between disconnect en reconnect will help solve some issues?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.
Michel