Security Groups

Post Reply
TM1ethusiast
Posts: 27
Joined: Wed Mar 06, 2013 2:48 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Security Groups

Post by TM1ethusiast »

I need to add almost 68 groups in clients and groups.When i try to add the group in client and groups it is taking me to cognos active directory which doesn't have the groups i need to have in security model.So in TI process i have wrote in prolog ADDGROUP('TEST1');

It is saving without error but iam not able to see the newly created groups in clients and groups.Secondly can i make this process dynamic to create 68 groups.Thanks and appreciate your help.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Security Groups

Post by rmackenzie »

TM1ethusiast wrote:I need to add almost 68 groups in clients and groups.When i try to add the group in client and groups it is taking me to cognos active directory which doesn't have the groups i need to have in security model.So in TI process i have wrote in prolog ADDGROUP('TEST1');

It is saving without error but iam not able to see the newly created groups in clients and groups.
I would check to see what IntegratedSecurityMode your system is running under per the tm1s.cfg file. You should actually supply this piece of information with your post on this forum as it will allow people to give you more targeted advice.

Perhaps your configuration disallows group creation outside of whatever it reads in from Cognos? The documentation isn't specific on this point, but if this is the case I imagine you're running in mode 4.
TM1ethusiast wrote:Secondly can i make this process dynamic to create 68 groups.
Of course, AddGroup takes variables as well as string literals:

Code: Select all

nCounter = 1;
nMaxCount = 68;
WHILE ( nCounter <= nMaxCount );
  sGroup = 'NEW_GROUP_' | NumberToString ( nCounter );
  AddGroup ( sGroup );
  nCounter = nCounter + 1;
END;
Robin Mackenzie
TM1ethusiast
Posts: 27
Joined: Wed Mar 06, 2013 2:48 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Re: Security Groups

Post by TM1ethusiast »

Thanks a lot for your help.
TM1ethusiast
Posts: 27
Joined: Wed Mar 06, 2013 2:48 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Re: Security Groups

Post by TM1ethusiast »

I have used the above script successfully tested add as well as delete security groups,but when did i used on real groups in the model in Dev,it is giving me error like New Group_01 doesn't exists in }groups.I checked the }groups it is there.What could be the reason.Thanks
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Security Groups

Post by lotsaram »

TM1ethusiast wrote:I have used the above script successfully tested add as well as delete security groups,but when did i used on real groups in the model in Dev,it is giving me error like New Group_01 doesn't exists in }groups.I checked the }groups it is there.What could be the reason.Thanks
You need to check the Group Creation Limit parameter in tm1s.cfg (the default value is a miserly 20). You can't create more groups than the limit in a server session. If you do this manually via the security UI it just won't let you. Programatically with TI you can add the groups without error but they only get added to the groups dimension and not to the security model itself. For the new groups to be recognized you need to restart the server.
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Security Groups

Post by declanr »

http://www.tm1forum.com/viewtopic.php?f ... 804#p39804
TM1ethusiast wrote:I have used the above script successfully tested add as well as delete security groups,but when did i used on real groups in the model in Dev,it is giving me error like New Group_01 doesn't exists in }groups.I checked the }groups it is there.What could be the reason.Thanks
Did you do the above config file change in one of your services but not your "Dev" one that is being used and failing?

Edit - Beaten by Lotsa while trying to find the topic... a lot of security topics have cropped up lately.
Declan Rodger
Post Reply