Cell Count Calculation in a module
Hi All,
How can we calculate cell count of a line item in a module?(Not sparsity/model size)
I have a few questions with this:
1. Do we include parents in the count if the list is a hierarchical list?
2. Do we calculate no. of versions even if it is not present in dimension?
3. How do Time ranges affect the cell count of a line item?
Thanks in advance!
Regards,
Sandip Sinha
Comments

You only count the parents if the summary of the line item is turned, which is why we suggest to turn summaries off. The cell count is only for the lists defined, so if Versions are not being used, then they don’t count. Same thing for Time, it counts the number of members, but if summaries are turned off, then they don’t get counted.
Rob
1 
Hello @sandipsinha15
That's an important question. The number of cells for a particular Line Item depends on the following: The # list items in the dimension of the Line Item
 Consider a line item called Revenue and is dimensioned only by the List States which has 50 list items then the cell count will be 50
 Assume now we add another dimension  Product, which has 10 list items, then the cell count will be 50x10 = 500
2. The Time Dimension and the Time Range
 If the module  i.e. the line item  is dimensioned by months and the Time Range is 1 year without Quarters or Year totals then the size of the line item will increase to 500 x12 = 6000
 If you add Quarters and Year total and the time summary is on  that 5 more items in the time dimension the size will increase to 500x(12+5) = 8500
3. # of versions applied to the line item
 If the line item has 2 versions  Actual and Forcast then the cell count will be 8500x2 = 17,000
4. If the line items have a summary then the TopLevel and Parents will contribute to the cell count
 Assume the States list has a toplevel and the products have 2 parents (Product Category) then the number of Items in the States list becomes 51 and the number of items in the Product list is 12.
So, to directly answer your questions:
1. Do we include parents in the count if the list is a hierarchical list?
Yes, if the line item has a summary
2. Do we calculate no. of versions even if it is not present in dimension?
No, only if the line item is dimensioned by Version
3. How do Time ranges affect the cell count of a line item?
Yes, You multiply the number of "periods" in the time range, if the line item Time Summary is on then you have to add Quarters and Years if applicable
7 
That's a clear explanation. Thanks @einas.ibrahim
0