"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”.
