Page 1 of 1

Deactivate automatic Recalc in TM1 Web

Posted: Tue May 03, 2016 9:06 am
by Horst
Hi community,

how can I deactivate the automatic Recalc in TM1 Web?
Typing data in consolidated elements in TM1 causes an immediate calculation (breakback on the children). I want TM1 Web to wait with the calculation until I press the recalc button. Is this possible?

I already tried to set the paramter <add key="UseBookRecalcSetting" value="true" /> to true in TM1web_config.xml and also set formula options in Excel to manual calculation. But nothing changed.

Thank you.

Re: Deactivate automatic Recalc in TM1 Web

Posted: Tue May 03, 2016 10:54 am
by Wim Gielis

Re: Deactivate automatic Recalc in TM1 Web

Posted: Tue May 03, 2016 11:34 am
by Horst
Hi,

thank you for your fast reply.

What if I've already done this? I've attached my TM1web_config.xml and Excel settings (sorry, it's in german).

I've restarted the tm1 Service and uploadet the Excel sheet into tm1 Web - but the automatic recalc is still enabled. Do you have any ideas why?

Thanks

Re: Deactivate automatic Recalc in TM1 Web

Posted: Tue May 03, 2016 11:46 am
by declanr
The automatic recalc associated with breakback on consolidated cells can not be changed as far as I am aware.