MACRO GENERATION

[Former Member]

i want to generate a macro in DP book which will give me the net forcast by substracting the actual billing from the expected forcast..as a key figure.

i had done this by simply entering a mathematical function that difference between the two rows but it is not showing the value in the table

please guide me for macro creation

regards

Kiran

[Former Member]

Can you reproduce the macro code here???

Check if your time period of the Macro main step and the iterative steps are in the correct period.

I suppose you had no errors when you generated the macro

[Former Member]

Macros

COPY_DEALER_DATA

New step : ( 42 Iterations : 16.05.2007 - 22.05.2007 ; 23.03.2008 - 31.03.2008 )

Row: Area Manager Billing Plan ( Frm 16.05.2007 - 22.05.2007 ) =

New step : ( 11 Iterations : 23.05.2007 - 31.05.2007 ; 08.08.2007 - 15.08.2007 )

Row: AM Exp PhyDel M&M ( Frm 23.05.2007 - 31.05.2007 ) =

DRILL_DOWN

STEP 1 : ( 11 Iterations : 23.05.2007 - 31.05.2007 ; 08.08.2007 - 15.08.2007 )

DRILL DOWN ACTION

COPY_DEALER_DATA_TO_AM_PLANNING_ROW

Forecast Netting

New step : ( 12 Iterations : 16.05.2007 - 22.05.2007 ; 08.08.2007 - 15.08.2007 )

Row: NETTED BILL ( Frm 16.05.2007 - 22.05.2007 ) =

Row: Dlr Exp. Billing ( Frm 16.05.2007 - 22.05.2007 )

-

Row: Dlr Billing Actuals (Trs) ( Frm 16.05.2007 - 22.05.2007 )

DRILL_UP

The above is replica of macro in Which Forcast netting is the macro created

revert back if any query

[somnath_manna]

The DRILL_DOWN action needs to be done only once (change the no. of iterations to 1 - just current bucket) and then try executing the macro.

Also the DRILL_DOWN action is part of a macro which in turn has to be in a collective macro. Please check macro "Drill down on product" in SAP example and template macros planning book.

Check the macro "Col macro: Drilldown, Calc, Drillup" for example of a Collective macro in "SAP Example and Template Macros (Part 2)" planning book.

Thanks,

somnath

[Former Member]

looks like something is wrong with the drill down

can you see if the macro works after making the drill down and up steps inactive?

[Former Member]

Hi Harish,

i want the difference location product wise also.... which is not happening