Macros and saving changes

[Former Member]

The forecast exection planning book has around 20 macros in it. We are noticing that when we make changes and save them it takes a very long time in some instances about 2~3 hours. In connection with this there are a few things that need to be clarified

1. Are all macros executed when a change is made? Is so then can we limit this and run all the macros in the background job that is set up?

2. At what level does the change have to made to effectively reduce the saving time - at the CVC level or an aggregate level.

Any suggestions are greatly appreciated.

[Former Member · Accepted solution]

Hi Sarita,

It means that when you the data and press enter the macros are automatically executed.

1)Either the macro is being assigned to the default level

or

2) go to macro builder -->open macro -->properties.check whether the macro is used in "no direct execution".

thanks

karthik

[Former Member]

Hello Sarita,

1- Not all the macro's are executed when a change is saved. It depends on the type of the macro .

Only the macro with the types "Exit" and "Default" will be executed when the planner saves the plan.

With the two other types : ( Change Level, Start , ) the macro is not excuted while saving.

You can also define a macro as a manual. In this case, only the user triggers the macro.

Depending on your planning process, you can choose to run (all) the macros in the background job .

For this, you can set the macro as "No direct execution " , then create an Activity, then a Background job, and you can eventually create a Process Chain to manage a chain of DP jobs, with the right sequence. Process Chains are great to organize the different planning processes.

Running Macro in background is an easy way to gain in performance.

2- The level of execution of the macro is very important but it depends on your business process and on the purpose of your macro.

In some cases, it is possible to execute a macro at the aggregate level. However, you have to be sure that the disagregation of the Key Figures follows the expected rules ( See calculation type of Key Figures and Aggregation and disaggregation ) .

When you run a macro in Background, you can decide to run it at the lowest level. ( Level is defined in the definition of each DP Background Job).

Best regards,

Jean-Francois Maitrot