Calculation of not fed cells

Post Reply
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Calculation of not fed cells

Post by ioscat »

Hello, community!
As far as i know in case if cell value is asked by some rule or direct view construction, cell value is calculated independently from fed status of the cell. But unfed cells are not calculated when their values are asked indirectly (when some rule is taking value from consolidated cell). So is there any way to totally switch off all calculations in unfed cells?
This may be usefull for not to write megatonns of IF(<...condition...>, 0, <...formula...>)
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Calculation of not fed cells

Post by tomok »

Unfed cells are always calculated, they are just skipped when being consolidated into a parent, or you zero suppress a view that contains them. There is no property in TM1 that you can access in a rule that will tell you whether a cell has been fed or not. I can't think of a single valid instance where you would want to change a value in a cube based on whether it is fed or not.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: Calculation of not fed cells

Post by ioscat »

I mean if there were cgf file parameter or cube property variable that will set cell value to zero if it is not fed without firstly calculate rule for this cell
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Calculation of not fed cells

Post by tomok »

ioscat wrote:I mean if there were cgf file parameter or cube property variable that will set cell value to zero if it is not fed without firstly calculate rule for this cell
The answer is still no and for the life of me, I can't think of a single valid model design reason why a parameter or property that does this would be needed.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply