COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: craig_karr on 22 Apr 2010 04:34:01 AM

Title: How to avoid that Excel turns into a bottleneck in the TM1 model
Post by: craig_karr on 22 Apr 2010 04:34:01 AM
As we all know, TM1 has amazing performance thanks to the in memory technique. However in out first TM1 implementation we have used Excel and more specific active forms in Excel as the primary end user interface. We have significant performance issues and it seems like the bottleneck is not the server.

CPU usage and RAM usage on the server is very low compared to how much resources we have, but as soon as some enters data in the active forms in Excel and presses enter it takes forever before everything has been calculated and it seems like the client computer's cpu usage goes up to 100 percent and almost freezes.

What is the workaround for this? As I have understood it Excel is often used as end user interface for TM1 so it seems like we are doing something wrong. Could it be the design of the active forms?
Title: Re: How to avoid that Excel turns into a bottleneck in the TM1 model
Post by: dusherwo on 05 May 2010 08:27:56 AM
Try building an Excel layout without Active Forms. This technology is quite new and may be  - ahem - not quite settled.
But bear in mind that calculation in TM1 takes place on the server and is single threaded.
Also review your feeders.