Pick list refresh rates in TM1Web 9.5.2FP2.
Posted: Thu Jul 26, 2012 3:02 pm
Hi all,
Can anyone help me with the pick list refresh rates in TM1Web 9.5.2FP2.
I have created an Excel (2007) template that the users will use as their main way of entering their data.
Using an active form with zero suppression switched on.
I have two fields that require a selection from a drop down list. Have set up the two fields with pick lists using a pick list cube along with a rule attached.
All is working fine in Excel, however when I run the template under TM1web I am getting very bad refresh rates in the sheet. Entering numbers has been improved by using FP2 however the pick lists are still taking far too long making the template un-useable (Auto calc off).
The effect I am getting is when you make a selection it refreshes the whole sheet unlike entering a number where it just turns green before you hit re-calc.
Thanks
C
I've just tried to to do this using just the Data Validation on a blank sheet with a simple a-g list (published to TM1Web) and the same thing happens. This is puzzling behavior why should the sheet be refreshed every time in TM1Web yet it does not happen in Excel? I can't be the only one to notice this, others must be using pick lists as well? How are others using pick lists in TM1web?
Can anyone help me with the pick list refresh rates in TM1Web 9.5.2FP2.
I have created an Excel (2007) template that the users will use as their main way of entering their data.
Using an active form with zero suppression switched on.
I have two fields that require a selection from a drop down list. Have set up the two fields with pick lists using a pick list cube along with a rule attached.
All is working fine in Excel, however when I run the template under TM1web I am getting very bad refresh rates in the sheet. Entering numbers has been improved by using FP2 however the pick lists are still taking far too long making the template un-useable (Auto calc off).
The effect I am getting is when you make a selection it refreshes the whole sheet unlike entering a number where it just turns green before you hit re-calc.
Thanks
C
I've just tried to to do this using just the Data Validation on a blank sheet with a simple a-g list (published to TM1Web) and the same thing happens. This is puzzling behavior why should the sheet be refreshed every time in TM1Web yet it does not happen in Excel? I can't be the only one to notice this, others must be using pick lists as well? How are others using pick lists in TM1web?