Worksheet performance in PAW is much slower than TM1Web

[mikiluo]

Currently we have upgraded our TM1 application to PAW 2.0.92 , replacing TM1Web as the application Portal.
PAW is just a portal , the worksheet is still rendering by the TM1Web backend.

But the worksheet performance is significantly slow in PAW , compared to the performance of TM1Web.
below are the performance comparision, could you pls advise us how to improve the worksheet performance in PAW ?

paw performance.jpg (94.02 KiB) Viewed 2560 times

much thanks for all your help.

[Wim Gielis]

I see that it is 20 websheets so this could cover multiple areas in the tests.
But what is done in the sheets books ?
- how many sheets ?
- how many cells approximately ?
- named ranges are all fine ?
- tests are done on equal conditions like server restart or similar ?

How is the performance in similar views in cube viewers ?

For the next points I do not know whether there is an impact or not:
- sheets (re)created with Perspectives or PAfE (not sure if that would make a difference) ?
- dynamic reports or slices or a mix of both ?
- VIEW function or not, DBR or DBRW (don’t think there is an effect to be expected)

You probably don’t have newer functions like DefineCalc or TM1Set or functions for alternate hierarchies ?