Strange feeder behaviour
-
- Posts: 34
- Joined: Mon Oct 18, 2010 7:38 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Strange feeder behaviour
Hello All, I am experiencing some strange behaviour with one of the feeders. There are persistent feeders enabled in the model. I changed the rules so that there are no feeders in this cube, stopped TM1 service and deleted .feeder file. I expected that there will be no .feeder file created after the restart, yet there still is. Also checked that there are no feeeders in other cubes pointing to this cube. Any ideas what else can it be?
TM1 10.2.2 FP7
TM1 10.2.2 FP7
-
- MVP
- Posts: 2832
- 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: Strange feeder behaviour
Do your rules pull in values from other cubes? Perhaps you still have feeders in those cubes for the intercube references?
- PavoGa
- MVP
- Posts: 617
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: Strange feeder behaviour
The feeder file will be created for a cube if any cell in that cube is fed. As tomok indicates, if another cube's rules are feeding the cube in question, you will get a feeder file as long as PersistentFeeders=T in the tm1s.cfg file.
Ty
Cleveland, TN
Cleveland, TN
-
- Posts: 34
- Joined: Mon Oct 18, 2010 7:38 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Strange feeder behaviour
That is what I thought, but I deleted all other rules files from the model. The only rule file left is for the cube in question and it has no feeders section!PavoGa wrote:The feeder file will be created for a cube if any cell in that cube is fed. As tomok indicates, if another cube's rules are feeding the cube in question, you will get a feeder file as long as PersistentFeeders=T in the tm1s.cfg file.
The only other suspect is function ConsolidateChildren - could it be that it causes feeders creation?
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Strange feeder behaviour
The mere presence of a rule file, even if empty, will cause creation of a .feeders file for the same cube.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 34
- Joined: Mon Oct 18, 2010 7:38 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Strange feeder behaviour
Interesting. Than what is stored in that file if not feeders info?lotsaram wrote:The mere presence of a rule file, even if empty, will cause creation of a .feeders file for the same cube.
I am trying to recreate the model without feeders for currency calculations, to see if it will improve performance. Not sure what is the point of not using feeders, if there is still a feeders file created, even if there are no feeders...
- 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: Strange feeder behaviour
Try to turn of persistent feeders in cfg file and see.
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Strange feeder behaviour
Any cube with a rule associated with it must have a feeders file if using persistent feeders. This is necessary so that on session start the server can validate that the feeder file is same or later time stamped than the cube file. If the feeder file is older this will invalidate all feeder files and cause reprocessing of feeders. So even if a feeder file is completely empty it still needs to serve this purpose.vladkon wrote:Interesting. Than what is stored in that file if not feeders info?
I am trying to recreate the model without feeders for currency calculations, to see if it will improve performance. Not sure what is the point of not using feeders, if there is still a feeders file created, even if there are no feeders...
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 34
- Joined: Mon Oct 18, 2010 7:38 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Strange feeder behaviour
Understood. But it is far from being empty - it takes about 16Gb of disk space. Feeders as per definition should include only data on n-level cells, correct? If there is no feeder section in the rule file, what could it be that takes such an amount of disk space, and how it can be reduced?lotsaram wrote: Any cube with a rule associated with it must have a feeders file if using persistent feeders. This is necessary so that on session start the server can validate that the feeder file is same or later time stamped than the cube file. If the feeder file is older this will invalidate all feeder files and cause reprocessing of feeders. So even if a feeder file is completely empty it still needs to serve this purpose.
-
- Posts: 34
- Joined: Mon Oct 18, 2010 7:38 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Strange feeder behaviour
What I am trying to say, is that it seems not only feeder section controls feeders creation, but also rules some rules statements, for example ConsolidateChildren. If this is true, than it also should be taken into account when optimizing feeders.
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Strange feeder behaviour
No. Only feeder statements create feeders. Rules and feeders are independent. Feeders are only used for consolidation, period. That's all they do.vladkon wrote:What I am trying to say, is that it seems not only feeder section controls feeders creation, but also rules some rules statements, for example ConsolidateChildren. If this is true, than it also should be taken into account when optimizing feeders.
If you have a 16 gb feeder file and the rule for that cube contains no feeders then (assuming the server had been restarted with feeders having been cleared with delete all persistent feeders command) the cube is being fed from another cube. Simple as that.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 1
- Joined: Sat Oct 30, 2021 11:58 am
- OLAP Product: tm1
- Version: 2.0.9.9
- Excel Version: 2016
Re: Strange feeder behaviour
ConsolidateChildren function does create feeders. With no feeder statements if you're seeing feeders in the }StatsByCube cube, ConsolidateChildren is the culprit.