Highlighted
Previous Contributor

Recursivity - Button to copy from one module to another

Hi Anaplan, I have an issue with a modele that requiere recusivity to optimise a KPI. My manual solution is the following :

  • I enter a paramater (let's call it A1).
  • Anaplan compute this value and give me the matching KPI.
  • at the same time modele produce a better value A2 for A1. Then i can copy this new value  A2 into the paramater A1.
  • And i repeat (usually 10 to 30 times) until my KPI is close enough to my target.

I would like to have a button which could copy the value A2 into A1 Even better i would like to have a button that could copy and compute and the repeat it 30 times or until some trigger is activated. Have you ever faced this issue ? Best regards, Damien

6 REPLIES 6
Highlighted
Previous Contributor

RE: Recursivity - Button to copy from one module to another

Hi everyone, I'm sorry that my wording may be confusing. How can I clarify that ? 1) I need a button to copy some data from one module to another one.  I can't use formulas because it would create a cicular reference. 2) Is it possible to make an action that would "click" this button 10 times. Best regards Damien
Highlighted
Occasional Contributor

RE: Recursivity - Button to copy from one module to another

Hi Damiel  I've faced the same case on a project when we had to align assets and liabilities for Balance Sheet in this case any change in assets cause change in liabilities and vise versa In their Excel model Customer analysts used solver solution functionality so we had to find similar solution for Anaplan For as-is solution we also had to launch import 30-40 times so the best thing I could do - to clear and realize algorithms of finding balance for this equation using not imports but formulas (backward calcs) As the result we now have to launch 3 imports instead of 30-40
Highlighted
Previous Contributor

RE: Recursivity - Button to copy from one module to another

Thanks Oleg for your reply, I understand that it's not possible to fully automise a "Solver Functionnality" in Anaplan It's not totally clear to me how you succeed to reduce your import from 30/40 to 3. How could you perform this optimisation ?
Highlighted
Occasional Contributor

RE: Recursivity - Button to copy from one module to another

It's as I usually do =) I usually take a piece of paper & a pen and build equations with variables It looks like you formalize Solver Solution case and replace it with backward formula to get  dependences between A1&A2 (variables)  I could try to help you with your case if you have it's logical description
Highlighted
Previous Contributor

RE: Recursivity - Button to copy from one module to another

Ok, i get it now. The issue with my model is that i can't turn it into equation because there are a lot of non linear steps (threshold, IF ... THEN, Impact over time, rules that impact the computation base on boolean...) therefore i can't compute a formula and turn it backward.   Actually i guess the solver wouldn't work in excel either. The client used VB script to find the solution by checking a lot of value. A last question, if you don't mind, about the usability of your solution. Regarding your import/export, how do you manage to make them user friendly ? Are you using an Action ? Did you make a script on a remote server ?  
Highlighted
Regular Contributor

RE: Recursivity - Button to copy from one module to another

Hi Damien, Despite received wisdom, this is actually possible in Anaplan. What you have to do is use the time dimension to implement the recursion. Here's how: [list=1]
  • Create a module, dimensioned by time, with a line item that performs your calculations
  • Set the line items up in this module so that each month looks at the previous month's approximation and adjusts its inputs accordingly
  • Set the Summary property of the relevant line items to Closing Balance
  • Your module will now iterate over the calculations, getting closer & closer all the time
  • Now you can get the result out into another module by using SELECT: Time.All Periods If you do this you won't need any actions or buttons - it's all formula-driven. Hope that helps!