RulesOverwriteCellsOnLoad

Prevents cells from being overwritten on Planning Analytics database load in rule-derived data.

Parameter type: optional, static

During the processing of feeders for a cube, a cube's value can be wiped out if there is a rule for that cell. When the cube that had a cell wiped out is saved, the value is gone so the action has no effect on the cube. However, if the rule is edited but the cube is not modified later, the cube is not saved to disk. In that case, real cell values might be wiped out when the rules run.

The RulesOverwriteCellsOnLoad parameter can be used to prevent the zeroing out action after a rule is edited.

If you are changing rules and the rules might cause some cells that have data to become rule-derived because of edits, set RulesOverwriteCellsOnLoad=F in the Planning Analytics database configuration.

If this parameter is set to T, rule-derived cells are wiped to zero whenever the server loads. The data value in those cells is lost even if the rule is changed later so that the cell is no longer rule-derived.

RulesOverwriteCellsOnLoad=F