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
I am trying upload data from a CSV with date. For size reasons, I don't want to dimension the module by date but bring it in as a line item formatted as date. The problem is that person that will be doing the upload is in Italy, and their date format is different. When she does the upload, the date gets messed up…
Hi, when I am assigning the account to the territory I am always facing error as below and account never get assigned to the territory , what could be the reason ? When I use same method for unassign it works .
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
