TM1 Web Action Button Load Time

Post Reply
tm1newb
Posts: 4
Joined: Mon Oct 13, 2014 10:39 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 10

TM1 Web Action Button Load Time

Post by tm1newb »

All,

I have a list of TM1 web action buttons that are basically links with a few variables passed onto a detailed input sheet.

Using 10.2.2 through Chrome, Firefox, and IE browsers, the process called 'Websheetservice.executeactionbutton.dwr' is taking around 8-12 seconds for a .3KB button. This is amazingly slow for a tiny amount of data transferred. Logging a ticket into IBM, they had stated that any load time under 10 seconds is good.

This seems too slow with me and all the users are not happy either. Does anyone have experience with this or best practices with the TM1 Action buttons on the web? Thanks!
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: TM1 Web Action Button Load Time

Post by paulsimon »

Hi

Can you give some more details - how many Action Buttons do you have?

Is there a reason that you can't make selections on the same sheet?

I use a technique of storing the selections in a cube dimensioned by user and use this to pass from one sheet to another rather than using Action Buttons. That might be a way to go.

Regards

Paul
tm1newb
Posts: 4
Joined: Mon Oct 13, 2014 10:39 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 10

Re: TM1 Web Action Button Load Time

Post by tm1newb »

We have a main sheet around 300 lines. Each line has an action button where user clicks into a "detail" type page for the line.

Have made all sorts of adjustments to both the main sheet and detail type sheets. Management was pushing for near instant load for these detail sheets, but at the moment, the java execute action button is taking 10 seconds.

Still playing around with tomcat:
http://www-01.ibm.com/support/docview.w ... wg21669247

now looking at the java virtual machine
http://www-01.ibm.com/support/knowledge ... m_v61.html

neither have provided speed increases at the moment
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 Web Action Button Load Time

Post by Wim Gielis »

If you use an Action button, you can also make it jump to a detail sheet by parsing the DBRW formula that the user selects.
Look in the advanced properties for the Action button to use such an argument to a DBRW formula in the jump to a detail sheet.
Much much better than 1 action button per row.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply