Stat cube: fed cells

Post Reply
Goatship
Posts: 33
Joined: Tue May 25, 2010 4:15 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Stat cube: fed cells

Post 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.
I'm new to TM1.
lotsaram
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

Post 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 ...
Goatship
Posts: 33
Joined: Tue May 25, 2010 4:15 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Stat cube: fed cells

Post by Goatship »

Thanks a lot for your answer. What do you mean by "tuning feeders in rules files" ?
I'm new to TM1.
lotsaram
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

Post 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.
Goatship
Posts: 33
Joined: Tue May 25, 2010 4:15 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Stat cube: fed cells

Post 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.
I'm new to TM1.
lotsaram
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

Post 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.
Goatship
Posts: 33
Joined: Tue May 25, 2010 4:15 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Stat cube: fed cells

Post by Goatship »

Thank you very much !
I'm new to TM1.
Post Reply