String Data Underneath ruled cells 10.2.2 FP6
Posted: Thu Nov 17, 2016 8:18 am
Hi,
Wondering if anyone has come across a solution to what seems to be a simple issue.
We have some cells that have at some point in time contained string data. They are currently being blanked out by a rule dependent on a picklist in an adjoining cell. The problem is that the presence of a rule doesn't ever seem to overwrite the underlying string data, and nothing I attempt will actually clear the underlying string.
It's not a huge issue functionally, but it is taking up memory for string data that was entered years ago that is no longer relevant, and we've come across some situations with MaximumCubeLoadThreads activated where the underlying left over string data is creating a feeder and feeding onwards throughout the model. Obviously there is a possibility this could cause performance issues if more cells are being fed than should.
Is there a way of forcing TM1 to purge the underlying string data if a rule has been applied to a cell?
Wondering if anyone has come across a solution to what seems to be a simple issue.
We have some cells that have at some point in time contained string data. They are currently being blanked out by a rule dependent on a picklist in an adjoining cell. The problem is that the presence of a rule doesn't ever seem to overwrite the underlying string data, and nothing I attempt will actually clear the underlying string.
It's not a huge issue functionally, but it is taking up memory for string data that was entered years ago that is no longer relevant, and we've come across some situations with MaximumCubeLoadThreads activated where the underlying left over string data is creating a feeder and feeding onwards throughout the model. Obviously there is a possibility this could cause performance issues if more cells are being fed than should.
Is there a way of forcing TM1 to purge the underlying string data if a rule has been applied to a cell?