Macro to Display KF in SNP

[Former Member]

Hi All,

I have a user defined Key figure in SNP planning book. And it must be editalbe only at the detailed level(LocProduct specific).

If we load multiple location Product, It should be display only. Showing the total values from all produc location.

I'm using Row input function, and but it's executing for single product and also for multiple products selection.

I have tried all combination( Level1, aggr). KF is set to attribute.

Any help will be appreciated.

Thanks

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Have you used this logic as a Default Macro.

If DET_LEVEL( '9ALOCNO' ) = 1 AND DET_LEVEL( '9AMATNR' ) = 1

Row ( KF ) = ROW_INPUT( 1)

Else Row ( KF ) = ROW_INPUT( 0 )

Please let me know if it helps

regards,

biplab

[Former Member]

Hi Ravi,

As per my understanding you want to write the macro so that user can edit it at detalied level and not at aggregated level.

Please check the steps mentioned below to write macro.

New macro

New step : ( 22 Iterations : M 04.2009;Y 2011 )

IF

New condition

DET_LEVEL( '9AMATNR' ) = 1

AND

DET_LEVEL( '9ALOCNO' ) = 1

Row: Sales Forecast ( Attributes ) =

ROW_INPUT( 1 )

ELSE

Row: Sales Forecast ( Attributes ) =

ROW_INPUT( 0 )

ENDIF

Make sure that you make the "ROW" for "Attibute change"

Hope it helps to write the same macro.

Regards,

Prafulla