Cube feeder is missing after dimension reordering

Post Reply
hyunjia
Posts: 64
Joined: Fri Jul 27, 2012 4:13 pm
OLAP Product: TM1
Version: 2010
Excel Version: Excel 2010

Cube feeder is missing after dimension reordering

Post by hyunjia »

Hi Gurus

I have got a situation which I could not explain might need some guidance .

Here is the StasByCube before reordinging.
Before:
Number of Populated Numeric Cells 50629
Number of Fed Cells 59822407
Memory Used for Feeders 1648361472
Memory Used for Input Data 4191232
Total Memory Used 1652552704

After:
Number of Stored Calculated Cells 582
Number of Populated Numeric Cells 30343286
Number of Fed Cells 0
Memory Used for Feeders 0
Memory Used for Input Data 620753920
Total Memory Used 620753920

Please notice that, the feeder is "0" :o

I did unload the cube after the dimension reordering , and issued a reprocessfeeder TI , however , the TI completed within a second and feeder did not seem be reprocessed at all , as I am using persistent feeder , the feeder file is still the one before dimension reordering .

Also, the feeder is still working :?: , that is, zero suppression and consolidation is just working. I am wondering if the cube is still using the feeder from the old persistent feeder , but how come there's no memory used as it indicate from the StasByCube .

Please shed some light on this, any idea is appreciated and welcome.
hyunjia
Posts: 64
Joined: Fri Jul 27, 2012 4:13 pm
OLAP Product: TM1
Version: 2010
Excel Version: Excel 2010

Re: Cube feeder is missing after dimension reordering

Post by hyunjia »

I am using TM1 10.1.1 BTW
hyunjia wrote:Hi Gurus

I have got a situation which I could not explain might need some guidance .

Here is the StasByCube before reordinging.
Before:
Number of Populated Numeric Cells 50629
Number of Fed Cells 59822407
Memory Used for Feeders 1648361472
Memory Used for Input Data 4191232
Total Memory Used 1652552704

After:
Number of Stored Calculated Cells 582
Number of Populated Numeric Cells 30343286
Number of Fed Cells 0
Memory Used for Feeders 0
Memory Used for Input Data 620753920
Total Memory Used 620753920

Please notice that, the feeder is "0" :o

I did unload the cube after the dimension reordering , and issued a reprocessfeeder TI , however , the TI completed within a second and feeder did not seem be reprocessed at all , as I am using persistent feeder , the feeder file is still the one before dimension reordering .

Also, the feeder is still working :?: , that is, zero suppression and consolidation is just working. I am wondering if the cube is still using the feeder from the old persistent feeder , but how come there's no memory used as it indicate from the StasByCube .

Please shed some light on this, any idea is appreciated and welcome.
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Cube feeder is missing after dimension reordering

Post by EvgenyT »

Did you try restarting the model and turning Performance Monitor back on?
hyunjia
Posts: 64
Joined: Fri Jul 27, 2012 4:13 pm
OLAP Product: TM1
Version: 2010
Excel Version: Excel 2010

Re: Cube feeder is missing after dimension reordering

Post by hyunjia »

That's what I intend to do , unfortunately , the server takes 2 hours for a full restart , I just have to wait until tonight . I will post the result after the restart .
EvgenyT wrote:Did you try restarting the model and turning Performance Monitor back on?
hyunjia
Posts: 64
Joined: Fri Jul 27, 2012 4:13 pm
OLAP Product: TM1
Version: 2010
Excel Version: Excel 2010

Re: Cube feeder is missing after dimension reordering

Post by hyunjia »

After a full restart , the number in the StatBy Cube somehow make sense after all . I original thoght the dimension reordering would improve the feeder calculation time , but my result shows the time is roughtly the same . However the feeder did consume less memory after dimension reording and thus reduce the total memory used amount .
# ------------------------------------------------------------------------
LATEST
Number of Populated Numeric Cells 50,629
Number of Fed Cells 63,797,878
Memory Used for Feeders 146,800,640
Memory Used for Input Data 4,191,232
Total Memory Used 150,991,872

# -------------------------------------------------------------------------
hyunjia wrote:That's what I intend to do , unfortunately , the server takes 2 hours for a full restart , I just have to wait until tonight . I will post the result after the restart .
EvgenyT wrote:Did you try restarting the model and turning Performance Monitor back on?
Post Reply