Hi,
I'm relatively new to VBA and am trying to figure out how I could use VBA to check whether a user's TM1 perspectives application is connected. I'm sure this is simple. I just can't seem to find the answer anywhere though. Any help is appreciated.
TM1 Connection Status
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TM1 Connection Status
A quick and easy way is just to use a worksheet function that should return a non-zero value if the user is logged in. For example, if there's a dimension that everyone has at least some read access to you could use:cac692 wrote: I'm relatively new to VBA and am trying to figure out how I could use VBA to check whether a user's TM1 perspectives application is connected. I'm sure this is simple. I just can't seem to find the answer anywhere though. Any help is appreciated.
If Application.Run("DIMSIZ","Server:Dimname") = 0 Then
'Not logged in
Else
'Logged in
End If
NB: Post has been moved from the General forum to the Cognos TM1 forum.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.