UNDEFVALS function

Post Reply
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

UNDEFVALS function

Post by appleglaze28 »

I'd like to ask...how come when you apply UNDEFVALS in the rules..so empty cells appear empty & zero cells appear with zero. Testing the cube out...I put zero on a previously empty cell, so during zero suppression the data point with a zero isn't suppress...but when I clear the field cause I don't want any value, I can't make it appear empty. I assume when you use the data spread clear, you clear that cell as if there's no value.
Post Reply