Macro to clear values for a key figure for one product on detail level

[Former Member]

Hi Experts

I am looking the key figure at detail level for 5 products and I wanted to put 0 in one of the product.

I am not able to find out the macro which ll help me in doing the same.

Regards

Hitesh

[Former Member · Accepted solution]

Hi Hitesh,

You need to be little more clear about the issue, becuase deleting data is varies from DP to SNP keyfigures.

if it is a DP keyfigure, we can write a macro to make the keyfigure as ZERO, and to make the same at detail level you need choose the aggregation when you generate background job for macro, in Mass processing.

and you can create a temp'ry selection profile for the 5 materials to satisfy your requirement and use the same in mass processing

If it is SNP keyfigure, you can not make the same with macro, we have specific transaction codes to delete the live cache orders. if it is SNP order, just let me know what keyfigure it is? if i am able to find the Tcode i can suggest you .

Hope this information will help you

Yarala

[Former Member · Accepted solution]

Hi Yarala,

This is regarding DP keyfig., Yes I have created selection for 5 and i ll be using the same in background, only thing I did not find macro to delete a perticular characterstic value at KF level.

can you please help me with the macro.

Thanks!

Hitesh

[Former Member · Accepted solution]

Hi Hitesh,

I guess youneed generate new quick Macro... or you can get from the standard macros a copy of RESET MACRO's

if you wont find, try like

Macro name: Reset macro name

Step: no of iterations you want to make zero ( probly for entire future horizon)

result row: KF that you want to set ZERo =

operator/Function: Calc icon '0'

Hope this structure will help you to dosing the macro. if you are doing it in production directly then will need less efforts, otherwise you need to transport again with all the linked objects PB etc.

Let me know if you need any more help

Yarala

[Former Member · Accepted solution]

Yarala,

I am using ROW_CLEAR function currently, but I wanted to clear row only for one characterstic on drill down level.

do we have any macro where we can clear KF(product1)= 0

thanks

[Former Member · Accepted solution]

Sorry Hitesh,

apparently i do not have any ...

But are you not able to find the standard macros from Dev system?

Please ref to 9AEXAMPLE planning book which is made for standard macros, there will be few other plannign books also ... please check

Yarala