TM1 Forum

Dear all,
I use UndefVals for my cubes and I need to delete some cells' content . Not just setting the cells to 0, but really emptying the cell content, like if the cell had never got any value.
I tried the ViewZeroOut but obviously, it sets 0 everywhere. Is there a way, a similar function to ViewZeroOut which would empty the cell content?
thx for your help

Hi - I kind of agree with Michel's comments in this thread and am curious as to the real business reason you use UNDEFVALS in your cubes. It even looks like IBM are backing away from it....

Anyway, at the bottom of that thread, it looks like Duncan's advice is what you need.

Wouahh. I like this 4.94066e-324 . It seems to be exactly what I wanted although not very clean