Connecting to TM1 cube from Cognos BI in separate installations

[Gene]

Hi folks,

I'd like to know if it is possible to connect/use TM1 cube from a Cognos BI (i.e. Query/Report Studio) that are configured in different systems.

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 TM" 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 through via TM1 9.5.2 api.

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 userid/password to be passed to remote TM1?  If possible, I would like to avoid asking admins of the corporate TM1 system to make changes to their system.

Thanks in advance,

Gene

[bi4u2]

Gene,

We received the attached screenshots from an IBM Support Analyst as a quickstart to integrating TM1 & BI.

[Gene]

Thank you, but it doesn't look like the document addresses the situation I am in.

The TM1 server is already configured to use BI authentication -- that's how I currently access TM1 from Excel add-in.

My issue is that BI authentication system set up to manage TM1 is completely separate from my BI authentication system.

I believe what needs to happen is for the "IBM Cognos TM1" connection that I set up to talk to TM1 is to pass the userid & pasword (plus possibly name of BI namespace) to the remote system and be used for BI authentication in the same way that TM1 Excel add-in prompts me interactively for userid/password.

For whatever reason, this is not happening -- connection from my BI system to TM1's BI authentication is rejected as having incorrect userid/password.

Gene

[Rahul Ganguli]

Hi Gene,

I beleive there is some issue with TM1 web connectivity from Cognos server.
Can you try to open TM1 web from the Cognos server and try to login there, If this works connection from cognos should also work.

Regards,
Rahul

[Gene]

I was subsequently told by Cognos architect that there is no mechanism in place to pass Passport credentials from one Cognos Content Manager (which performs external LDAP authentication) to another separate Cognos Content Manager (which hosts TM1 and also performs external LDAP authentication) as part of a connection string.

So there is no obvious way to make this work.

Gene