CFG Parameter 'ForceReevaluationOfFeedersForFedCellsOnDataChange'

Post Reply
sumitgoyal2290
Posts: 5
Joined: Wed Jul 20, 2016 11:45 am
OLAP Product: TM1
Version: 10.2.0
Excel Version: excel 2013

CFG Parameter 'ForceReevaluationOfFeedersForFedCellsOnDataChange'

Post by sumitgoyal2290 »

Hi,

I am new to TM1 and currently looking at certain features of TM1.
Can anyone help me with the cfg file parameter 'ForceReevaluationOfFeedersForFedCellsOnDataChange'.

I have tried to test this in my personnel machine by creating a conditional feeder in order to fed the cell. But I have to restart the server or run TI cube process feeder in order to refresh the feeder.

I am not able to see any change by using the parameter ForceReevaluationOfFeedersForFedCellsOnDataChange.
Working on Tm1 version 10.2

Thanks
Sumit
User avatar
Steve Rowe
Site Admin
Posts: 2464
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: CFG Parameter 'ForceReevaluationOfFeedersForFedCellsOnDataChange'

Post by Steve Rowe »

Hi Sumit,
Please post details of your test system so that we can explain why it may not be working.

It is more likely that your test is not constructed correctly than there is a bug in TM1.

I could be wrong but my understanding is that attribute value changes do not trigger re-evaluation.

If you are actually requiring this to be live in a proper TM1 system then I would suggest you look hard at your design. It will make the performance of the system worse, IMO any design that requires this cfg to in place has significant issues.

Cheers,
Technical Director
www.infocat.co.uk
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: CFG Parameter 'ForceReevaluationOfFeedersForFedCellsOnDataChange'

Post by tomok »

Steve Rowe wrote:I could be wrong but my understanding is that attribute value changes do not trigger re-evaluation.
I believe the issue is that string value changes don't trigger re-evaluation. Granted, most attributes are strings but they don't have to be.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: CFG Parameter 'ForceReevaluationOfFeedersForFedCellsOnDataChange'

Post by lotsaram »

tomok wrote:I believe the issue is that string value changes don't trigger re-evaluation. Granted, most attributes are strings but they don't have to be.
Actually it's the opposite. String cells don't require a special parameter to force feeder re-evaluation, never have. The default bahaviour of string cells unlike numeic cells is that feeders will re-fire on each value change, unlike numeric cells which only refire when changing from null to a non-zero value. We have used this functionality many times, it can be particularly useful in a picklist driven application where a picklist value encodes an element name which can then be used in a feeder. (try it I promise it works).

Where the OP may be getting mixed up and I think what Steve might have been getting at is the situation ..
['my cell'] => DB('some cube', !dim1, !dim2, AttrS('dim3', !dim3, 'lookup'), 'some measure');
When the value of the "lookup" attribute changes the end result is that the correct cell(s) is not fed but some other cell is still fed. Even when ForceReevaluationOfFeedersForFedCellsOnDataChange is used this won't make a shred of difference as the feeder is only going to re-evaluate when the (leaf) values defined by "my cell" change, not when the attribute values in dim3 change. The only way to deal with this situation is with a TI using CubeProcessFeeders (or deleting feeders and restarting the server whihc is more drastic but which will also clear out the old overfed cells.)
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
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: CFG Parameter 'ForceReevaluationOfFeedersForFedCellsOnDataChange'

Post by tomok »

lotsaram wrote:Where the OP may be getting mixed up and I think what Steve might have been getting at is the situation ..
['my cell'] => DB('some cube', !dim1, !dim2, AttrS('dim3', !dim3, 'lookup'), 'some measure');
When the value of the "lookup" attribute changes the end result is that the correct cell(s) is not fed but some other cell is still fed. Even when ForceReevaluationOfFeedersForFedCellsOnDataChange is used this won't make a shred of difference as the feeder is only going to re-evaluate when the (leaf) values defined by "my cell" change, not when the attribute values in dim3 change. The only way to deal with this situation is with a TI using CubeProcessFeeders (or deleting feeders and restarting the server whihc is more drastic but which will also clear out the old overfed cells.)
That was what I was talking about, when you use a string value as a "lookup" type feeder. Once the original mapped cell has been fed, any change to the lookup value will not cause the newly mapped cell to be fed. To be honest, that's the only situation where I've ever used a string to feed something.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
sumitgoyal2290
Posts: 5
Joined: Wed Jul 20, 2016 11:45 am
OLAP Product: TM1
Version: 10.2.0
Excel Version: excel 2013

Re: CFG Parameter 'ForceReevaluationOfFeedersForFedCellsOnDataChange'

Post by sumitgoyal2290 »

Hi

Thanks everyone for updates.

My scenario is that I have 3 cubes: cube 1, cube 2 and cube 3. Data in cube 3 is flowing from cube 2 based on some condition in cube 1.

If certain condition is met in cube 1 then only data should be fed in cube 3 from cube 2.

Now I am assuming that 'ForceReevaluationOfFeedersForFedCellsOnDataChange' parameter should work here. But my issue is that unless I run CubeProcessFeeders TI(Or restart the server), numeric data is not getting fed.
User avatar
Steve Rowe
Site Admin
Posts: 2464
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: CFG Parameter 'ForceReevaluationOfFeedersForFedCellsOnDataChange'

Post by Steve Rowe »

Please post your actual code.
Technical Director
www.infocat.co.uk
Post Reply