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.
Managing too many Security Groups
-
- 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
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.
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
-
- 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
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.
- 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
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.
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7