TM1 Forum

Posted: **Tue Jul 14, 2009 1:26 am**

Hello,
I have a excel interface that calls macros like Run("DBRA",etc,etc) or Run("W_Calc").
When I run it for the first time, sometimes it takes 18 seconds for the subroutine to complete executing.Most times, it takes 1-2 seconds. Does anyone have this problem? Does anyone have any idea whats causing the long delay and how to fix it?

Posted: **Tue Jul 14, 2009 6:59 am**

This is probably just TM1 caching the results of the calculation from the first request, this aloows it to respond faster on the next call. Theres no real way to solve it unless you calculate the results that the wkb is asking for on the server first.
Cheers

Posted: **Thu Jul 16, 2009 4:45 am**

Steve,
What do you mean by calculating the results on the server?Can you give an example?

Posted: **Thu Jul 16, 2009 7:12 am**

When you request a value from the server it needs to be calculated if it is a rule or a consolidation. Tm1 caches the result of this calcualtion which means the first time that you ask for a number it can take longer.

Edit...
Oh that's not what you meant...
You can use ViewConstruct in a TI to get the calculation to be chached, but remember those results will get discarded when a user changes a numbers

TM1 Forum

what affects speed of Run("DBRA") or "W_Calc"

what affects speed of Run("DBRA") or "W_Calc"

Re: what affects speed of Run("DBRA") or "W_Calc"

Re: what affects speed of Run("DBRA") or "W_Calc"

Re: what affects speed of Run("DBRA") or "W_Calc"