Unable to connect to TM1 cube from different Cognos BI env
Posted: Tue Jun 05, 2012 7:22 pm
Hi folks,
Can anybody tell me if there is a way to create a Connection within Cognos BI environment to a Cognos TM1 cube which is running in a separate server configuration?
More specifically:
I run a "departmental" Cognos BI installation that has Cognos Connection BI server, gateway, dispatcher, app server, etc. It authenticates users & groups against a corporate LDAP directory (i.e. an external namespace).
I would like to be able to run Cognos Query/Report Studio against a TM1 cube that is owned/maintained by another corporate organization. Although that TM1 cube installation authenticates users against the same corporate LDAP directory, the server infrastructure (app server, dispatcher, app server, security) is completely separate from mine.
Up until now, all external connections from my Cognos BI system have been to relational databases. Thus I created a bunch of signons that specify userid/password that are used for successful connections.
However when I create a new "IBM Cognos TM1" connection within Cognos Administration, no matter what I try, the test connection fails with a message:
http://mydispatcher:9300/p2pd IBM Cognos TM1 / Dynamic Failed XQE-DS-0006 Unable to logon to the data source.
Creating a signon or typing in my userid/password doesn't work either. The following connection string is shown by Cognos Administrator:
^User ID:^?Password:;LOCAL;TM;TM1AdminHost=MYADMINHOST.com;TM1ServerName=MYSERVER;UID=%s;PWD=%s
So for some reason the userid/password combo used in Cognos BI 10.1 connection is not being passed correctly to TM1 9.5.2. Perhaps the name of the TM1 "namespace" has to be passed as part of connection string? Something else?
I know that my userid/password combination is correct because I can connect fine to TM1 from within Excel TM1 add-in which pops up the authentication window shown in the attachment.
Are there any changes I can make to my Cognos BI system to allow my namespace/userid/password to be passed successfully to remote TM1? If possible, I would like to avoid asking admins of the corporate TM1 system to make changes to their system.
Can anybody tell me if there is a way to create a Connection within Cognos BI environment to a Cognos TM1 cube which is running in a separate server configuration?
More specifically:
I run a "departmental" Cognos BI installation that has Cognos Connection BI server, gateway, dispatcher, app server, etc. It authenticates users & groups against a corporate LDAP directory (i.e. an external namespace).
I would like to be able to run Cognos Query/Report Studio against a TM1 cube that is owned/maintained by another corporate organization. Although that TM1 cube installation authenticates users against the same corporate LDAP directory, the server infrastructure (app server, dispatcher, app server, security) is completely separate from mine.
Up until now, all external connections from my Cognos BI system have been to relational databases. Thus I created a bunch of signons that specify userid/password that are used for successful connections.
However when I create a new "IBM Cognos TM1" connection within Cognos Administration, no matter what I try, the test connection fails with a message:
http://mydispatcher:9300/p2pd IBM Cognos TM1 / Dynamic Failed XQE-DS-0006 Unable to logon to the data source.
Creating a signon or typing in my userid/password doesn't work either. The following connection string is shown by Cognos Administrator:
^User ID:^?Password:;LOCAL;TM;TM1AdminHost=MYADMINHOST.com;TM1ServerName=MYSERVER;UID=%s;PWD=%s
So for some reason the userid/password combo used in Cognos BI 10.1 connection is not being passed correctly to TM1 9.5.2. Perhaps the name of the TM1 "namespace" has to be passed as part of connection string? Something else?
I know that my userid/password combination is correct because I can connect fine to TM1 from within Excel TM1 add-in which pops up the authentication window shown in the attachment.
Are there any changes I can make to my Cognos BI system to allow my namespace/userid/password to be passed successfully to remote TM1? If possible, I would like to avoid asking admins of the corporate TM1 system to make changes to their system.