Lock overwrite of snapshot

Hello,

I am currently working on a scenario planning model, where I have two custom versions lists. My first list is a "modeling scenario" list, which is user editable. And once the users decide to lock their assumptions, they create a new "snapshot scenario" and run a process to copy over the data from the modeling scenario to the snapshot scenario. However, in the way that the process has been set up, my users are able to overwrite a snapshot scenario multiple times. Is there a way to filter out what snapshot scenario is blank and can therefore take a modeling scenario mapping?

Accepted answers

All comments

jasonblinn

@riddhishah17

I have solved this before using a Dependent Dropdown. See the example below:

First off, I have replicated a module that has many different snapshot versions on it. (B1,B2, etc) This is where I would store the snapshots that you do not want to be edited.

As data gets populated, I am creating a filter that shows that that particular version has Data.

I am then using that filter to drive a property that is used in the dependent drop-down. I am saying that if the Filter is checked, don't display anything, otherwise display Yes (Or whatever list member you want to use as the property.)

Since that version has been used, it is no longer able to be selected from my dependent dropdown.

Now as more snapshot versions get populated, the available list continues to shrink and does not allow for you to import over data that has already been populated. Dynamic Cell Access (DCA) could also help if you need to display the snapshotted data anywhere to lock it down so that users cannot manually edit it.

Hope this helps!

Jason

abhay.kanik

That is a great approach @jasonblinn ,

@riddhishah17

I have done it using DCA till now, You will need 4 more line items to do it.

Line item 1 - Locking Driver(Boolean) - Set it as true

Line Item 2 - snapshot scenario Flag(Boolean) - no formula

Line Item 3 - Read Driver (Boolean) - if item(Scenario List)= Scenario List.snapshot scenario and snapshot scenario Flag then true else false

Line item 4 - Write Driver (Boolean) - Not(Read Driver)

Use the read and writer driver for DCA

Now to make this work update your saved view for action and make sure you import from Locking Driver to snapshot scenario Flag after copy action . Keep action separate and you can put both in a process.

This will allow you user to update once but not second time as it will be locked once flag is imported.

You can also Create an admin action just to reset the flag back to normal at the time of reforecast. add a new line item for that .

Thanks

Abhay

riddhishah17

Thank you, @jasonblinn and @abhay.kanik! I will try the approaches and let you know how they worked.

Quick Links

Can you help?

Unanswered questions

Looking for Anaplan End-Users to take a short survey!
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…