Page 1 of 1
Stat cube: fed cells
Posted: Fri Apr 08, 2011 9:15 am
by Goatship
How do we make StatCube to show true figures of "Number of Fed Cells".
I'm trying to rid of overfeeding by reducing "Number of Fed Cells".
I tried delete feeders in cube Loan,
then run process "DeleteAllPersistentFeeders",
then unload cube Loan,
then re-open cube Loan.
But "Number of Fed Cells" remains unchanged. It is supposed to be lower number.
The other time, in stead of unloading, I tried run process CubeProcessFeeders, the stat cube still did not change.
Re: Stat cube: fed cells
Posted: Fri Apr 08, 2011 10:01 am
by lotsaram
Unless you are also tuning the feeders section of your rule files, re-processing the feeders will simply put back the feeders that were there ...
Re: Stat cube: fed cells
Posted: Fri Apr 08, 2011 10:56 am
by Goatship
Thanks a lot for your answer. What do you mean by "tuning feeders in rules files" ?
Re: Stat cube: fed cells
Posted: Fri Apr 08, 2011 1:10 pm
by lotsaram
Goatship wrote:Thanks a lot for your answer. What do you mean by "tuning feeders in rules files" ?
I mean editing the the feeder statement to ensure they are as tightly defined as possible to ensure that areas of the cube that do not require feeding are not fed.
Re: Stat cube: fed cells
Posted: Fri Apr 08, 2011 2:35 pm
by Goatship
In the process of tuning feeders; I deleted a specific feeder statement, then I want to look at how much the "Number of Fed Cells" (in StatCube) reduce.
When the reduction is large, it means such feeder statement is feeding large number of cells; so I would go tuning that feeder.
Because rules are really complex, being able to know which feeders are worth tuning would greatly increase efficiency.
The problem is the StatCube did not get updated, after I deleted the feeders in rule, and ran re-process feeders.
Re: Stat cube: fed cells
Posted: Fri Apr 08, 2011 3:30 pm
by lotsaram
You need to also unload the cube after making the rule change. If the cube has dependencies estabilished to other cubes then this might not work and you would need to unload all the "upstream" cubes as well. In that case you woudl be better off restarting the server. If you are using 9.5 then switch off persistent feeders.
Re: Stat cube: fed cells
Posted: Mon Apr 11, 2011 4:59 am
by Goatship
Thank you very much !