}StatsByCube update

Post Reply
deepakjain2020
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

}StatsByCube update

Post by deepakjain2020 »

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
TableManagerOne
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

Post by TableManagerOne »

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?
Alan Kirk
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

Post by Alan Kirk »

TableManagerOne wrote:Did you mean to post in the Enhancements section?
Indeed. It's not an Enhancements issue. Thread moved accordingly.
"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.
deepakjain2020
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

Post by deepakjain2020 »

Hi Alan,
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.
So even though I make changes to feeders, the stats will always remain same, until server is re-started, please confirm.
Indeed. It's not an Enhancements issue. Thread moved accordingly.
I understood mine issue is neither a Bug nor enhancement, but still I posted, Apologies for that.
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
TableManagerOne
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

Post by TableManagerOne »

So even though I make changes to feeders, the stats will always remain same, until server is re-started, please confirm.
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.

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.
deepakjain2020
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

Post by deepakjain2020 »

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
Gabor
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

Post by Gabor »

... 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.
tomok
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

Post by tomok »

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.
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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply