Memory allocation at user group level?

Post Reply
RookieTM1
Posts: 3
Joined: Wed Oct 16, 2013 2:23 pm
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: Excel 2007

Memory allocation at user group level?

Post by RookieTM1 »

Hello!

I have a cube view that results in the TM1 Contributor error message “error 88: System Out of Memory”.

I am aware of the MaximumViewSize and MaximumUserSandboxSize in the Tm1s.cfg and there is plenty of memory on the server. My question is whether it is possible to configure these parameters at user- or user group level? For instance, could one allocate 4000 MB to users in the user group Analyst, but only 300 MB to the users in the user group Contributor?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Memory allocation at user group level?

Post by tomok »

That error is client-related, it has nothing to do with the amount of RAM you have on your TM1 server. The main culprit of this message is your view has too many intersections in it, i.e., it's just big and no, there is no setting you can set to "allocate" more memory on the client. Try to limit the number of rows via the strategic use of subsets.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
RookieTM1
Posts: 3
Joined: Wed Oct 16, 2013 2:23 pm
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: Excel 2007

Re: Memory allocation at user group level?

Post by RookieTM1 »

I also get this error message when being logged on to the server directly and running Contributor on the server. Does that make any difference with regards to your reply?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Memory allocation at user group level?

Post by tomok »

RookieTM1 wrote:I also get this error message when being logged on to the server directly and running Contributor on the server. Does that make any difference with regards to your reply?
No, because the message has nothing to do with how much memory your machine has. TM1 seems to have a fixed limit as to how big a view can be. Don't ask me what it is because I don't know, I just know when I've exceeded it. FWIW, I NEVER exceed the limit because having a view that big is impossible to effectively use and thus is a very poor design.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply