Page 1 of 1

Number of Populated Numeric Cells?

Posted: Thu Aug 05, 2010 6:47 am
by GPC
We have a cube which is populated with approx 400,000 records every year.
There are 18 dimensions and a measures dimension.
Cellputn's are done for each of the 39 measures.
With 5 years of data I would have thought the Number of Populated Numeric Cells would be;
400,000 x 18 x 39 x 5 = 1,053,000,000 but TM1 says it has 110,000,000
Anyone know why this is?

thanks,

Gregory

Re: Number of Populated Numeric Cells?

Posted: Thu Aug 05, 2010 7:36 am
by Olivier
Could that be due to some feeders that would be considered as populated cells ?



Olivier

Re: Number of Populated Numeric Cells?

Posted: Thu Aug 05, 2010 2:45 pm
by Wim Gielis
It will be closer to the truth if you do:

=400,000*39*5

Any cell is characterised by 19 coordinates, but it does not mean it's stored 19 times.

Re: Number of Populated Numeric Cells?

Posted: Thu Aug 05, 2010 9:45 pm
by GPC
Yes, sorry, when I thought about it some more the calculation is 400,000 x 39 x 5.

Thanks,

Gregory