Hi All,
I am trying to make changes to feeders in a cube and looking for the memory used for feeders.
My assumption which I thought and did some testing, but that doesn't look fine.
Right click on server and click on "Start Performance Monitor" and then check the details in }StatsByCube before and after making the changes to feeders, but the stats were same.
1. My understanding was that when we save the rules, }StatsByCube will get updated, but it doesn't seem to be so.
2. I have commented all the feeders statement thinking memory used for feeders will be shown as Zero, but my assumption went wrong.
Can someone please share information on how and when the "Memory Used for Feeders" in the }StatsByCube will get updated?
Regards,
Deepak Jain
}StatsByCube update
-
- Regular Participant
- Posts: 152
- Joined: Sat May 25, 2013 10:32 am
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2
- Excel Version: 2007
-
- Posts: 42
- Joined: Fri Apr 19, 2013 7:07 pm
- OLAP Product: TM1
- Version: 10.1 RP1 FP1
- Excel Version: 2003 SP3
Re: }StatsByCube update
Feeders are only flushed from a cube when that cube is unloaded (e.g. server is shut down,) so I would not expect the stats cube to show zero after you commented feeder statements.
Did you mean to post in the Enhancements section?
Did you mean to post in the Enhancements section?
-
- Site Admin
- Posts: 6654
- 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: }StatsByCube update
Indeed. It's not an Enhancements issue. Thread moved accordingly.TableManagerOne wrote:Did you mean to post in the Enhancements section?
"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.
-
- Regular Participant
- Posts: 152
- Joined: Sat May 25, 2013 10:32 am
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2
- Excel Version: 2007
Re: }StatsByCube update
Hi Alan,
Thanks Alan, please let me know where to post for having some knowledge on any topic?
1. What is the significance of "Performance monitor" when control objects are not automatically recalculated, until server is restarted?
2. What are the other ways where we can have the updated stats for the cube and we can view through the control objects?
Regards,
Deepak Jain
So even though I make changes to feeders, the stats will always remain same, until server is re-started, please confirm.Feeders are only flushed from a cube when that cube is unloaded (e.g. server is shut down,) so I would not expect the stats cube to show zero after you commented feeder statements.
I understood mine issue is neither a Bug nor enhancement, but still I posted, Apologies for that.Indeed. It's not an Enhancements issue. Thread moved accordingly.
Thanks Alan, please let me know where to post for having some knowledge on any topic?
1. What is the significance of "Performance monitor" when control objects are not automatically recalculated, until server is restarted?
2. What are the other ways where we can have the updated stats for the cube and we can view through the control objects?
Regards,
Deepak Jain
-
- Posts: 42
- Joined: Fri Apr 19, 2013 7:07 pm
- OLAP Product: TM1
- Version: 10.1 RP1 FP1
- Excel Version: 2003 SP3
Re: }StatsByCube update
The stats can change when new feeders are populated. In general, statistics are collected every minute, and updated in the appropriate cube. This is true of feeders (population, memory used, etc.) but, a feeder, once populated, is not removed until the cube in unloaded.So even though I make changes to feeders, the stats will always remain same, until server is re-started, please confirm.
Also keep in mind that feeders can reuse much of the memory of other feeders and input cells, and that memory is allocated by TM1 in large chunks. So, while you should see updates to the feeder population a minute or sooner after adding new feeders (the flag values themselves - not the statements,) you may not see changes to the memory used unless you add a substantial number of feeders.
-
- Regular Participant
- Posts: 152
- Joined: Sat May 25, 2013 10:32 am
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2
- Excel Version: 2007
Re: }StatsByCube update
Thanks for the information.
I have restarted the server and the stats for feeders memory had a drastic change.
Now I have one more doubt, how can I confirm that the data is similar to that of prior changes made to feeders. It might sound a silly, but need some information.
Regards,
Deepak Jain
I have restarted the server and the stats for feeders memory had a drastic change.
Now I have one more doubt, how can I confirm that the data is similar to that of prior changes made to feeders. It might sound a silly, but need some information.
Regards,
Deepak Jain
-
- MVP
- Posts: 170
- Joined: Fri Dec 10, 2010 4:07 pm
- OLAP Product: TM1
- Version: [2.x ...] 11.x / PAL 2.0.9
- Excel Version: Excel 2013-2016
- Location: Germany
Re: }StatsByCube update
... and don't forget to turn off Persistent Feeders, if you are working on feeder rules.
Otherwise you can not trust any result before you delete the .feeder file and restart the service.
Otherwise you can not trust any result before you delete the .feeder file and restart the service.
-
- 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: }StatsByCube update
Well, it's a little late for that now isn't it? You've already made the changes so unless you have a magic wand to take you back in time then there is not going to be any way to make a comparison to a state that existed in the past. The only way to make that kind of comparison is to take a snapshot of the cube data in question before you make the changes and then compare that to the "after" state.deepakjain2020 wrote:I have restarted the server and the stats for feeders memory had a drastic change.
Now I have one more doubt, how can I confirm that the data is similar to that of prior changes made to feeders. It might sound a silly, but need some information.