TM1 Forum

Is there an easy way to clear out data that might be hiding underneath a dynamic calculation? Unlocking lines by validating picklist selections is the scenario and the problem is that unlocking a line after actuals have starting coming in brings back data that was hiding to a read only cell.

Thanks

This is a real grey area of undocumented functionality. Traditionally cell input data "hiding" under rule calculations was preserved in the cube, it was as if the rule calculations existed in a virtual cube veneer which was plastered on top of the physical cube but without any warning this changed in either 9.4 or 9.5 to a new model where leaf cells that were previously data entry becoming rule calculated had the effect of wiping out the former data entry. It was never clear if this data wiping required a save data or was instantaneous (I'm sure someone did the experiment and can share though).

However IBM seem aware of this contradiction of functionality as there is a new tm1s.cfg param RulesOverwriteCellsOnLoad which seems to be a switch to enable either the old way or the new way. Not sure whether this param applies only to 10.1 or also to 9.5.2 though ...

lotsaram wrote:... It was never clear if this data wiping required a save data or was instantaneous (I'm sure someone did the experiment and can share though).

Funny you should mention it... I did test this once upon a time and the data was cleared as soon as a rule was applied to a cell.

with 9.5.1 (CE 9.5), i get error message when i am try to write data on cells that are reference by rules using TI process. So i presume by default it can only be either or.

asutcliffe wrote:

lotsaram wrote:... It was never clear if this data wiping required a save data or was instantaneous (I'm sure someone did the experiment and can share though).

Funny you should mention it... I did test this once upon a time and the data was cleared as soon as a rule was applied to a cell.

Or accidentally deleted some elements from your dimension

winsonlee wrote:with 9.5.1 (CE 9.5), i get error message when i am try to write data on cells that are reference by rules using TI process. So i presume by default it can only be either or.

That's a different question Winson, the OP was referring to the situation where you type in a number to a cell, then a rule is subsequently applied to that cell. If that rule is then removed the value that was originally put in may still be there, depending on your version.