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
Modify Feeder Rule need restart TM1 Service?
- 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?
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
Please copy your feeder here
- 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?
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).
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
-
- 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?
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
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 (75.22 KiB) Viewed 5642 times
- 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?
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.
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
-
- 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?
OK, I got it, thanks. 

-
- 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?
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.qml wrote:Once a cell is fed it will remain fed until either the server is restarted or the cube unloaded.