Active Form Performance in Excel and tm1 web

Post Reply
yyround
Posts: 19
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: MS 2010

Active Form Performance in Excel and tm1 web

Post by yyround » 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

yyround
Posts: 19
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: MS 2010

Re: Active Form Performance in Excel and tm1 web

Post by yyround » Fri Jul 06, 2018 1:58 am

Further to my previous post, I think I should fine-tune my question. I want to understand how data is transferred between the following:
TM1 server and TM1 web;
TM1 server and TM1 client (perspective);

Particularly with TM1 client, say when user requested to view an active form with filtering, what data gets downloaded to client's cache, is it the data with filtering or the whole cube? when no value is specified for DimensionDownloadMaxSize in tm1p.ini, what is the default size get downloaded then?

Much appreciated!

YY

Post Reply