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.
Deactivate automatic Recalc in TM1 Web
-
- MVP
- Posts: 3229
- 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: Deactivate automatic Recalc in TM1 Web
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
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
-
- Posts: 7
- Joined: Tue Dec 15, 2015 2:45 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Deactivate automatic Recalc in TM1 Web
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
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
- Attachments
-
- tm1web-config.xml.png (21.41 KiB) Viewed 3233 times
-
- Excel.png (20.81 KiB) Viewed 3233 times
-
- MVP
- Posts: 1828
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Deactivate automatic Recalc in TM1 Web
The automatic recalc associated with breakback on consolidated cells can not be changed as far as I am aware.
Declan Rodger