Dissaggregation of a Keyfigure

[Former Member]

Hi Experts,

I m new to this forum.

I want to ask you  question. I have 2 products say prod A & prod B.

Product A

Open Orders :    100 50 30 20

Op Forecast :      50 30 30  70

Op Orders Adj:     50 20  0   0

Product B

Open Orders :    10 20 300 120

Op Forecast :      50 30 30  70

Op Orders Adj:     0 0  270   50

I have written a macro for this logic Like

if (Open Orders > Op Forecast)

Op Orders Adj = Open Orders - Op Forecast

Else

Op Ordrers Adj =0

This macro is working fine at dissagg level.

But when i check the result at agg level it shows like this:

Open Orders :    110 70 330 140

Op Forecast :     100 60 60   140

Op Orders Adj:     50 20 270   50

But i required instead of above result it should show this:

Op Orders Adj:     10 10 270   0

How to do it.Please explain?

[Former Member · Accepted solution]

Hello Nitish,

Could you please check one thing.

Go to /sapapo/advm Open your macro , double click on your macro name.

In the 'setting of the Execution' see if you have checked the check box  "Certain levels "   and selected the "AGG LEVEL".

If not please try doing this.This should help you.

Regards,

Anurag

[Former Member · Accepted solution]

Hi Anurag,

Thanks for your response.

I have maintained the settings of the macro as u suggested.

But it's not working.Same result is coming

Is i have to change my key fig settings for Op Orders Adj.

I have maintained it as calculation type "S"  and time based Dissaggregation as "P".

Can u please give  your suggestion?

[Former Member · Accepted solution]

Hello Nitish,

Please clear all the values of Key figure Op. Orders Apj. Save.

Try making your macro as default macro.

See If it works ? if yes then either you are using drill_down or you are going to detais all screen then executing the macro.

Regards,

Anurag

[Former Member · Accepted solution]

Hi Anurag,

Thanks for your quick response.

By making it a default macro logic is working.

But when i run this macro through a job it is not working at aggregated level.

So what settings could be done to a JOB,so it may get working??

Please suggest as this job have to be included in next Forecast Cycle.

[Former Member · Accepted solution]

Hello Nitish,

Not sure but you can have a look on this Note 412429.

This is related to your case.

regards,

Anurag

[Former Member · Accepted solution]

Thanks for your Help Anurag.

I have got my answer through this Note .