Performance Issues TM1Web 10.2.2

Post Reply
crichter
Posts: 7
Joined: Mon Jul 07, 2014 7:44 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2010

Performance Issues TM1Web 10.2.2

Post by crichter »

Hello all,

We have recently upgraded TM1 from 10.1.1 to TM 10.2.2 and we are experiencing severe performance issues in TM1Web (which is ironic as performance increase in calculations was one of the main reasons for the upgrade).

We followed recommended steps when uninstalling 10.1.1/installing 10.2.2.
We have also upgrade IE from 8 to 9.

I'm not really sure what more information to provide, so please ask away and I will provide all information requested.

I would provide examples of what exactly is performing slowly, but it is really everything (loading log in page, loading websheets, opening pick lists, entering values, etc etc)

Thank you in advance!
Carl
deepakjain2020
Regular Participant
Posts: 152
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

Re: Performance Issues TM1Web 10.2.2

Post by deepakjain2020 »

Hi Carl,

Are you facing same issues in TM1 Architect as well?

Regards,
Deepak Jain
crichter
Posts: 7
Joined: Mon Jul 07, 2014 7:44 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2010

Re: Performance Issues TM1Web 10.2.2

Post by crichter »

No, it seems the issues are isolated to online viewing (TM1Web). Perspectives and Architect is working well.

BR,
Carl
deepakjain2020
Regular Participant
Posts: 152
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

Re: Performance Issues TM1Web 10.2.2

Post by deepakjain2020 »

Hi Carl,

Can you please add URL into Compatibility View settings of browser and check?

Regards,
Deepak Jain
pandinus
Posts: 78
Joined: Tue Mar 18, 2014 8:02 am
OLAP Product: TM1, Cognos Express
Version: 10.2.2
Excel Version: 2013

Re: Performance Issues TM1Web 10.2.2

Post by pandinus »

In case the web is slow with scrolling you may need to increase the default row/columns that are rendered.
Check the tm1 web configuration and look for following parameters:
  • CubeViewerRowPageSize
  • CubeViewerColumnPageSize
See the following page on IBM: http://pic.dhe.ibm.com/infocenter/cx/v1 ... 50d60.html
tm1_bloke
Posts: 25
Joined: Sun Oct 13, 2013 6:03 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Performance Issues TM1Web 10.2.2

Post by tm1_bloke »

Is TM1Web running poorly if you try it on the server via RDP or just on end-user's workstation?
crichter
Posts: 7
Joined: Mon Jul 07, 2014 7:44 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2010

Re: Performance Issues TM1Web 10.2.2

Post by crichter »

deepakjain2020 wrote:Hi Carl,

Can you please add URL into Compatibility View settings of browser and check?

Regards,
Deepak Jain
I tried this, but it still very slow.
pandinus wrote:In case the web is slow with scrolling you may need to increase the default row/columns that are rendered.
Check the tm1 web configuration and look for following parameters:
  • CubeViewerRowPageSize
  • CubeViewerColumnPageSize
See the following page on IBM: http://pic.dhe.ibm.com/infocenter/cx/v1 ... 50d60.html
Thank you for the reference. In this case it is not only related to scrolling I'm afraid...
tm1_bloke wrote:Is TM1Web running poorly if you try it on the server via RDP or just on end-user's workstation?
We have tried both through RDP and also on the client's workstation, with the same results.


Of course, it is subjective what is "bad performance", as everything works but not as quickly as before. This also makes troubleshooting very complicated.

Thank you guys for the feedback so far!

BR,
Carl
crichter
Posts: 7
Joined: Mon Jul 07, 2014 7:44 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2010

Re: Performance Issues TM1Web 10.2.2

Post by crichter »

Just some more information for reference: It is the rendering of TM1Web that is slow, not actual calculations in Architect. We have noticed significant improvements in rules and feeders after the upgrade.

BR,
Carl
deepakjain2020
Regular Participant
Posts: 152
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

Re: Performance Issues TM1Web 10.2.2

Post by deepakjain2020 »

Hi Carl,

Not sure how much helpful, below link could be. give a try

http://www-01.ibm.com/support/docview.w ... 576#toggle

Regards,
Deepak Jain
Yash123
Posts: 2
Joined: Thu Aug 30, 2012 9:54 pm
OLAP Product: TM1, transformer
Version: 9.5.2
Excel Version: 2007

Re: Performance Issues TM1Web 10.2.2

Post by Yash123 »

Hi Carl
Have you found any resolution to the TM1 websheet performance issue in TM1 10.2.2 ? I am also running into the same issue with the upgrade.

Thanks
Yash
Post Reply