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

[telula]

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?

[Steve Rowe]

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

[telula]

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

[Steve Rowe]

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