MaximumCubeLoadThreads

Specifies whether the cube load and feeder calculation phases of server loading are multi-threaded, so multiple processor cores can be used in parallel.

This results in decreased server load times.

Parameter type: optional, static

To run in multi-threaded mode, you should set MaximumCubeLoadThreads to the number of processor cores on the Cognos® TM1® server that you want to dedicate to cube loading and feeder processing.

Generally, the best performance is achieved when the parameter is set to a value equal to (number off available processor cores) - 1. For example, if the Cognos TM1 server is running on a computer with four processor cores, MaximumCubeLoadThreads should be set to 3. This ensures that one processor core is available to run other applications while the Cognos TM1 server is loading.

When MaximumCubeLoadThreads is set to 0, cube loading and feeder processing is NOT multi-threaded. This is the default behavior when MaximumCubeLoadThreads is not explicitly set in the Tm1s.cfg file.

Note: When MaximumCubeLoadThreads is enabled, Cognos 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.

If your Cognos TM1 model uses conditional feeders where the condition clause contains a fed value, you should set MaximumCubeLoadThreads=0 or exclude the parameter from the Tm1s.cfg file to disable the use of multiple threads at load time.