Active Form Performance in Excel and tm1 web
Posted: Fri Jul 06, 2018 1:00 am
Hi,
I was just wondering why the same active form runs a lot longer in excel than in web?
With the filter i put in, the active form returns 2000+lines, but excel takes about 30-40 seconds while in web it is so swift scrolling down to the bottom of the form.
I check my memory and cpu usage, it is far from reaching the limit, CPU running at 7-10% and Memory is minimal.
The active form have MDX to do text search and without any filtering the form can potentially return 130k+ lines. The test run i did has no text search and only for a small subset.
Thanks in advance.
YY
I was just wondering why the same active form runs a lot longer in excel than in web?
With the filter i put in, the active form returns 2000+lines, but excel takes about 30-40 seconds while in web it is so swift scrolling down to the bottom of the form.
I check my memory and cpu usage, it is far from reaching the limit, CPU running at 7-10% and Memory is minimal.
The active form have MDX to do text search and without any filtering the form can potentially return 130k+ lines. The test run i did has no text search and only for a small subset.
Thanks in advance.
YY