Modify Feeder Rule need restart TM1 Service?

Post Reply
wendyWang
Posts: 16
Joined: Mon Jan 12, 2015 9:51 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: OFFICE 2007

Modify Feeder Rule need restart TM1 Service?

Post by wendyWang »

Hello,
I just tried a simple feeder rule, but found it couldn't take effect until I restart the TM1 service.
Do I need to restart the service when I modify the feeder rule? I think it's not reasonable to restart the service every time. Thanks.

Wendy
User avatar
Elessar
Community Contributor
Posts: 413
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Modify Feeder Rule need restart TM1 Service?

Post by Elessar »

No, of course you do not need to restart. The feeders fire when you save the rule (also: when you enter data, when you launch process with CubeProcessFeeders)

Please copy your feeder here
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
User avatar
qml
MVP
Posts: 1097
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Modify Feeder Rule need restart TM1 Service?

Post by qml »

Hi Wendy,

You will need to provide more detail on what you are doing, otherwise it will be hard to pinpoint your problem.

Generally speaking, the server should not need a restart for feeders to be reprocessed. This reprocessing happens in a few scenarios:

a) You change a rule and save it. In newer versions this change needs to be done specifically in the feeders section for the reprocessing to take place.
b) You unload a single cube and then attempt to access it, forcing a reload of the cube and its feeders.
c) You run the TI function CubeProcessFeeders( CubeName ).
d) You write data to the area of the cube that is defined on the left-hand side of the feeder formula.
e) Something feeds the cells in the area on the left-hand side of the feeder formula (feeder cascading).
Kamil Arendt
wendyWang
Posts: 16
Joined: Mon Jan 12, 2015 9:51 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: OFFICE 2007

Re: Modify Feeder Rule need restart TM1 Service?

Post by wendyWang »

Hi both,
Thanks for immediately reply.

Before Change,

#Region System
FEEDSTRINGS;
SKIPCHECK;
#EndRegion
['IST%']=['Sold Out Qty']\['Shipment Qty'];
FEEDERS;
['Sold Out Qty']=>['IST%'];
['Shipment Qty']=>['IST%'];


After Change
, I delete the feeder part.
#Region System
FEEDSTRINGS;
SKIPCHECK;
#EndRegion
['IST%']=['Sold Out Qty']\['Shipment Qty'];

I checked the "Suppress Zeros" button, but the result are same in the two scenarios, and the 'IST%' column always show. But if I restart the TM1 service, the IST% column will disappear. I know the rule can take effect immediately after saving it generally, but in this case I'm confused whether I need to restart the service when I modify the feeder rule.

Wendy
Attachments
screenshot.PNG
screenshot.PNG (75.22 KiB) Viewed 5643 times
User avatar
qml
MVP
Posts: 1097
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Modify Feeder Rule need restart TM1 Service?

Post by qml »

Now it makes more sense. What you are seeing is a result of the fact that TM1 does not unfeed cells in a server session, even if the statement that was used to feed them is removed. Once a cell is fed it will remain fed until either the server is restarted or the cube unloaded.

The above is important to remember when debugging/tracing/checking feeders. Just because a cell is fed when you look at it, it does not mean that the current code is correct because it might have been fed by a previous version of the feeder statement. A restart of the server might be needed to be sure.
Kamil Arendt
wendyWang
Posts: 16
Joined: Mon Jan 12, 2015 9:51 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: OFFICE 2007

Re: Modify Feeder Rule need restart TM1 Service?

Post by wendyWang »

OK, I got it, thanks. :D
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: Modify Feeder Rule need restart TM1 Service?

Post by BrianL »

qml wrote:Once a cell is fed it will remain fed until either the server is restarted or the cube unloaded.
Just to add to what qml stated, this applies if you're NOT using PersistentFeeders. If PersistentFeeders are enabled you'd need to both delete the .feeder file(s) AND restart the server to remove fed cell information.
Post Reply