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?

Answers

  • @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. 

     

    jasonblinn_0-1626984519632.png

     

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

     

    jasonblinn_1-1626984615452.png

     

    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.)

    jasonblinn_2-1626984763936.png

     

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

    jasonblinn_3-1626984825598.png

     

    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

  • 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

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