Number of Populated Numeric Cells?

Post Reply
GPC
Posts: 51
Joined: Thu Aug 06, 2009 11:09 pm
OLAP Product: TM1
Version: 10.2.20100.123
Excel Version: 365
Location: Sydney

Number of Populated Numeric Cells?

Post 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
User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: Number of Populated Numeric Cells?

Post by Olivier »

Could that be due to some feeders that would be considered as populated cells ?



Olivier
HTH
Olivier
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Number of Populated Numeric Cells?

Post 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.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
GPC
Posts: 51
Joined: Thu Aug 06, 2009 11:09 pm
OLAP Product: TM1
Version: 10.2.20100.123
Excel Version: 365
Location: Sydney

Re: Number of Populated Numeric Cells?

Post by GPC »

Yes, sorry, when I thought about it some more the calculation is 400,000 x 39 x 5.

Thanks,

Gregory
Post Reply