CX9.5 - Disable Cognos Security for Xcelerator

Post Reply
User avatar
Ganos Lal
Posts: 39
Joined: Fri Oct 29, 2010 8:56 am
OLAP Product: TM1
Version: TM1 11
Excel Version: 2019 + 365
Location: Switzerland - Neuenhof
Contact:

CX9.5 - Disable Cognos Security for Xcelerator

Post 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
Attachments
Sorry for the german Screen ;)
Sorry for the german Screen ;)
Login.jpg (61.47 KiB) Viewed 3871 times
Last edited by Ganos Lal on Mon Feb 28, 2011 11:54 am, edited 1 time in total.
End of time.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: ICE9.5 - Disable Cognos Security for Xcelerator

Post 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.
User avatar
Ganos Lal
Posts: 39
Joined: Fri Oct 29, 2010 8:56 am
OLAP Product: TM1
Version: TM1 11
Excel Version: 2019 + 365
Location: Switzerland - Neuenhof
Contact:

Re: CX9.5 - Disable Cognos Security for Xcelerator

Post 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
Attachments
CX Security to create new user
CX Security to create new user
secu.jpg (76.48 KiB) Viewed 3856 times
End of time.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: CX9.5 - Disable Cognos Security for Xcelerator

Post 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. :oops:
User avatar
Ganos Lal
Posts: 39
Joined: Fri Oct 29, 2010 8:56 am
OLAP Product: TM1
Version: TM1 11
Excel Version: 2019 + 365
Location: Switzerland - Neuenhof
Contact:

Re: CX9.5 - Disable Cognos Security for Xcelerator

Post 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
End of time.
Post Reply