TM1 Forum

Hi,
using Cognos TM1 10.1.1 fixpack 2 on Windows 2008 R2. The data are accessed from Cognos BI reports. Some of the reports takes a lot of time to display. Looking at Windows Task Manager I see 25% of CPU is occupied that is exactly one single core out of 4 CPU cores that computer has. Is there a way to set that TM1 is using multiple CPU cores instead of just one? In tm1s.cfg I have set MaximumCubeLoadThreads=3 and restarted tm1 service. But I see no effect, 25% of whole CPU power is used.

Details about this parameter:
http://pic.dhe.ibm.com/infocenter/cbi/v ... s_tm1.html

Is there a way to set that tm1 should use more then 1 CPU core?
Thanks

Hi,
Not in 10.1.1, one query will always use one thread. You can try it with 10.2, you will find documentation of the MTQ parameter (to be placed into the tm1s.cfg file).
MaximumCubeLoadThread is used only during server startup

I'd suggest you look into optimising the TM1 side of the content you wish to report eg setting up a frozen cube and running a ViewConstruct after update. MTQ would help if you had it, but you don't.