TM1 Forum

We are using Excel 2007 and TM1 9.5.1 HF10
- We are experiencing a problem surfaces when a user tries to pick from a subset while a form is in the process of refreshing , in that case the report freeze. If somebody has experience this issue and has the solution it would be really welcome.
- In the short term we have tried to recalculate the websheets manually. So the user makes all the subset picks they need and then they have to press the refresh button. For that:
1) We have our calculation option in excel set to “Manual”.
2) TM1REBUILDOPTION is set to 0 following the instructions from
http://www-01.ibm.com/support/docview.w ... wg21419181
3) We modifiy web.config (default location: C:\Inetpub\wwwroot\TM1Web)

<!-- If true, recalc setting of each book will be used. If false, recalc setting applies to all books. -->
<add key="UseBookRecalcSetting" value="false" />
However the calculation is still happening upon element selection via SUBNM.

Hi,

I notices you mentioned websheets, so are these TM1 Web reports? If this is the case, in my experience TM1 Web will refresh the worksheet whenever a selection is made from a Subnm formula or a drop down.

Yes I was speaking about TM1 Web, and thank you for the response.
We finally were able to disable the auto recalc even with the selection of SUBNM for now on the client will have to recalc manually the websheets.

To disable auto recalc in TM1Web, please do the following:
Open the tm1web.config file found under inetpub\wwwroot\tm1web folder.
Locate following tags
1.) <!-- If true, recalc setting of each book will be used. If false, recalc
setting applies to all books. -->
<add key="UseBookRecalcSetting" value="false" />
Change the <add key="UseBookRecalcSetting" value="false" /> to true

2.) <!-- If true, recalc will be performed each time websheet is activated,
e.g switching tabs. -->
<add key="RecalcWebsheetOnActivate" value="false" />
Change the <add key="RecalcWebsheetOnActivate" value="false" /> to true

3.) Save tm1web.config file.
4.) Restart the IIS service.