Cell Count Calculation in a module

sandipsinha15

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

 

rob_marshall

@sandipsinha15 

 

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

einas.ibrahim

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 

 

sandipsinha15

That's a clear explanation. Thanks @einas.ibrahim