TM1 10.2.2 Performance Issue with Large websheets

[ardi]

Hi,

We are experiencing performance issues with large Websheets.
The websheet contains active form, connecting to a Salary Detail cube. In the cube there are a few Rules, and in the Websheet we have Action Buttons to perform some calculations and move data to other cubes. The execution Time of TI is not too bad, but because in the action button we Recalculate the Websheet before execution and also after execution, and the websheet refresh time is around 12-13 seconds, the overall performance is slow.

Also, scrolling the websheet is painful. We have been playing with TM1Web config settings, but nothing is really helping. If we increase the WebsheetRowThreshold and WebsheetRowThreshold, along with BufferSize settings, the scrolling is little bit better but then the Recalc time gets worse. Also we have tried the new parameter ( WebsheetBackgroundRecalculationMode ), but still, this slows down the websheet refresh time

Any other recommendation??

Thanks

[rmackenzie]

I had a similar experience and my conclusion was unfortunately that the design principle should be to base reports on uniformly small-sized slices and set the threshold parameters accordingly. That way there'd be a reasonable expectation of consistent performance. Obviously, saying this is one thing but doing it in practice is entirely another. There is a bit of an upside in that there's push-back for people who insist on unnecessarily large reports. However it's very limiting to work with this constraint.

It is rather bothering that the development team that migrated TM1 Web to Java-world made the threshold parameters server-wide instead of web-sheet specific.