Single Sign On Issue between Cognos BI 10 & TM1 9.5.1

Post Reply
swati_phadtare
Posts: 14
Joined: Mon Mar 28, 2011 9:21 am
OLAP Product: TM1
Version: 9.5
Excel Version: 200

Single Sign On Issue between Cognos BI 10 & TM1 9.5.1

Post by swati_phadtare » Mon Oct 17, 2011 12:26 pm

Hi All,
We are trying to implement SSO between Cognos BI 10 & TM1 9.5.1.
So we imported logins id's from BI in TM1 & Copied rights from old userid(TM1 logins) to this new userid(Those which are imported). After changing IntegratedSecurityMode 4 (where it should accept BI/new id's), as soon as user logs in all rights given to him disappears (in TM1). When I give all the required rights back to the user & ask user to check then again rights disappears once he logs in. And when I check }ClientGroups cube in TM1 I can see no rights assigned to him. When TM1 user id has ADMIN access then this problem is not arising. This problem is coming for all users except those who have ADMIN rights.
Has anyone faced such kind of issue. Kindly throw some light on this issue
Thanks & Regards
Swati

lotsaram
MVP
Posts: 3094
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

Re: Single Sign On Issue between Cognos BI 10 & TM1 9.5.1

Post by lotsaram » Mon Oct 17, 2011 2:58 pm

This is not a bug. I suggest you RTM as this behaviour would be expected with security mode 4. In this mode both users and security group membership are defined in Access Manager. If you want users to be defined from BI but you want TM1 specific groups and group membership then you need to use security mode 5.

User avatar
jim wood
Site Admin
Posts: 3577
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Single Sign On Issue between Cognos BI 10 & TM1 9.5.1

Post by jim wood » Mon Oct 17, 2011 3:06 pm

If I remember rightly there is something in the operations guide about this. Also there is a document from IBM floating around about it. I have managed to find the document and I have attached it for you. I hope it helps,

Jim.
Attachments
cognos_auth.pdf
(393.86 KiB) Downloaded 651 times
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
jim wood
Site Admin
Posts: 3577
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Single Sign On Issue between Cognos BI 10 & TM1 9.5.1

Post by jim wood » Mon Oct 17, 2011 3:08 pm

As Lotsaram pointed out this is not a bug. I have therefore moved this to the main TM1 forum.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

swati_phadtare
Posts: 14
Joined: Mon Mar 28, 2011 9:21 am
OLAP Product: TM1
Version: 9.5
Excel Version: 200

Re: Single Sign On Issue between Cognos BI 10 & TM1 9.5.1

Post by swati_phadtare » Wed Oct 19, 2011 5:20 am

Thanks everyone.. this has solved my issue..

jhef_077
Posts: 15
Joined: Wed Oct 19, 2011 6:53 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Re: Single Sign On Issue between Cognos BI 10 & TM1 9.5.1

Post by jhef_077 » Wed Oct 19, 2011 6:59 am

Can anyone help me on TM1 web configuration my contributor page is working but the tm1 web has error:

"The forward URL does not exist or it has failed validation. Ensure that a valid forward URL is specified"

planning.html
// Update the following to point to the location of the planning service(s)
var planningServices = ["http://T01179A07.honda.com:9300"] ;

variables_tm1.xml
<?xml version="1.0" encoding="UTF-8"?>
<!--
IBM Confidential
OCO Source Materials
BI and PM: tm1fragments
(C) Copyright IBM Corp. 2008, 2009
The source code for this program is not published or otherwise
divested of its trade secrets, irrespective of what has been
deposited with the U.S. Copyright Office.
-->
<CRNenv>
<urls>

<url> http://T01179A07.honda.com/TM1Web/TM1WebLogin.aspx </url>
<url> http://T01179A07.honda.com/TM1Web/TM1We ... ndler.aspx </url>
<url> http://T01179A07.honda.com/TM1Web/TM1WebMain.aspx </url>

<url> http://T01179A07/TM1Web/TM1WebLogin.aspx </url>
<url> http://T01179A07/TM1Web/TM1WebLoginHandler.aspx </url>
<url> http://T01179A07/TM1Web/TM1WebMain.aspx </url>

<url> http://10.4.134.150/TM1Web/TM1WebLogin.aspx </url>
<url> http://10.4.134.150/TM1Web/TM1WebLoginHandler.aspx </url>
<url> http://10.4.134.150/TM1Web/TM1WebMain.aspx </url>

</urls>
<cookies>
<param name="cam_passport"/>
</cookies>
</CRNenv>

User avatar
jim wood
Site Admin
Posts: 3577
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Single Sign On Issue between Cognos BI 10 & TM1 9.5.1

Post by jim wood » Wed Oct 19, 2011 1:31 pm

I'm not sure what this has to do with single sign on? You might find that you will get a better response if you start a new thread. A lot of people on here only work with TM1 not Cognos BI so you may be missing out on valuable input.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply