Page 1 of 1

ViewZeroOut Function

Posted: Sat Aug 17, 2013 6:31 pm
by vins
Hi All,

I have a static picklist defined for a measure element say customer and if i use ViewZeroOut function. Will it work successfully because probably, Customer element will not allow to insert 0 value.

Waiting for your inputs!!



Thanks & Regards
Vins

Re: ViewZeroOut Function

Posted: Sat Aug 17, 2013 9:48 pm
by Wim Gielis
vins wrote:Will it work successfully because probably, Customer element will not allow to insert 0 value.
Is Customer a numeric element in the measures dimension? If not, it will be '' in a text cell instead of 0 in a numeric cell.

Anyway, the ViewZeroOut function will clear the cells in both cases.

Re: ViewZeroOut Function

Posted: Sat Aug 17, 2013 9:59 pm
by declanr
Wim's answer is entirely correct so no more information is needed there.

I would however pose the question of why you didn't just test it out? It would be a 1 minute job to create a dummy cube and process and then check the results.