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

Accepted answers

All comments

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:

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

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…