Lock overwrite of snapshot

Options
riddhishah17
riddhishah17 Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Extensibility

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?

Tagged:

Comments

  • jasonblinn
    jasonblinn Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Master Anaplanner/Community Boss

    @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

     

     

     

     

     

  • riddhishah17
    riddhishah17 Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

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

Categories