If anyone has an interest, I have a recipe that allows to replicate Excel What-If Two-Variable Data Table functionality in Anaplan aka sensitivity/incremental change analysis of drivers.
Hey Anya,
I would like to know the methodology you have used to do the What-if Analysis. I had a similar situation in my project which I achieved via Import actions. First, I would import the input value and then snapshot the output to a output module. I would not consider my approach as the most efficient method of performing What-if Analysis as actions are slow and might also lead to funny results in some cases. Looking forward to hearing from your side on how you created the What if analysis in Anaplan.
Cheers,
Gaurav
Hey @AnyaS thanks for sharing!
Would it be possible to share the blue print view and formulas? this would help us to see more in detail how the method works.
I agree with @gaurav_sharma-bng using import processes can make it easier when dealing multiple changing variables like this.
Thanks,
Usman
Hi, I have a form action button that adds a L5 list item to a hierarchy. L5 does not have selective access but L4 does, but I still see all L4 list items in the dropdown when I trigger the form. How can I only view the ones I should have selective access to? L5 does not have selective access. L4 is also a selector on this…
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
