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

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

This site uses Akismet to reduce spam. Learn how your comment data is processed.