Increase 1 million list item limit for Order list action

KatherineY

Requesting to increase the limit of 1 million list item count for Order list action.

Currently we will get the following error when list item is over 1 million:

Cannot Run Action

The number of items in the list (1000001) exceeds the maximum allowed (1000000)

Screenshot 2021-09-16 at 5.10.27 PM.png

Comments

nick_barker

The issue with the current limit is that it seems to be applied to the total number of items in the list rather than the number of children a parent has. Since the sort is done within the confines of the parent it would seem that the limit should be on the maximum number of children any immediate parent has perhaps? but failing that then I would support the increase of the limit to a larger number.

mooreta

Upvoted.

Just ran into this as well. We have a supply chain use case where we have to concatenate what would be our dimensions in order to avoid creating an incredibly sparse model. If we didn't already have to do this workaround then we could order one of our lists instead of the entire concatenated list.

To @nick_barker 's point, we are ordering within the parent of which there are only 5-10 child members in our instance.

ChrisStauffer

Would like to be able to sort list of 20-30 million items by date to see the most recent items first.

akhil.kohli

Ran into this issue as well. We have an ICM use case and would want to have it across 30 million transactions to sort it by Processing date in order to see latest trades first.

For now we are creating a parallel list to solve this but that has size and performance limitations

Quick Links

New ideas

Assistance Required for Understanding User License Roles at Tenant Level - Anaplan
Team - As per my understanding, user roles should work as described in the table below, but it is not working as expected. Our expectation is to assign users to a read-only role to restrict their access to a specific model, instead of creating user roles within the model. Any insights would be greatly appreciated. Thank…
Text input on total level
Dears, We would like you to enable text input on text summaries. Could you please consider adding “text input” button for text type summary method? This will help a lot for better navigation, for example when commenting data on total level like P&L total figures.
Ability to Generate Management Reports based on a Hierarchy Chart
We currently have a requirement, working with a very large Bank on their Workforce planning use-case to view their Organisational Hierarchy in a Current and Proposed state. The UX view of the Hierarchy Chart works well, even with very large volumes of data. There is also a requirement to have a Management Report that…