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
Viewzeroout and undefvals
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Viewzeroout and undefvals
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.
Anyway, at the bottom of that thread, it looks like Duncan's advice is what you need.
Robin Mackenzie
-
- 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
Wouahh. I like this 4.94066e-324 . It seems to be exactly what I wanted although not very clean 
