How to check if a user is connected to TM1 server in Excel?

[mce]

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

[Martin Ryan]

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

[Alan Kirk]

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.

[Oratia623]

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)

[Alan Kirk]

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.

[lotsaram]

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.