How to calculate Anaplan model size?

[karank]

Hi Guys 

I am using below calculation to find model size 

1000000000 cells = 9.3 GB 

1 cell = 9.3/1000000000

Total cells exported from module export = 

6206436639

which gives me 

57.71986074 GB's 

problem is Anaplan shows model size as 39.29 Gb's ?. I have used this calculation on 8 models and all of these comes close to model size shown in Anaplan , just this one doesn't work . 

Ps:- i also tried doing the calc by line item type and cell count by data type but still its way out like above 10 GB's out . 

I have attached an excel sheet as well with actual cells extract

any idea ?

[usman.zia]

Hi @karank 

To quote Michael Gould:

Each list item carries a memory allocation of 500 bytes per item. This is an estimate to allow for the item name, item code, parent and other built-in properties, along with internal indexing that is needed to give efficient look-ups. Custom properties are additional to this - the size for custom properties is calculated as if they were a 1-dimensional line item.

Source:

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Model-sizing/m-p/1177#M1985

So it could be that your model is extremely slim on list item properties? 

Also I have seen someone else quote a lower number of 0.0000000074126 as @Alessio_Pagliano mentioned on the link above also.

I hope this helps,

Usman

[DavidSmith]

@karank 

You can't really use ratio metrics for cells to GB, it's too variable

The sizing is as follows for any line item or list property.  The "cell count" for properties will be the number of members in the list (including subsets)

Boolean = 1b

List, Time, Date formatted = 4b

Number and Text = 8b

As @usman.zia said each list item = 500b (including the name and code properties)

You also need to account for subsets = these also count as list members too, so 1m items and 2 subsets of 500k each = 2m

Finally you need to throw switchover into the mix.  This can reduce model cell count too as the "actual" periods are not counted

I hope that helps

David

[Alessio_Pagliano]

Spot on @usman.zia , 

Generally speaking model size could be estimated with cell size only but if you want to be precise or have massive lists/properties you then need to consider them accordingly. This is probably why you might come across some exceptions

PS Do you need properties as opposed to system modules ? (re: best practices) 

Thanks,

Alessio

[karank]

Thanks guys

I tried same calc on 8 different models including this and it works on 7 . Close enough considering its estimate .

Out of these 7 one model is actually a dev copy of the same model on which it doesnt work ???? . i am using Alm and models are syncd . how can i get such huge cell count difference but model sizes are same ?

[Misbah]

@karank 

One of the reasons can be the number of list items as they don't add to the cell count but do occupy space (500 bytes per item). Same holds good for the number of items within each subset that you have across all lists-these also don't give you the cell count but eats up your space.

Thanks,

Misbah

[DavidSmith]

@Misbah 

Just to clarify, List Properties  DO add to the cell count, it is just that the cells are not visible in the grid page of the list

List Properties = Line items for size and performance.  Think of them as interchangeable

David

[Misbah]

@DavidSmith 

Absolutely, I meant to say that cells are not visible in the grid and size of the model can't be estimated based on the number of cells that an Anaplanner sees. As you rightly mentioned earlier, that size and cell count doesn't go hand in hand.

Thanks,

Misbah

[Misbah]

@DavidSmith 

Also List Properties DO add to the cell count and ARE visible in the grid. Its about List items and number of items within the subsets of each list that doesn't go to the Visible Cell Grid.

Thanks,

Misbah

[Damian_Broj]

As all other mentioned- analyzing only the cell count on module list would never give you exact answer on the model size. There are some other elements that increase it's size- mostly list related ones. To calculate everything accurately you would need to analyze your modules one by one taking into consideration the data types plus calculating the same for all lists etc. The question is what is the reason behind your calculation? Are you trying to optimize your model or just confirm that the calculation of size is valid?