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,,,
___________________________________________________________________________________________
Answers
-
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 BytesHowever, 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
7 -
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.
2 -
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 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 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.0
-
Try this to get almost perfect size calculation for each module.
Module 1 has cell count of 90M and boolean format, the Actual size is 0.83 GB, as per yours 3.7 GB
Module 2 has cell count of 90M and Number format, the Actual size is 6.6 GB, as per yours 3.7 GB
Information provided above by David is the best way to calculate the accurate size.
Regards,
Vignesh M
0 -
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
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
Did you intend to say list items? Let me know if I am missing anything here
Thanks,
Misbah
0 -
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
0 -
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 models. My 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
1 -
First day back from holiday !!! - Apologies - the Mb count is as was and as you state!
0 -
0
-
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 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 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.
0 -
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.
0 -
Between what you and @DavidSmith have said about size consumption by type in the model, this would make an excellent explicit addition to Anapedia and/or the Planual. Architects need and model builders ought to be aware of this to guide their builds.
0
