Active Form Performance / Optimization

[image2x]

I'm running into fairly major performance issues using ActiveForms. By major, I mean:

1) ActiveSheet -> Rebuild Current Book (in Excel) takes 80 seconds. (run locally on tm1 server)
Rebuild Active Forms (in Web) takes 20 seconds.
2) Cell navigation/entry in the web with IE6/7 is painfully slow but Firefox 3.5 is fast
3) Switching between worksheets in the web is faster in IE (~5 seconds) vs Firefox (~10 seconds)

#2 is such a problem that I'm going have make sure users of this model only use Firefox.

The model itself has 6 worksheets: 1 using manually created dbrw's and 5 with ActiveForms. Each of the ActiveForm worksheets have 4 to 6 ActiveForms all using the same MDX subset definition. There are 20 active forms in total. The TM1RPTROW definition is as follows:

Code: Select all

=TM1RPTROW($B$12,"planning:ProductSCLS","","","Name",1,"{DRILLDOWNLEVEL( {[ProductSCLS].[" & 'Class Summary'!$B$6&"})}")

I'm hoping for thoughts on:
- Why there is a 4x difference in rebuild active forms time between Excel and the Web?
- Why IE cell navigation/entry is just plain unusable in this model (it works okay on other less complex models)?
- Limits on the # of ActiveForms in a model and still be usable?
- Best practices for optimizing ActiveForm performance

Thanks,
-- John

[image2x]

Well, low and behold, today everything is much snappier in both Excel and IE.

I don't know whether to be thankful things have started to work or to be ticked off that I spent so many hours yesterday chasing this issue. The TM1 service is automatically restarted over night so maybe that did something.

Anyhow, I'm still interested in hearing how far people have pushed ActiveForms with web usage (both in quantity and complexity)?