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.
Stat cube: fed cells
-
- Posts: 33
- Joined: Tue May 25, 2010 4:15 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007
Stat cube: fed cells
I'm new to TM1.
-
- MVP
- Posts: 3701
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Stat cube: fed cells
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 ...
-
- Posts: 33
- Joined: Tue May 25, 2010 4:15 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007
Re: Stat cube: fed cells
Thanks a lot for your answer. What do you mean by "tuning feeders in rules files" ?
I'm new to TM1.
-
- MVP
- Posts: 3701
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Stat cube: fed cells
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.Goatship wrote:Thanks a lot for your answer. What do you mean by "tuning feeders in rules files" ?
-
- Posts: 33
- Joined: Tue May 25, 2010 4:15 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007
Re: Stat cube: fed cells
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.
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.
I'm new to TM1.
-
- MVP
- Posts: 3701
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Stat cube: fed cells
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.