TM1 API VBA function to establish cam connection

[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

[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

[kpradeep25]

Thanks a Lot Mike, this is working fine now.

this wasnt in the documentation