ForceReevaluationOfFeedersForFedCellsOnDataChange

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

ForceReevaluationOfFeedersForFedCellsOnDataChange

Post by macsir »

Just a thought, if this parameter is not set, is there any possibility that you got wrong result because the conditional feeders are not re-evaluated automatically? If yes, how to prevent it?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
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: ForceReevaluationOfFeedersForFedCellsOnDataChange

Post by tomok »

macsir wrote:Just a thought, if this parameter is not set, is there any possibility that you got wrong result because the conditional feeders are not re-evaluated automatically? If yes, how to prevent it?
1) Set the parameter to true.
2) Don't use conditional feeders.
3) Run a TI process that reprocesses feeders every time a user changes data in a cell that uses a conditional feeder to feed another cell.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: ForceReevaluationOfFeedersForFedCellsOnDataChange

Post by macsir »

Thanks, tomok for the quick reply. So it is possible that user changed the value and the new location is not fired?

For the #2, Do you mean that using slightly overfeeding instead?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: ForceReevaluationOfFeedersForFedCellsOnDataChange

Post by macsir »

The reason I am asking is that, I found my reloading actual process is really slow because most data is different from what have been loaded last time. And if I turned this parameter off, the reloading time is back to normal. And because my model requires lots of user data change and there are lots of conditional feeders, I would prefer to turn this parameter on at default.
Apart from the three options you provided, I am thinking to have an external little program to automatically change this parameter on and off. Lets say, first turn it off for reloading actual and then shut down the server change the parameter to TRUE and restart the server for daily operation. Is that reasonable? Any advice is welcomed.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
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: ForceReevaluationOfFeedersForFedCellsOnDataChange

Post by tomok »

macsir wrote:Thanks, tomok for the quick reply. So it is possible that user changed the value and the new location is not fired?
Yes, that's entirely possible if you have some IF conditional logic in your feeders. That's the whole purpose for that parameter.
macsir wrote:For the #2, Do you mean that using slightly overfeeding instead?
I'm simply saying that if you have conditional feeders AND they're causing you an issue because you refuse to use the ForceReevaluationOfFeedersForFedCellsOnDataChange parameter then one option is take out the "condition" in your feeders. Whether results in overfeeding I have no clue based on the information given. Probably so, otherwise why you put a condition in there?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: ForceReevaluationOfFeedersForFedCellsOnDataChange

Post by macsir »

Thanks, so far no issue except the one I described above. I think rather than only turning in this parameter, I should focus on how to resolve it fundamentally. If the new location is not fired, then it must be some situations I haven't considered before. I should adjust conditional feeders accordingly.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply