Question about deleting feeders
-
- Regular Participant
- Posts: 200
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
Question about deleting feeders
I found one strange feeders behavior.
For example I create feeders - it works aggregations appears in total elements. When I decide to delete feeder, do it, save rule and found that sum in total didn't disappear. They disappear only in when I restart server.
Is it normal behavior or may be I should simply put some parameter in .cfg file or somewhere else and totals begin disappear. Can anybody help in this question?
For example I create feeders - it works aggregations appears in total elements. When I decide to delete feeder, do it, save rule and found that sum in total didn't disappear. They disappear only in when I restart server.
Is it normal behavior or may be I should simply put some parameter in .cfg file or somewhere else and totals begin disappear. Can anybody help in this question?
- qml
- MVP
- Posts: 1094
- 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: Question about deleting feeders
It is expected behaviour; TM1 doesn't remove feeders during a given server session. Bouncing the server or unloading and loading the cube again is needed to clear feeders.
Last edited by qml on Sat Jun 18, 2011 9:23 am, edited 1 time in total.
Kamil Arendt
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Question about deleting feeders
More that that, if using persistent feeders then a server bounce won't clear feeders unless the .feeder file(s) are also deleted. This is a big (well even bigger than before) watchout when developing rules.qml wrote:It is expected behaviour, TM1 doesn't remove feeders during a given server session. Bouncing the server or unloading and loading again the cube is needed to clear feeders.
-
- Regular Participant
- Posts: 200
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
Re: Question about deleting feeders
Thank you for answer. Can you say what you mean in "bouncing the server". English isn't my native language and I didn't find such expression in dictionary. You meant "restart server"?qml wrote:It is expected behaviour; TM1 doesn't remove feeders during a given server session. Bouncing the server or unloading and loading the cube again is needed to clear feeders.
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Question about deleting feeders
bounce server = slang for "restart TM1 service or application."
-
- Regular Participant
- Posts: 200
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
Re: Question about deleting feeders
Thank youlotsaram wrote:bounce server = slang for "restart TM1 service or application."
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Question about deleting feeders
Indeed, for TM1 consultants, this calls for either access to the data directory, either asking IT to delete the feeders files...lotsaram wrote:More that that, if using persistent feeders then a server bounce won't clear feeders unless the .feeder file(s) are also deleted. This is a big (well even bigger than before) watchout when developing rules.
So feature this will not be equally interesting at all customers where we create and follow up TM1 models.
Does anyone have an indication of how big these feeders files can be for a very big cube relying heavily on rules? For instance, a cube containing only rules, pulling data from elsewhere, a lot of scenarios feeding each other, size about 1.5 GB in memory?
Wim
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Question about deleting feeders
I think this is a feature that should interest all customers on 9.4 or earlier. Server load time on a large rule heavy model can quite literally go from 2 hours to 2 minutes using persistent feeders.
In terms of how big feeder files can be, as with all things TM1, "it depends". You won't get the same economy of size on disk vs. in memory for feeders vs. cube data as once loaded into memory a feeder is very economical. If you take a similarly sized, dimensioned and dense data cube and look at the size of the .cub file is this would be the best guide as to the size of a .feeder file for an exactly fed, otherwise identical rule driven cube. Maybe allow a little more for the .feeder file as some degree of overfeeding is probably inevitable.
In terms of how big feeder files can be, as with all things TM1, "it depends". You won't get the same economy of size on disk vs. in memory for feeders vs. cube data as once loaded into memory a feeder is very economical. If you take a similarly sized, dimensioned and dense data cube and look at the size of the .cub file is this would be the best guide as to the size of a .feeder file for an exactly fed, otherwise identical rule driven cube. Maybe allow a little more for the .feeder file as some degree of overfeeding is probably inevitable.
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Question about deleting feeders
Leaving aside my personal view that any IT department which denies a TM1 admin access to the server box needs a good kicking (security is one thing, securing-to-the-point-of-disability is another), you may not be thinking laterally enough there.Wim Gielis wrote:Indeed, for TM1 consultants, this calls for either access to the data directory, either asking IT to delete the feeders files...lotsaram wrote:More that that, if using persistent feeders then a server bounce won't clear feeders unless the .feeder file(s) are also deleted. This is a big (well even bigger than before) watchout when developing rules.
Remember that even when you don't have direct access to the data directory... TI does. And the AsciiDelete function doesn't just delete ASCII files.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Question about deleting feeders
Hi Alan, nice idea. I will remember it.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Site Admin
- Posts: 1453
- Joined: Wed May 28, 2008 9:09 am
Re: Question about deleting feeders
Don't forget this TI command:
DeleteAllPersistentFeeders
Deletes any .feeder files that have persisted. When this function is used, all cubes are marked as "do not save feeders" so a subsequent "SaveData" will not persist feeders which means all feeders will be re-calculated on a server re-start.
Personally, when researching persistent feeders, I've just deleted the .feeders file by hand. My large systems typically have heavily conditionalised feeders and persistent feeders need removing if you are turning versions etc on and off.
DeleteAllPersistentFeeders
Deletes any .feeder files that have persisted. When this function is used, all cubes are marked as "do not save feeders" so a subsequent "SaveData" will not persist feeders which means all feeders will be re-calculated on a server re-start.
Personally, when researching persistent feeders, I've just deleted the .feeders file by hand. My large systems typically have heavily conditionalised feeders and persistent feeders need removing if you are turning versions etc on and off.