Troubleshooting
Problem
In Planning Analytics for Excel, the Refresh Sheet menu recalculates all the sheets in the workbook, rather than the active one only.
This leads to poor performance.
Resolving The Problem
An additional parameter is needed in order to make Planning Analytics for Excel behaving like Perspectives used to behave, when refreshing data.
The parameter is named r41_EnableConstrainedCalcScope and must be added to tm1features.json in this manner:
{ "r41_EnableConstrainedCalcScope" : true }
Read this documentation for more information about tm1features.json file:
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzIpAAK","label":"Troubleshooting-\u003EPerformance"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
17 February 2022
UID
ibm16557228