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
Number of Populated Numeric Cells?
- 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?
Could that be due to some feeders that would be considered as populated cells ?
Olivier
Olivier
HTH
Olivier
Olivier
-
- 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?
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.
=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
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
-
- 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?
Yes, sorry, when I thought about it some more the calculation is 400,000 x 39 x 5.
Thanks,
Gregory
Thanks,
Gregory