New Contributor

Calculation of modules & Size....

Hi Everyone,

 

Can anyone help me to understand, how we are calculating the module size in GB format? If I want to see the actual size of my modules in GB then, do i need to enable any option in Anaplan.

 

Regards,,,

___________________________________________________________________________________________

11 REPLIES 11
Highlighted
Contributor

Re: Calculation of modules & Size....

Hi @Pranit6,


This thread might help you: https://community.anaplan.com/t5/Best-Practices/Size-calculation-of-modules/m-p/34222#M848 

 

Someone has already asked the same question. 

Hope it helps, 
Regards, 

Gaëtan 

New Contributor

Re: Calculation of modules & Size....

This is a rough, high-level way to estimate - here's how I go about it: I get the total model size by going to the gear and double Cartoon HD clicking on the cell count that shows up next to the "Model Settings" header (you can also get the model size by going to "Manage Models" and it will be displayed by the model name) I get the total cell count either from the same location (rounded) or Vidmate by adding up the cell counts from each module Divide the model size by the number of model cells to get a size per cell To calculate the size of a given module, multiply the cell count from that module times the model size per cell from above Again - this is rough and does leave out the size of lists (which may or may not be material, depending on how your model is set up) and possibly other factors as well. But it's a good way to get an estimate. 9Apps

Community Boss

Re: Calculation of modules & Size....

This is the accurate way to calculate

 

1. Look at the number of cells in each line item and multiple by the following table (based on the format of the line item)

Boolean – 1 Byte

List, Date, Time – 4 Bytes
Text, Number – 8 Bytes

 

However, this is only part of the story.  You need to look at lists too

Each list item itself counts for 500 Bytes as well as any properties from the above, so multiply the number of entries in the list by the table above and then add 500b per entry

 

e.g. a list of 100 members with two properties (one number and one date) =

Cells - 100 members * 2 properties = 200 cells

Memory -  100 * (8b +4b) +(100 *500b) = 51,200b

 

One of the reasons why we favour line items over list properties is that the line item cell count is visible but the list properties are not

 

I hope this helps

David

 

Certified Master Anaplanner

Re: Calculation of modules & Size....

Some more information, for text formatted line-items there is additional memory used, but not reported:

  • 48 bytes per non-empty cell + 2 bytes per character

Which is why in David's planual (nice work, by the way) he mentions to avoid text when possible.

Super Contributor

Re: Calculation of modules & Size....

@DavidSmith 


Thanks a lot for the detailed information, it is really helpful. However I found some anomalies between what you say and what I observed. 

 

I created a list with exactly 100 List items in it - Cell Count didn't go up,it remained zero as you rightly mentioned

clipboard_image_0.png

 I then added two properties to it, date and number formatted - Cell count jumped to 200. This is against what you said in your comment section."List Properties add to your space and not to cell count". Below screenshot for your ref

clipboard_image_2.png

Did you intend to say list items? Let me know if I am missing anything here

 

Thanks,

Misbah

Community Boss

Re: Calculation of modules & Size....

@Misbah 

Thanks for the catch, I've updated the post

What I was meaning to put what that you can't see the cell count directly for each list property

David

Super Contributor

Re: Calculation of modules & Size....

@DavidSmith 

 

I think your earlier math was accurate. It was just the statement about the cell count that was confusing.

 

Now there is a confusion in your new calculations as well. What you are saying is that for every 100 list members, you will multiply list members with the number of properties first (in this case 2) and then calculate bytes based on the format of those properties (basically double count) On top of it you are multiplying 500 bytes with 200 instead of 100. 500 Bytes should come only once as it is the space that list item would be consuming only once and then the calculation for list properties would come into picture. 

 

I think the math should be what you posted earlier -I am backing it with my R&D on one of dummy modelsMy model size increased exactly by 0.49MB for 1000 list item count which is aligned as per below math.

 

1000 members = 1000 cells

1000 * (8b +4b) +(1000 *500b) = 5,120,000b

 

Let me know if that's not the case.

Thanks,

Misbah

 

Community Boss

Re: Calculation of modules & Size....

First day back from holiday !!! - Apologies - the Mb count is as was and as you state!
Super Contributor

Re: Calculation of modules & Size....

@DavidSmith 

 

No Problem:) Thanks a lot for clarifying.