Macro FIX_CALC()

[former_member566355]

Hi,

I am trying to use the mentioned macro but it is not working. The requirement is to fix the value at aggregate level. If the user makes any changes at detail level, the total should remain same.

the syntax which I used is : -

FIX_CALC (

ROW : KF1 (FRM 20.03.2013)

ROW : KF2 (FRM 20.03.2013)

; 'INNPUT_CHECK' ;

ROW : KF1 (FRM 20.03.2013)

)

data source for KF1 is 'Z ROW ATTRIBUTE'  and for KF2 it is 'value'

When I execute the macro in 'interactive planning' no changes take place in KF1.

Please let me know if I am missing anything ?

Regards,

RS

[rajkj]

Hi RS,

Either set the macro to execute only at aggregate level (Macro settings for execution -> Certain levels -> Aggr Level) or use a condition block to check aggr level using macro function AGG_LEVEL before executing the macro function FIX_CALC.

Apart from that, your pseudo code looks good.

Thanks,
Rajesh

[former_member566355]

HI Rajesh,

I tried executing the macro at aggregate level but it is still not working.

I tried another approach where I have done the following steps ...

1. Created 2 info objects of 'APO' type - X1 and X2. I want to fix the KF X1 at aggregate level.

2. X2 is entered in the field 'Fixable key figure' in X1.

3. In planning area KF details, X2 is maintained as fixable KF.

4. Then I manually entered quantity at aggr level in X1. Saved tha data. But when I drill down to detailed level and change any value at details level the total is also getting changed.

Could you please let me know if this is the right approach or if I am missing any step ?

Regards,

RS