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!
Hi, would just like to clarify.
What is the size of a list item?
The first answer says 500+ size of text. (bytes) Is it 500 + (2 * length of character)?
The second answer says just 4.
List items are 500 according to this: https://help.anaplan.com/manage-model-size-b4f86ac2-5059-4977-b051-14f461373bfa
I have always been under the impression that text has a 2 byte per character memory cost as well, but have been trying to find in Anapedia where it states that explicitly, but am unable to find it. Do you know where I can find more information on that 2 bytes/char?
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…
