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