How many list members can we insert in a list at a time.
Hi,
There are no limitations, we can add N number at a time.
~Vignesh M
to my knowledge there's no limitation to the number of elements you can insert at once.
I'd be curious to know how many you can include from the GUI at once.
If you do this by import, you should only be limited by the list size limit, which is 999 999 999.
And remember, one list item is 500b of data.
@PratyakshDua01
Anaplan's list can handle only 999,999,999 items in it (post which it needs to be reset) . However Anaplan workspace size can not go more than 130 GB and every list item consumes 500 bytes (approx), now if you do the maths, you will be able to load less than 250-260 million items at once because you might hit 130 GB threshold.
Also the upload time into anaplan is directly proportional to the number of entries that you want to load. Just to give an idea it takes around 15-18 minutes to get the 15 million transactions (with couple of properties) loaded into anaplan
Hope that helps
Misbah
Hi @PratyakshDua01
There's an index in the background that keeps track of all list member created, this index cannot exceed 999,999,999.
For example, if you have a list called "Transaction", and if at any time, you only have 1000 members, and you only have 1 module called "Transaction Module" with a number formatted line item called "Sales".
Then the total workspace consumed is about 1000 * 500b + 1000 * 8b = 0.508 Mb
Note: 1 list member takes up 500b per member, 1 number format takes up 8b.
If you keep deleting all 1000 member and recreating different 1000 member, the index in the background will increase from 1-1000 > 1001-2000 > 2001 > 3000 , etc etc. One day you'll hit 999,999,999, and when that happens you'll need to reset the index. Please refer to https://help.anaplan.com/anapedia/Content/Modeling/Dimensions/Lists.html
Now, if you want to test the limit of how many concurrent list members you can have in Anaplan, then it's as @Misbah said, it's about 250-260 million member. The maths is as follow (assuming we also have 1 module with a number formatted line item using this list)
(250,000,000 * 500b + 250,000,000 * 8b) = 118Gb approximately.
Having said that, i'm a little concerned if you are bringing such large amount of data into Anaplan. Please refer to https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866
especially the section below:
Thanks,
LipChean
Always worth considering why you would need that amount of list items and if the reason is having multiple transactions then it may be better to use a consolidated data source with less items.
Anaplan is an amazing tool but currently using extreme dimensions does not work well and it definitely not a data science tool.
I would never recommend to ever using anaplan with 999,999,999 items its crazy!
Usman
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
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?
