Line item to generate date system date based on the boolean selected

Options
mkarnati90
mkarnati90 Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor
in Anaplan Community

Hi All,

 

This is the first time i am here. I am looking for the solution to the below problem.

 

1. I wanted to generate a date based on the boolean checked which will be used for freezing my values. 

For example: If i have checked boolean on Nov 28, all the values post 28th should be freezed. For achieving this i came up with an approach of creating another line item for date. Therefore based on the date that boolean has been applied, my values will get freezed. 

So my requirement now is to see the date on which boolean was checked.

If any user checks the value post nov 28th still the future values will be shown as the values on nov 28th.

 

Please let me know if there is any other approach as well. 

Tagged:

Comments

  • nikolay_denisov
    nikolay_denisov Member, ALL USERS, GroupMember, Master Anaplanner - Employee, Certified Master Anaplanner, Employee, Certified Model Builder Posts: 5 Master Anaplanner of the Year
    Hello, I think it would be great to see more examles of your case to understand why you might need it. But I could share my general thoughts about approach:
    I think it is not feasible to auto-populate date formated lineitem with system time once anyone clicked the checkbox. (unless you could leverage that with sophisicated integration job using Anaplan Connect or something)
    But you could ask users to fill the date field by themselves and then trigger DCA rule which will block the "Conditional" line items with input filled fields to be read only. Then based on this input you could set up additional DCA rule which will block your grids of the major inputs.
    Happy to followup if you provide more details and feedback
  • mkarnati90
    mkarnati90 Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor

    Hi Nikolay,

     

    My use case is as below.

     

    Users will check the freeze boolean option and based on that boolean selected future forecast values should be freezed. New data ingestions or changes of any other factors should not change the freezed forecast values.

     

    So, i came up with an approach where if the user checks the boolean an automated date should be generated, suppose say if user has checked the boolean on Nov 14th, then the forecast should remain same as on Nov 14th, irrespective of new ingested values and other calculating factors. 

     

    Hope this helps.

     

    Thanks and Regards,

    Mamatha

Categories