Hi,
Is there a way i can lock actual data when importing in Anaplan ?
I have changed the version edit from and edit to but when i test the import, prior period are being updated by my load.
Thanks in advance for helping.
Regards,
Tom
@tompatrickting22
'Edit to' and 'Edit from' is the best option to restrict the data feed into the specific versions. It should work.
But if it not working out, your can use the dynamic cell access as well. Create a module with a 2 boolean line items with the versions and use it as a Read/Write access driver. Whenever required you can lock the specific time periods for any version you want.
I hope it helps
~Anand
Hi @anand.shekhawat
Thank you for responding. I have already set the "Edit from" and "Edit to" in our Native version, but when I test to run an import, prior periods are still updated.
Am I missing something here ?
@tompatrickting22 ,
The import action will let you to import the data in all the cells if you have an administrator access of that particular model/workspace irrespective of the periods set in 'Edit From' and 'Edit to'. Once your admin access is disabled (like the end users) you can only import the data in the selected period only as set in 'Edit From' and 'Edit to' fields. The same goes with the Dynamic Cell access as well.
@tompatrickting22 As mentioned by @anand.shekhawat ideally you cannot restrict data updates via import. However if you really want the import to lock the Actuals data, I would create a transactional module as a temp module to load all the data via import from the source, then create a saved view with filters to show only forecast months and use this saved view to import into the main module wherein you want to lock actuals.
Hope this helps.
AB
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
