Viewzeroout and undefvals

Post Reply
fabpas
Posts: 18
Joined: Fri Feb 01, 2013 9:59 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: Switzerland, Estavannens

Viewzeroout and undefvals

Post by fabpas »

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
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Viewzeroout and undefvals

Post by rmackenzie »

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.
Robin Mackenzie
fabpas
Posts: 18
Joined: Fri Feb 01, 2013 9:59 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: Switzerland, Estavannens

Re: Viewzeroout and undefvals

Post by fabpas »

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