Remove 10 million item limit from the ISFIRSTOCCURRENCE function

Remove 10 million item limit from the ISFIRSTOCCURRENCE function

Brief description of the idea

Remove 10 million item limit from the ISFIRSTOCCURRENCE function

 

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.

13 Comments
Community Manager
 
Status changed to: Your support is needed
Community Boss
 
Status changed to: Under Investigation
Certified Master Anaplanner

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.

Master Anaplanner/Community Boss

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

Master Anaplanner/Community Boss

@usman.zia 

hang tight

Coming soon hopefully

David

Master Anaplanner/Community Boss

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

No expected performance implications? 

Community Manager
 
Status changed to: Your support is needed
Master Anaplanner/Community Boss

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

David

Regular Contributor
 
Status changed to: On Roadmap
Master Anaplanner/Community Boss

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. 

 

Master Anaplanner/Community Boss

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

Master Anaplanner/Community Boss

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

Occasional Contributor
 
Status changed to: Delivered
Users Online
Currently online: 75 members 361 guests
Please welcome our newest community members: