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?
Paid Advertisement:
