About MaximumCubeLoadThreads parameter in the TM1s.cfg

Post Reply
kiss351523
Posts: 51
Joined: Thu May 05, 2011 2:05 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007 and 2003
Location: Asia

About MaximumCubeLoadThreads parameter in the TM1s.cfg

Post by kiss351523 »

"When MaximumCubeLoadThreads is enabled, TM1 cannot manage the order in which feeders are calculated. There may be cases where processing order has an adverse effect on your application due to some order-of-evaluation dependencies in the multi-threaded environment."
I dont kown what is that , Any one had some instances or cases?
User avatar
qml
MVP
Posts: 1096
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: About MaximumCubeLoadThreads parameter in the TM1s.cfg

Post by qml »

What are you asking about, exactly? If we use this parameter or if we've come across the issues described when it's turned on?

This parameter can speed up load times, especially if you have many computationally intensive cubes (large data volumes and/or many feeders).

However, this parameter should not be used (or used with extreme caution) if you have intercube feeders dependent on other feeders and/or if you use conditional feeders. Also, multithreaded load can cause TM1 to use significantly more (garbage) memory than single threaded load, so be cautious and run some tests with different settings.
Kamil Arendt
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: About MaximumCubeLoadThreads parameter in the TM1s.cfg

Post by Martin Erlmoser »

per default tm1 server uses only ONE thread for starting up.
if you use rules with feeders these feeder calculations can be speeded up by changing the mentioned parameter, or you just use "PermanentFeeders" which gives a better performance boost for startup as long as it works and the feeder files are uptodate.
User avatar
qml
MVP
Posts: 1096
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: About MaximumCubeLoadThreads parameter in the TM1s.cfg

Post by qml »

Martin Erlmoser wrote:"PermanentFeeders"
Persistent Feeders. :geek:
Kamil Arendt
kiss351523
Posts: 51
Joined: Thu May 05, 2011 2:05 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007 and 2003
Location: Asia

Re: About MaximumCubeLoadThreads parameter in the TM1s.cfg

Post by kiss351523 »

Ths All,i think i could understood.
Post Reply