Hi,
We are using IBM Cognos for Microsoft Office and after installation, it asks for Namespace, Username and password. We are NOT using integrated log on and whenever we provide TM1 access user name password it throws error.
Any idea how to resolve this issue? Are we missing any configuration part.
TM1 10.1
Excel 2010
Thanks
kkmk
IBM Cognos for Microsoft Office
-
- Posts: 73
- Joined: Wed Jan 25, 2012 9:08 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2
- Excel Version: 2013
IBM Cognos for Microsoft Office
- Attachments
-
- Error.JPG (60.97 KiB) Viewed 4252 times
- Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: IBM Cognos for Microsoft Office
If you were using integrated login, the system wouldn't prompt for user credentials. My guess is that you have set the IntegratedSecurityMode parameter in the tm1s.cfg file to 4 or 5, which means the server is using CAM security and is prompting for CAM namespace, username and password. Note that the namespace label is case sensitive.kkmk wrote:Hi,
We are using IBM Cognos for Microsoft Office and after installation, it asks for Namespace, Username and password. We are NOT using integrated log on and whenever we provide TM1 access user name password it throws error.
Any idea how to resolve this issue? Are we missing any configuration part.
TM1 10.1
Excel 2010
Thanks
kkmk
Michel
-
- Posts: 73
- Joined: Wed Jan 25, 2012 9:08 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2
- Excel Version: 2013
Re: IBM Cognos for Microsoft Office
In the CFG it set to IntegratedSecurityMode=2
Thanks
KKMK
Thanks
KKMK
-
- Community Contributor
- Posts: 219
- Joined: Mon Jul 23, 2012 8:31 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: IBM Cognos for Microsoft Office
If you go to options and insert the System URL etc it should prepopulate the Namespace field & let you enter your Name & Password.
As for the Integrated Login, we have not been able to get that to work. It was suggested to get CAM set up but that was way too much hassle for something we only have in our Development environmnet. (Our cfg file has IntegratedSecurityMode=2 as well)
As for the Integrated Login, we have not been able to get that to work. It was suggested to get CAM set up but that was way too much hassle for something we only have in our Development environmnet. (Our cfg file has IntegratedSecurityMode=2 as well)