TM1 Forum

Hi,

In an Excel spreadsheet, using VB or Excel Macro code, how can we check if a user is connected to a TM1 server or not?
This is to avoid running n_disconnect or n_connect blindly without checking if the user is really connected or not.

Any help would be appreciated.

Regards

Try this one: http://applixforum.olapforums.com/viewP ... tion#36072

mce wrote:Hi,

In an Excel spreadsheet, using VB or Excel Macro code, how can we check if a user is connected to a TM1 server or not?
This is to avoid running n_disconnect or n_connect blindly without checking if the user is really connected or not.

Any help would be appreciated.

Regards

Another way is to just do a DBR to a cube that all users have access to. (Create one if you need to.) If it returns the expected value, they're connected.

I use the worksheet function: TM1User("ServerName"). If it returns a blank - then they are not connected.
Though I am not sure in what version this function was introduced (I am using TM19.5.1)

Oratia623 wrote:I use the worksheet function: TM1User("ServerName"). If it returns a blank - then they are not connected.
Though I am not sure in what version this function was introduced (I am using TM19.5.1)

9.1 SP2.

Martin Ryan wrote:Try this one: http://applixforum.olapforums.com/viewP ... tion#36072

Wow that post was a blast from the past, shame there are no dates on the old Applix forum threads.