Highlighted

Limitations Of List Members Of General LIst.

How many list members can we insert in a list at a time.

5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: Limitations Of List Members Of General LIst.

Hi,

 

There are no limitations, we can add N number at a time.

 

~Vignesh M

Highlighted
Community Boss

Re: Limitations Of List Members Of General LIst.

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.

Nathan Rudman
Anaplan Model Builder
Highlighted
Community Boss

Re: Limitations Of List Members Of General LIst.

pratyaksh.dua@polestarllp.com 

 

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

Master Anaplanner/Community Boss

Re: Limitations Of List Members Of General LIst.

Hi pratyaksh.dua@polestarllp.com 

 

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:

Screen Shot 2020-01-06 at 09.27.53.png

 

Thanks,

LipChean

Highlighted
Master Anaplanner/Community Boss

Re: Limitations Of List Members Of General LIst.

Hi pratyaksh.dua@polestarllp.com 

 

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!

 

Thanks,

 

Usman