"C" for Clear or Zero (all child values in a cube)

In TM1, what’s the easy way to zero all the values in a cube, or all the child values of a parent?

Easy, open the cube in Architect, navigate to the total you want to clear out and press “C”.You’ll then be asked if you want to perform a ‘Clear’ operation.  Say yes and Zap. Gone. All zeros.

Too easy!

Just as an aside, you can’t do it to an intersection that is Rule driven – it must be from a value that has a natural hierarchy.  So I tried to zero All Years from Current Forecast where I have a rule driving Actuals into historic periods in the forecast and I got an error saying the “Spreading operation has failed because the content of the cells cannot be modified”.

You might also like