Page 1 of 1

Calculation of not fed cells

Posted: Fri Mar 22, 2013 12:39 pm
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...>)

Re: Calculation of not fed cells

Posted: Fri Mar 22, 2013 1:14 pm
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.

Re: Calculation of not fed cells

Posted: Fri Mar 22, 2013 2:54 pm
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

Re: Calculation of not fed cells

Posted: Fri Mar 22, 2013 4:03 pm
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.