Chaps,
Is there a maximum number of security groups by default in 9.5.2?
Cheers,
Jim.
Max Number of Security Groups
- 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:
Max Number of Security Groups
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
-
- MVP
- Posts: 3704
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Max Number of Security Groups
If you meant to add to the question "that can be added in a single session (by default)" then the above answer is correct as the default value for the GroupsCreationLimit parameter is still 20.jim wood wrote:Is there a maximum number of security groups by default in 9.5.2?
In terms of maximum number of groups possible, as many aas you like but common sense limits should apply before any constraints due to theoretical dimension size.
Note that you can create as many elements in the }Groups dimension as you like within a server session, it is just that only groups up to and including the value set for GroupsCreationLimit will make it out of the }Groups dimension and into the security model. On a server restart everything will take effect.
Re: Max Number of Security Groups
Just to add, I found that once I exceeded a couple of hundred security groups the time it took to update through the regular GUI was painfully slow. I ended up handling the updates directly through the control cubes for small quick updates, and TI for anything larger. There was well over 1000 security groups since it eas a retail chain, and each store had different security parameters for reporting.
- 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: Max Number of Security Groups
If I'm right you can over ride the 20 with GroupsCreationLimit seting in the CFG. Any idea what maximum this has?
Cheers
Cheers
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
- 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: Max Number of Security Groups
Thanks. I had a feeling that going to be theoretical limit. Has anybody a practical limit. I may be looking at between 5-10k groups,
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
-
- Community Contributor
- Posts: 132
- Joined: Thu Oct 15, 2009 7:45 pm
- OLAP Product: TM1
- Version: 9.4.1 9.5 9.5.1
- Excel Version: 2003 2007
Re: Max Number of Security Groups
In 9.5.1, I tried doing about 10k groups because of an approval hierarchy for contributor. I experienced incredibly slow performance. After a long wait, the groups were created.
Because of the major performance issue I saw when using the security interface in contributor, I looked into ways of shortening the approval hierarchy and got it down to 1k. This improved performance significantly.
Because of the major performance issue I saw when using the security interface in contributor, I looked into ways of shortening the approval hierarchy and got it down to 1k. This improved performance significantly.
Ankur Jain
- 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: Max Number of Security Groups
Thanks for letting me know about that. I don't think I'll hit 10k so I'll give it a go with what I've built it. I'll post on here what I find,
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