Cell Count Calculation in a module

Hello @sandipsinha15 

That's an important question. The number of cells for a particular Line Item depends on the following:

1. 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 Top-Level and Parents will contribute to the cell count

• Assume the States list has a top-level 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