Suppress zeroes in TM1 application

Post Reply
bjones
Posts: 24
Joined: Tue Apr 08, 2014 4:17 pm
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 2010

Suppress zeroes in TM1 application

Post 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
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Suppress zeroes in TM1 application

Post by BariAbdul »

Disappearing and appearing values upon zero suppression means there is problem with your feeders.Thanks
"You Never Fail Until You Stop Trying......"
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Suppress zeroes in TM1 application

Post 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.
nitinsharma9891
Posts: 1
Joined: Mon Nov 03, 2014 10:21 am
OLAP Product: TM1
Version: 10.2.0.2
Excel Version: 2005

Re: Suppress zeroes in TM1 application

Post 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
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Suppress zeroes in TM1 application

Post 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' ];
Robin Mackenzie
bjones
Posts: 24
Joined: Tue Apr 08, 2014 4:17 pm
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 2010

Re: Suppress zeroes in TM1 application

Post 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
Post Reply