What is the maximum list items, can I add in a list?
Hi @Sravan_Kumar ,
There is a limit for numbered list - 999,999,999. But I haven't seen any such limit for general list.
https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Lists_and_Roll-ups/Numbered_Lists/Numbered_Lists.html
Thanks,
Yash
It is also worth noting that the real maximum is the index number at 999,999,999. If I create a new list and then add one item the index for that item is #1. Then if I delete that item and create a new item the index of my next item is #2. #1 would not be able to be used again until I reset the index.
Therefore if I have 0 items in my list and my next index # available (because the rest have been cleared) is #1000000 then I am not able to add 999,999,999 items as the first 1,000,000 Index numbers have been used.
You can Reset the Index Number manually, but the true maximum number of items you can add to a list at a given time = (999,999,999 - Current Index #)
The other factor here is that a list member is 500 bytes, so there may be a size constraint within your workspace. At 999,999,999 items and 500 Bytes a Piece, that gets to almost 500GB which would not fit within a workspace at this point. You would also want to factor in anywhere that the list was used as a dimension to find the amount of size that the cells are taking as well.
https://community.anaplan.com/t5/Anaplan-Platform/Calculation-of-modules-amp-Size/m-p/44695?_ga=2.190928297.2035036762.1586793311-1876461626.1579557669#M5300
I hope this helps!
Jason
That's great @Yash1.
I was seeking the limit for general list.
The same applies to general lists. Each item in a list - numbered or not - is assigned an index in this range.
So much detailed, very helpfu.
Thanks @jasonblinn
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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,
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…
