IBM Support

TM1 10.2.2 FP1 - UseBookRecalcSetting parameter added to the tm1web_config.xml file

Product Documentation


Abstract

The UseBookRecalcSetting parameter is included in the tm1web_config.xml file. When set to true, the web server honors the mode in which the Excel sheet was published. If the Excel sheet was published in Manual recalc mode, websheet data is not resent to the client until a recalculation is performed.

Content

TM1 10.2.2.1 supports manual recalculation in Microsoft Excel.


The UseBookRecalcSetting parameter uses the following format in the tm1web_config.xml
file:
<add key="UseBookRecalcSetting" value="false" />
where value is either "false" or "true"


If you set UseBookRecalcSetting to true, TM1 Web will honor the recalculation settings in the Excel worksheet. The only way to get manual recalculation mode in websheets is to enable the UseBookRecalcSetting parameter and set the calculation setting to Manual in the workbook in Excel.

When UseBookRecalcSetting is set to true


TM1 Web honors the recalculation settings in the Excel worksheet.
  • if you set Calculation Options to Automatic in the Excel worksheet, the websheet is recalculated automatically.
  • if you set Calculation Options to Manual in the Excel worksheet, the websheet is not recalculated automatically. To recalculate, you must manually click the recalc button.

When UseBookRecalcSetting is set to false
TM1 Web does not honor the recalculation settings in the Excel worksheet. Therefore, the websheet is always calculated automatically.
  • if you set Calculation Options to Automatic in the Excel worksheet, the websheet is recalculated automatically.
  • even if you set Calculation Options to Manual in the Excel worksheet, the websheet is still recalculated automatically.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27043574