I'm seeing a marked performance difference (10x) between a refresh perfomed with a manaul F9 keystroke compared with executing an Application.Calculate in VB. This is on a worksheet with ~20k dbrw statements. The F9 method is faster.
Does TM1 "intercept" F9 when entered manually and process differently? If so, can one call the TM1 refresh directly from VB?
Thanks,
-- John
F9 versus Application.Calculate
-
Paul Segal
- Community Contributor
- Posts: 314
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Re: F9 versus Application.Calculate
Yes. Record a macro with F9 as the only keystroke, and you will see the code TM1 uses in the recorded macro. It does differ by version.
Regards
Regards
Paul
-
afshin
- Posts: 29
- Joined: Sun Sep 05, 2010 2:45 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2003
Re: F9 versus Application.Calculate
Yes TM1 will interpret F9 when entered manually you could also use the SendKeys "{F9}" .