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,,,

___________________________________________________________________________________________

Accepted answers

All comments

DavidSmith

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

ablack

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.

barryallen1337

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.

VIGNESH.M

@barryallen1337 ,

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

Misbah

@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

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

DavidSmith

@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

Misbah

@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 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

DavidSmith

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

Misbah

@DavidSmith

No Problem:) Thanks a lot for clarifying.

pinknemo13

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.

Daisybell

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.

chrised209

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.

Quick Links

Can you help?

Unanswered questions

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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…