Active Form Optimization question

[tm1expert]

Hi,

I am starting to build some User Interfaces for TM1Web 10.2.2 ( with active forms ), and they are slow.

I have a TM1RPTVIEW formula and also nested RPTROW formulas. My question is more related to TM1RPTVIEW formula. Assuming that the cube has 9 dimensions, out of them, 4 are used for filtering (SUBNM formulas) and 2 are in the ActiveForm Rows ( TM1RPTRow formulas ), and 1 is used in Active form Columns. The rest are kind of hardcoded. So for these that are hardcoded filters, is it better if they are referenced in the TM1RPTVIEW formula ( with TM1RptTitle formula, same thing I'm doing for SUBNM filters )??

ALso, any other tip to improve performance?

I am new to TM1Web eventhough I have been working with TM1 for a decade now

[BariAbdul]

There is some good pointers in below link:
http://www.tm1forum.com/viewtopic.php?f=3&t=5605 Thanks

[tm1expert]

There is some good pointers in below link:
http://www.tm1forum.com/viewtopic.php?f=3&t=5605 Thanks

Thank you BariAbdul, I had already seen that thread but unless TM1 10.2.2 has changed, I really don't see any improvement. The Active form returns around 1000 rows, the same View in cube views opens so quickly, but when I build a websheet it's so slow. I have deleted all the rows below master row, there are no hidden sheets, I am using only static subsets for SUBNM formulas, and also I am using static subsets or MDX Queries for TM1RptRow formulas.

I have set manual calculations in Excel but in TM1Web, it looks like its still doing automatic calculations because everytime I change a SUBNM selection, it recalculates the Websheet ( Is this normal )? The IBM documentation does not really explain this, I went and checked the TM1web_config settings and I don't see any option there to control the manual/automatic calculation. Also, I don't see any option how to set the page size, I remember when we did a POC in 10.1, there were options to turn pagination on/off. I don't think this is possible in 10.2

Thanks

[tomok]

The Active form returns around 1000 rows, the same View in cube views opens so quickly, but when I build a websheet it's so slow.

Apples and Oranges. When you calculate a view TM1 only calculates what you can see, it calculates the rest as you scroll down and/or across. A better comparison would be how does the Active Form calculation time compare to the complete view sliced out to Excel. If they are both slow it's your cube that is slow (probably due to rule calculated values and/or feeder issues).

[tm1expert]

Thank you, i know i cannot compare cubeviews with active forms, but i was hoping there should be something i can do to improve performance. The reason why i mentioned the cube view is fast is because it loads fast and also there is no delay while scrolling up and down. And the websheet is slow while opening/refreshing and it's so slow while scrolling up and down. I do have another server with 10.1, and i tried today, and it's much better there. I have also opened a PMR with IBM and so far i have not received any help, they just sent me a link of a technote, with some recommendations ( i had already seen that list of recommendations but nothing helps). So it looks like there are known issues with TM1WEB 10.2
I keep testing with different options, and so far, no luck. IBM guy told me it could be because of formatting, and i removed formatting ( i have only one line in Formatting area and all my lines in active form, i have hardcoded the formula that returns the formatting ID (="N") and still no improvement. They also recommend to make the websheets smaller ( with only 100 rows maximum) . Yes that helped but this is something we cannot do due to requirements. So we need to do something to improve the websheets the way they are.

I saw many threads in this forum regarding slow performance in 10.2 especially the scrolling issue. IBM guy told me scrolling delay is because 10.2 refreshes only the visible rows/columns so when you scroll it will have to load/refresh the next set of rows/columns. Well, i dont think they are really doing that since if i scroll.down and then scroll back up, still same delay so if lets say i load page1 and then scroll to page2, i would expect that if i go up to page1 again, it should be fast but it's NOT.

Thanks