Managing too many Security Groups

Post Reply
brinda.ts
Posts: 3
Joined: Thu Jun 05, 2014 11:18 pm
OLAP Product: Cognos TM1
Version: 10.1.1
Excel Version: 2010

Managing too many Security Groups

Post by brinda.ts »

Hi,
We have an implementation that has over 470 Security Groups. Something tells me that this is not a good sign. It is getting too hard to mantain and manage. Is this common?
In our implementation, we have Cost Centers as an approval hierarchy in the Contributor. And there is a business need to give users access through individual Cost Centers. Hence, for almost every cost center, we end up creating a new group. Is there a way to implement this better?
What is a typical scenario in other implementations?
Any suggestions will be of great help.
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: Managing too many Security Groups

Post by declanr »

If you have that mamy cost centres and people need access to only one of them then you are sort of stuck with a lot of groups.

Often users are linked with cost centres in a database somewhere else in your organisation anyway so thanks to additive security if that is the case you can automate assignment of users to group through TI and keep those groups separate from the rest of your security setup.
Declan Rodger
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: Managing too many Security Groups

Post by lotsaram »

Having a lot of security groups is not necessarily a problem in and of itself. What matters is how the security model is maintained and users assigned and the performance if the model.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Managing too many Security Groups

Post by jim wood »

I agree with Lotsa. Having many groups is sometimes something you can't get away from and when managed properly isn't an issue. What you have to think about is how you manage those groups. Obviously opening up the old GUI isn't going to cut it any longer. Also if you do use TI to manage the access / groups then you have make sure you keep the length of time that a security refresh takes. Is it quicker to insert access the details in to the control cube and then refresh or use security put? You'll only be able to say which method is better by experiementing. I guess it also depends on your down time window,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply