Locking data in a module after import

Hi All,

We have a requirement where the client wants to fix data in a module after an import so as to prevent accidental override of data if another user run the import process in the same module.

Is there a way to implement this locking of data.

Regards,

Prateek

Accepted answers

All comments

[Deleted User]

There may be a more 'official' way to do this but here is how I've accomplished this. Create a new line item in the module you are importing into. Once you have the data imported, do a straight reference formula in the new line item pointing at the original (where your imported data resides) . Once you have entered the reference formula and all data has populated, simply delete the formula itself. The data will now stay static and not update as there is no longer a formula.

ChrisWeiss

Hi Prateek,

You're right that this is a challenging request, without implementing a strong business process to prevent overwriting the data (perhaps through dashboard instruction text).

Another option would be to enable Workflow for that list, so that after the import is run for the first time the user marks the data as Completed, which then turns each completed list item to Read Only data. Of course the typical Workflow considerations still apply, so maybe not the best solution, but definitely something to consider when it comes to locking only a subset of data within what should be a read/write module.

Good luck!

s.jansenidw

You can also try to build a staging module and a final module.

The staging module will only send data to the final module when a boolean (lock load) is ticked, in that way you can control when you want to update the data.

leo_tadjudin_1

@Prateek_S someone just posted a Job Aid that might be useful to give that impression of locking. This is assuming the "locking" is required only for specific line items.

https://community.anaplan.com/t5/Anaplan-Platform/Job-Aid-Copy-Current-Plan-to-Original-Plan-Using-Actions/m-p/22319#M396

Another way is to play with access right if the "locking" is required on module level. The original import could be done into a module which is given WRITE access only for Model Admin and READ for all users.

Hope it helps.

Thanks,

Leo

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…