Remove 10 million item limit from the ISFIRSTOCCURRENCE function

Brief description of the idea

Expected benefit/impact

Removing this limit would allow imports to be ran into large hierarchies that are referenced in ISFIRSTOCCURRENCE formula. Currently they fail with an error message.

Comments

Miran

Status changed to: Delivered

Rebecca

Status changed to: Delivered

kjacokes

We have a lot of processes at our clients that will run just fine for months or years, and all of a sudden start failing due to this, when a record list hits 10M records. Would love to see this addressed, as it creates a lot of work and uncertainty / issues with reliability for our clients.

usman.zia

Hi!

It would be really useful for the 10 million items limit for isfirstoccurence to be lifted.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ISFIRSTOCCURRENCE.htm

If the product team could comment on why this is? (I believe it is due to performance implications and if it is there better way to achieve this on large data sets?)

Thanks,

Usman

DavidSmith

@usman.zia

hang tight

Coming soon hopefully

David

usman.zia

Thanks @DavidSmith I can't wait for that to come!

No expected performance implications?

Miran

Status changed to: Delivered

DavidSmith

Not so far in testing, we may introduce some limits as a cautionary measure - We are testing out different limits

David

Gwen.pryor

Status changed to: Delivered

alexpavel

this could be really helpful when big extractions from ERP systems at a very detailed level needs to be imported in Anaplan and are used to update the lists from these extractions.

the summary modules are working...but updating the lists it can become a little difficult to find workarounds: using different lists, sub-sets...etc.

DavidSmith

This is now delivered - The limits were increased to 50 Million in May

DavidSmith

This is now done - The limits were increased to 50M in May

vicky_ascencio

Status changed to: Delivered

CommunityMember117772

Reviving this thread - Any color on how 50 million was determined? This still seems low - for example a large company simply building lists off a 50 million item GL transaction list - yes that is not Planual ideal but we rarely live in a perfect world..

Quick Links

New ideas

Virtual Data Warehouse using Anaplan metadata
We are writing from Centrify Solutions, an Enterprise Data Integration +AI company. We have developed a solution that integrates metadata from Anaplan and external sources like NetSuite into a virtual data warehouse. This creates a dynamic large language model that can be deployed internally to any data source or securely…
How CloudWorks Changed My Day-to-Day Work
Hello Everyone, I’ve been using Anaplan CloudWorks, and honestly, it has completely transformed the way I handle daily integrations. What I love most is how simple it is — you don’t need deep technical knowledge to get started. It’s simple, user-friendly, and has become an essential part of my daily workflow. If you are…
Select All Members in a Time Level Instead of One at a Time
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: In a working grid I click 'show/hide' and select 'Time'. My time hierarchy is FY > Half > Quarter > Month > Week. I want to display…