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 want to do a SUM from the source module which has native users, SKU list and time dimension to a target module line item by all users by SKUs. Target module only has a subset of the SKU list and nothing else. Need some inputs on how to build the mapping for the SUM. Is it also possible with the Anaplan native users list…
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
