Page 1 of 1
CX9.5 - Disable Cognos Security for Xcelerator
Posted: Mon Feb 28, 2011 10:32 am
by Ganos Lal
Hi
As far as i know IBM canceled the TM1 midmarket edition and replaced it with IBM Cognos Express.
Because of this i work with the CX9.5 since a few days, but i still have a problem.
Porting databases from TM1 9.5 to CX9.5 was no problem, changing security mode from 5 to 2 reactivate the TM1 Users for Login. But if i want to create a new user Xcelerator starts the CX security (screenshot). We won't use the CX Security, so is there a posibility to disable the CX Security and using the "old" TM1 Security to create new user and groups? I hope for an additional parameter in the tm1s.cfg or tm1p.ini.
Of course we know the possibility to change the }Clients an }Groups Systemdimension, but this way shouldn't be open for the customer's administrator.
If you need to know something more feel free to ask.
Thanks for your help so far
Lal
Re: ICE9.5 - Disable Cognos Security for Xcelerator
Posted: Mon Feb 28, 2011 11:43 am
by David Usherwood
Go through the tm1s.cfg and # out the CAM related lines:
Code: Select all
[TM1S]
#CAMPortalVariableFile = portal/variables_TM1.xml
#ServerCAMURI = http://ukegmctm01:19300/p2pd/servlet/dispatch
Language = ENG
IntegratedSecurityMode = 1
#ClientMessagePortNumber = 19307
DataBaseDirectory = "D:\IBM\Cognos Express\Xcelerator\Custom\tm1data\cxmd_dev"
#UseSSL = T
#ClientCAMURI = http://ukegmctm01:19300/p2pd/servlet/dispatch
PortNumber = 59310
#ClientPingCAMPassport = 900
LoggingDirectory = "e:\ctm01_shared\xcelerator_logs_dev"
ServerName = CXMD_Dev
PerformanceMonitorOn=T
MaximumCubeLoadThreads=3
As you can see I set the security mode to 1 but it sounds as if 5 worked too.
As a side issue, I see CX used as the acronym for Cognos Express - might make it easier for people to find your postings. Small point though.
Re: CX9.5 - Disable Cognos Security for Xcelerator
Posted: Mon Feb 28, 2011 12:18 pm
by Ganos Lal
Hello David
Our problem ist not the login into the database, it works with security modes 1-3 and 5, if configured. But i allready # all CAM lines out.
Code: Select all
[TM1S]
# CAMPortalVariableFile = portal/variables_TM1.xml
# ServerCAMURI = http://ICE:19300/p2pd/servlet/dispatch
Language = DEU
IntegratedSecurityMode = 2
ClientMessagePortNumber = 19307
DataBaseDirectory = D:\Data\TM1\Sandra
UseSSL = T
# ClientCAMURI = http://ICE:19300/p2pd/servlet/dispatch
PortNumber = 19308
# ClientPingCAMPassport = 900
LoggingDirectory =
ServerName = Sandra
The problem is the security tab creating new users, it show's the logon screen from my first post and leads me to the CX Security window (Screenshot).
And we decided, we won't create new users in this way, and because of this there is the question: How can we get the old security tab back? [Right Click - New User - Tip name - Click Ok - done]
And # out the CAM lines was not the answer, so is there possible a hidden parameter for the cfg, deactivating the CX security? Found nothing about that in the op guide.
Thanks Lal
Re: CX9.5 - Disable Cognos Security for Xcelerator
Posted: Mon Feb 28, 2011 3:55 pm
by David Usherwood
You're right - I went back to check, and although the normal login comes up, there still seems to be a hook into the tedious and obscure CAM subsystem for maintaining users and groups. My solution (or rather kludge) was to write a noddy little TI to add users/groups. Apologies.
Re: CX9.5 - Disable Cognos Security for Xcelerator
Posted: Wed Mar 02, 2011 7:54 am
by Ganos Lal
Hi
I found the solution for this problem. It's a parameter in the tm1p.ini located in "C:\Users\%user%\AppData\Roamin\Applix\TM1\tm1p.ini".
There's the parameter AllowImportCAMClients = T. If it's been switch to F or # it out, Xcelerator ignore the CX Security and it all seems work like the good old TM1.
Greets Lal