TM1 Forum

Chaps,

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

Cheers,

Jim.

I believe by default it is 20.

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.

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.

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

Cheers

The max setting for that is 65535.

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.

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.

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.