TM1 Authentication with Cognos BI

Post Reply
mayankthu3@gmail.com
Posts: 5
Joined: Wed Oct 24, 2018 9:13 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: Excel 2016

TM1 Authentication with Cognos BI

Post by mayankthu3@gmail.com »

Hello,

I was setting up a Cognos & TM1 environment. TM1 Admin, Data and Web server all hosted in a single server. Cognos is installed on a different server.

To integrate the Cognos security with TM1, I followed the steps as recommended by IBM:
i.e. files variables_TM1.xml, planning.html, pmhub.html, and tm1web.html were placed in the Cognos server under webcontent directory & server entries modified with TM1 server details.

Deployed the instances from an already running server, Modified the required parameters inside the configuration file with ServerCAMURI and clientCAMURI entries.

Now In TM1 Client Architect or Perspectives, in Server Explorer, the list of available TM1 Servers is displayed, but it is not possible to connect to any of them with integratedSecurityMode=5 .There is no error, just a white background and nothing happens & then it hangs.

If I change the integratedSecurityMode=1 , it works fine.

This makes me believe something wrong with authentication with Cognos. But yet to get a clue.

Thanks in advance for suggestions.

Regards
Mayank
User avatar
Elessar
Community Contributor
Posts: 412
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: TM1 Authentication with Cognos BI

Post by Elessar »

Hi,
I assume that TM1 and Cognos are on different servers.
Anyway, you should add your Cognos server to 'local intranet' list in IE. With ISM=5, Architect opens a mini-IE window to authenticate (your white window), and it's blocked as pop-up window by IE
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
mayankthu3@gmail.com
Posts: 5
Joined: Wed Oct 24, 2018 9:13 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: Excel 2016

Re: TM1 Authentication with Cognos BI

Post by mayankthu3@gmail.com »

Hi Elessar,

I tried the steps as suggested but still issue persists :cry:

BR
Mayank
User avatar
Elessar
Community Contributor
Posts: 412
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: TM1 Authentication with Cognos BI

Post by Elessar »

Please paste a screenshot of this "white background"
Can you authenticate well in TM1web?
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
burnstripe
Regular Participant
Posts: 227
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: TM1 Authentication with Cognos BI

Post by burnstripe »

Stick the planning.html and pmhub.html here
<BI Install>/webcontent/bi
Create folder path
<BI Install>/webcontent/bi/tm1/web
Stick the tm1web.html here
Go to this location
<BI Install>/templates/ps/portal/
Put the variables_tm1.xml and variables_plan.xml files here.

Restart iis on bi server.
If you still can't access after this double check your parameters in tm1s.cfg for servercamuri and clientcamuri are correct, they should match the settings in your BI config

Still can't access, then a firewall may be blocking access. Test this by trying to access the BI gateway within a browser opened on your tm1/pa server. If the page doesn't render but works fine on the BI server, most likely the port BI is using is blocked
mayankthu3@gmail.com
Posts: 5
Joined: Wed Oct 24, 2018 9:13 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: Excel 2016

Re: TM1 Authentication with Cognos BI

Post by mayankthu3@gmail.com »

Hello All,

I found the solution. I wasn't able to login to CA when SSO is configured with CA gateway on IIS , This is a product bug in the version 11.16 which I was configuring.

Interim Fix pack link:

https://www.ibm.com/support/pages/cogno ... erim-fix-1

Thanks
Post Reply