Page 1 of 1
Suppress zeroes in TM1 application
Posted: Fri Jan 16, 2015 5:20 pm
by bjones
I have an approval application with a view that has values. When i supress zeros the whole view dissapears.
I checked all the cells are fed and when i supress zeroes on the same view in Architect only zeroes are suppressed. Did anyone face this before?
I'm 10.1.1 by the way
Thanks
Re: Suppress zeroes in TM1 application
Posted: Sat Jan 17, 2015 4:47 am
by BariAbdul
Disappearing and appearing values upon zero suppression means there is problem with your feeders.Thanks
Re: Suppress zeroes in TM1 application
Posted: Wed Jan 21, 2015 10:53 am
by TrevorGoss
Hi bjones
When i supress zeros the whole view dissapears.
If your FEEDERs are sound it may be the case that you need to "kick" the source cube of the FEEDERs. By "kick" I mean either using the TI function CubeProcessFeeders(Cube) or manually "kicking" the source cube by going into the rules file and pressing enter, then saving the rules file, which causes a recalculation of all Rules and FEEDERs.
Try that, see if it helps.
Re: Suppress zeroes in TM1 application
Posted: Thu Jan 22, 2015 10:08 am
by nitinsharma9891
HI ,
I am having the same problem when I am pressing Supress 0 button, the whole column(Volume Frame Variance Percentage) get remove.
below is my rule with feeder
FEEDSTRINGS;
SKIPCHECK;
#Region 1.1
['Volume Frame Variance' ] = N: ['Tot Net Volume'] - ['Volume Frame' ];
#EndRegion 1.1
#Region 1.2 -- Leaf level Percentage
['Volume Frame Variance Percentage' ] = N: ['Volume Frame Variance'] \ ['Volume Frame' ];
#ENDRegion 1.2
#Region 1.3 -- Consolidation level Percentage
['Volume Frame Variance Percentage' ] = C: ['Volume Frame Variance'] \ ['Volume Frame' ];
#ENDRegion 1.3
FEEDERS;
# Internal Feeders
#Region 1.1
[{'Volume Frame','Tot Net Volume'} ] => ['Volume Frame Variance' ] ;
#EndRegion 1.1
#Region 1.2
[{'Volume Frame','Volume Frame Variance'} ] => ['Tot Net Volume' ] ;
#ENDRegion 1.2
Can anyone suggest why the column "Volume Frame Variance Percentage" get remove while pressing supress button
Re: Suppress zeroes in TM1 application
Posted: Thu Jan 22, 2015 12:15 pm
by rmackenzie
nitinsharma9891 wrote:I am having the same problem when I am pressing Supress 0 button, the whole column(Volume Frame Variance Percentage) get remove.
below is my rule with feeder
Try:
Code: Select all
['Volume Frame Variance'] => ['Volume Frame Variance Percentage' ];
Re: Suppress zeroes in TM1 application
Posted: Mon Jan 26, 2015 9:41 pm
by bjones
It was a feeder problem but i also saw a difference between 10.1 and 10.2 where in 10.1 when you suppress 0 you have to recalculate whereas in 10.2 it is done automatically.
Hope that helps