IBM Support

Write to cube perfromance become significantly slow

Troubleshooting


Problem

Upgare from TM1 9.5.2 to Planning Analytics Local, Turbo Integrator run very slow. i.e.) One of process which execute ViewZeroOut, it run within 1 second at TM1 9.5.2 became more than 30 minuts on Planning Analyics Local.

Symptom

Turbo Integrator which execute ViewZeroOut, CellPutN are affected for performance degradation.

Diagnosing The Problem

Check tm1s.cfg that are there any different parameter is used or not.

Resolving The Problem

Customer added following parameter in the tm1s.cfg because of this is enabled in product sample like Planning Sample and SData.
ForceReevaluationOfFeedersForFedCellsOnDataChange=T

ForceReevaluationOfFeedersForFedCellsOnDataChange enable to evaluate feeders at each referenced cell data change, then it affect significant impact on performance.

When customer investigate to use ForceReevaluationOfFeedersForFedCellsOnDataChange, they need to make decision carefully.

[{"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"2.0.2;2.0.1;2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22004907