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.
Security Groups
-
- Posts: 27
- Joined: Wed Mar 06, 2013 2:48 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Security 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.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.
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.
Of course, AddGroup takes variables as well as string literals:TM1ethusiast wrote:Secondly can i make this process dynamic to create 68 groups.
Code: Select all
nCounter = 1;
nMaxCount = 68;
WHILE ( nCounter <= nMaxCount );
sGroup = 'NEW_GROUP_' | NumberToString ( nCounter );
AddGroup ( sGroup );
nCounter = nCounter + 1;
END;
Robin Mackenzie
-
- Posts: 27
- Joined: Wed Mar 06, 2013 2:48 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
Re: Security Groups
Thanks a lot for your help.
-
- Posts: 27
- Joined: Wed Mar 06, 2013 2:48 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
Re: Security Groups
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
-
- 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
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.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
-
- 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
http://www.tm1forum.com/viewtopic.php?f ... 804#p39804
Edit - Beaten by Lotsa while trying to find the topic... a lot of security topics have cropped up lately.
Did you do the above config file change in one of your services but not your "Dev" one that is being used and failing?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
Edit - Beaten by Lotsa while trying to find the topic... a lot of security topics have cropped up lately.
Declan Rodger