The *FOR / *NEXT statement is used for loop purpose in BPC script logic, one task we need to achieve is to carry over value from first loop to second loop. for example the following script will loop from Jan to Mar, how could I pass the value e.g. planning amount for Jan to second loop Feb and so on. in ABAP or FOX it's a basic thing done by define a variable and pass that value to the variable, anybody know how to do this in script logic?
*FOR %month% = 2006.JAN, 2006.FEB, 2006.MAR
You cant achieve this for big scenario as you need to hard code every thing, like for using the calculated value of Jan in Feb you need to define script for Jan and commit it then define script for Feb to use the calculated value of Jan and so on.
you need to go either by BADI or Excel formulas.
The Script logic exceutes in a parallel fashion, and so the calculated values of previous month cant be used for next time period.
Even Business rules will not help, they to work the same way.
Hope this helps,