Zero Out of Cube with String value as picklist

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

Zero Out of Cube with String value as picklist

Post by appleglaze28 »

I'd just like to check with you guys, when you zero out a cube with a mix of string & numeric elements and the string containing a picklist. Shouldn't the picklist be cleared of any content during zero out? I just want to check is this is normal or not in TM1 since for none picklist string elements it does clear the contents of the field.
ajain86
Community Contributor
Posts: 132
Joined: Thu Oct 15, 2009 7:45 pm
OLAP Product: TM1
Version: 9.4.1 9.5 9.5.1
Excel Version: 2003 2007

Re: Zero Out of Cube with String value as picklist

Post by ajain86 »

are you talking about clearing out the picklist selection items?
This would not clear since the picklist is on the dimension member and not related to the cube.

or clearing out the cell value which is chosen from the picklist?
This should be cleared and I have not had an issue with this.
Ankur Jain
Post Reply