Product Documentation
Abstract
The WebsheetBackgroundRecalculationMode parameter determines the level of background recalculation that occurs for a websheet.
Content
WebsheetBackgroundRecalculationMode
Specifies the level of background recalculation that occurs for a websheet.
WebSheetService.scrollWebSheet calls can take several seconds because the data is not readily available. Use the WebsheetBackgroundRecalculationMode parameter to recalculate the book in the background so that the necessary data is ready when it is requested.
If set to 0 (default value), only the buffered (visible) area is calculated on a refresh of a sheet.
If set to 1, the area adjacent to the buffered area is calculated, in addition to the buffered area. This improves wait times if the user scrolls slightly away from the initially visible area.
If set to 2, the entire current worksheet is calculated. This improves wait times if the user scrolls to any area of the current sheet.
If set to 3, the entire current workbook is calculated. This improves wait times if the user moves to any area of the current worksheet or to another worksheet.
Note: The higher the setting number, the more cells are calculated meaning that there would be a higher load on the web server.
[{"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"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27043558