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
Suppress zeroes in TM1 application
-
- 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
Disappearing and appearing values upon zero suppression means there is problem with your feeders.Thanks
"You Never Fail Until You Stop Trying......"
-
- 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
Hi bjones
Try that, see if it helps.
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.When i supress zeros the whole view dissapears.
Try that, see if it helps.
-
- 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
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
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
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Suppress zeroes in TM1 application
Try: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
Code: Select all
['Volume Frame Variance'] => ['Volume Frame Variance Percentage' ];
Robin Mackenzie
-
- 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
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
Hope that helps