Max Number of Security Groups

Post Reply
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:

Max Number of Security Groups

Post by jim wood »

Chaps,

Is there a maximum number of security groups by default in 9.5.2?

Cheers,

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
ajain86
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

Post by ajain86 »

I believe by default it is 20.
Ankur Jain
lotsaram
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

Post by lotsaram »

jim wood wrote:Is there a maximum number of security groups by default in 9.5.2?
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.

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.
dymoy
Posts: 16
Joined: Mon Dec 08, 2008 8:36 pm

Re: Max Number of Security Groups

Post by dymoy »

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.
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: Max Number of Security Groups

Post by jim wood »

If I'm right you can over ride the 20 with GroupsCreationLimit seting in the CFG. Any idea what maximum this has?

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
ajain86
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

Post by ajain86 »

The max setting for that is 65535.
Ankur Jain
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: Max Number of Security Groups

Post by jim wood »

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.
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
ajain86
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

Post by ajain86 »

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.
Ankur Jain
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: Max Number of Security Groups

Post by jim wood »

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.
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