GroupsCreationLimit

Post Reply
Eeyore
Posts: 6
Joined: Wed Mar 04, 2009 9:32 pm
OLAP Product: TM1
Version: 9.0 SP3 64-bit
Excel Version: 2003

GroupsCreationLimit

Post by Eeyore »

Working in a 64bit 9.0 environment. No GroupsCreationLimit parameter defined in the tm1s.cfg file, so the default limit of 20 is in effect.

The TM1 Administrator's Guide says:
  • "NOTE: The GroupsCreationLimit value is not enforced when you create groups with the AddGroup function in TurboIntegrator."
I am not finding this to be true; when I tried creating groups by TI using the AddGroup function, I got the following type of error messages after exceeding 20 groups:
  • Data Source line (21) Error: MetaData procedure line (8): Maximum number of groups that can be created in the session was exceeded. Configuration parameter "GroupsCreationLimit" is currently set to 20
Questions:

Is there anything special you have to do with the TI to get it to ignore the GroupsCreationLimit value, or is the documentation wrong?

Is there any way to reset the session status, allowing creation of more groups, short of restarting the TM1 service?

Thanks.
Viet
Posts: 6
Joined: Mon May 19, 2008 8:57 pm
OLAP Product: TM1
Version: 9.4 FP2
Excel Version: 2003
Location: France, Paris
Contact:

Re: GroupsCreationLimit

Post by Viet »

Hi,

The default group creation limitation is 20 and even if you create them via TI. I had to add [GroupsCreationLimit=100] in the tm1s.cfg to be able to create 99 groups...

Viet
lotsaram
MVP
Posts: 3703
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: GroupsCreationLimit

Post by lotsaram »

The documentation is wrong, the limit is enforced in TI.

In TI you could add as many elements as you like to the }Groups dimension but any elements added above the groups creation limit would not be applied to the security model upon a security refresh so the changes would take affect from a security perspective on a restart.

Or you can increase the cfg parameter (but this should only be a temporary change to allow groups to be created, this is something to do with memory reservation for the security model and supposedly affects performance.)
Post Reply