Page 1 of 1

TM1 API VBA function to establish cam connection

Posted: Fri May 18, 2012 11:08 am
by kpradeep25
hi,

I am not able to login to cam connection using TM1 api function TM1SystemServerConnect. ~It appears that this function only works for standalone TM1 security. We have cam authentication enabled with cognos 8 security. Does anyone know if there's any function for cam connection?

kind regards
Pradeep

Re: TM1 API VBA function to establish cam connection

Posted: Fri May 18, 2012 1:16 pm
by Mike Cowie
Hi:

Have a look here:

http://www.tm1forum.com/viewtopic.php?f=3&t=3392
http://www-01.ibm.com/support/docview.w ... wg21418355

Should have what you need, and here are some notes I grabbed from an old post:

NOTE: there are some behavioral differences that you should be aware of with this CAMNamespace login method, as compared to native TM1 API login methods:
  • THE NAMESPACE PARAMETER IS CASE-SENSITIVE. For example, "CognosExpress" would be valid, but "Cognosexpress" would NOT be valid. User ID and Password are NOT case-sensitive.
  • Failed login error messages returned by the TM1 API are incredibly unhelpful when making a CAM Namespace login. If the login attempt fails, for whatever reason, you will almost definitely see this error message: "80: SystemServerClientNotFound"
In other words, if you get this error message when attempting a CAMNamespace login:
80: SystemServerClientNotFound

It could mean one of the following problems:
  • You entered in the wrong namespace name, or didn't use the proper case for the namespace.
  • Your user ID does not exist.
  • Your password is incorrect.
Regards,
Mike

Re: TM1 API VBA function to establish cam connection

Posted: Fri May 18, 2012 4:44 pm
by kpradeep25
Thanks a Lot Mike, this is working fine now.

this wasnt in the documentation