In certain situations we need to execute 2~3 macros one after the other when user goes into interactive planning book or even could be for background processing. This needs to be in a sequence so that we have right results, example first copy key figure A to B, then copy key figure C to D and finally compare B to D and put variance in another key figure (in %).
This all could be done with the help of collective macro. In /SAPAPO/ADVM drag and drop Macro. Thereafter select macro type as collective macro.
Thereafter you will get option to select macros which needs to be executed. Put them in sequence in which you want to execute. Put this macro as default/start etc. event as per your requirement. If you are putting this in background job then select right aggregation level so that data is copied accordingly.