How to avoid that Excel turns into a bottleneck in the TM1 model

[craig_karr]

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?

[dusherwo]

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.