Hello, I would like to find an app to estimate the size of a model
I can't find it on the App Anaplan Agile
THank you for your help
@margauxplet
Great question because sizing is art as well as science. In my experience I have found that addressing the largest lists and modules are what will get you closest to the actual size. Here's a template I use below. Oh, and remember... estimate the size of the lists as well as the modules. You'd be surprised how much space lists take. Each list item takes 500 Bytes as overhead + the length of the text! Key point: Don't over analyze. As you can see below the P7 SKU List and any associated module will determine the size of this module. So focus on the biggest lists and the respective modules that use them.
Hi @LouiseBourgonjon,
Generally, conversion from cells to space depend on format of a line item (or list property):
Remember that 1024 bytes is 1 KB, 1024 KB is 1 MB, and 1024 MB is 1 GB.Also, each list member adds 500 bytes.
Hi @margauxplet , this video link might be useful in estimating a model size. I am not sure if there is an app for this.
https://community.anaplan.com/kb/articles/63606-model-size-and-dimensionality
@JaredDolich could you share the tooling template as an Excel file?
In this way, we can see the formulas which are behind.
I have been trying to understand how you come to the total of 66196490 cells, but it does not seem to correspond with the total of rows for lists and modules.
Which conversion do you use to go from cells to Mbytes?
Thank you!
Boolean cells require 1 byte each. Text cells are fixed at 8 bytes, regardless of content. Similarly list items use 500 bytes regardless of name/code length.
thank you all, I managed to build my own version of the template
Hi @aerodriguezv ,
I have attached the template which I created. Note that this has not been validated by Anaplan.
It would be nice if it could be validated by Anaplan. @JaredDolich or @Misbah ?
@LouiseBourgonjon
First of all we are not from Anaplan, so our vetting it doesn't mean Anaplan doing it 🙂
To me I believe it is extremely tough to calculate the model size in the design phase. There are so many nuances to it - Dimensions including Native Time, Native Versions, Switchover, Formats of line items, number of list items etc. However we can still give a ball park figure to the clients based on the experience from prior implementations and little bit of calculations based of the above information provided.
I am not sure if item of Native Time or Native Version takes 500 bytes of space as well - highly unlikely. If that was the case then without using Time as a dimension in the module we could see model size going up based on the number of time periods that we have set in the backend, which is not the case - atleast I have not seen that.
Also Number of Text Characters in any Text Formatted line item also drives the model size but you won't see it in the front end. Your may see model being 50 GB in the front end but in the backend it may be more than 500 GB due to excessive usage of Text formatted lines in the model - this reduces the performance but it doesn't add up to your calculations.
Switchover is another area where it gets tricky - any switchover cell doesn't add up to the total size.
Hope that was helpful
MisbahMIZ LOGIX
Hi @Misbah ,
Thank you for your clarification and the footnotes.
Using the Excel template which I shared above and which is based on the info shared by Jared Dolich, It gives a very good approximation of the cell count of a model, however, the estimated size in terms of GB is far off... I guess that is related to what you mention in your reply: influencing factors in the back-end which we don't take into account.
Thanks for this Louise!
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Hi, I need help. I have a hierarchical Line Item Subset (LISS) in my model. Sometimes, I want to select a parent item directly in a filter, so that only the parent is displayed — not its children. The challenge is that on a LISS, I cannot tick a parent in a module (since Anaplan only allows selecting child items). I tried…
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…