S&OP Key Figure Offset by 1 Period

[former_member329476]

Dear All,

I am trying to mimic the offsetting logic, but not see why it is not working.

Thanks a lot for you hepl.

Kind Regards,

Omar

Existing Key Figures offset by 12, working

ACTUALSQTYPRIORYR@REQUEST = SUM( "ACTUALSQTYPRIORYR@PERPRODCUST1" )                                  Input Key Figure : ACTUALSQTYPRIORYR@PERPRODCUST1

ACTUALSQTYPRIORYR@PERPRODCUST = "ACTUALSQTY@PERPRODCUST"

Input Key Figure : ACTUALSQTY@PERPRODCUST

PERIODID0@PERPRODCUST1 =  "PERIODID0"  + 12

Input Key Figure : ACTUALSQTYPRIORYR@PERPRODCUST

PERIODID@PERPRODCUST1 = "PERIODID"  + 12 

ACTUALSQTYPRIORYR@PERPRODCUST

New Key Figures offset by 1, not working

BEGINNINGONHAND@REQUEST =  SUM( "BEGINNINGONHAND@PERPRODLOC2" )

Input Key Figure :BEGINNINGONHAND@PERPRODLOC2

BEGINNINGONHAND@PERPRODLOC = SUM( "PROJECTEDINVENTORY@PERPRODLOC" )

Input Key Figure : PROJECTEDINVENTORY@PERPRODLOC

PERIODID0@PERPRODLOC2 = "PERIODID0"  + 1

Input Key Figure : BEGINNINGONHAND@PERPRODLOC

PERIODID@PERPRODLOC2  =     "PERIODID"  + 1

Input Key Figure : BEGINNINGONHAND@PERPRODLOC

See error log attached

SAP2 Error.txt.zip

[Alecsandra]

Hi Omar,

Your error is linked with BEGINNINGONHAND@PERPRODLOC = SUM( "PROJECTEDINVENTORY@PERPRODLOC" ) calculation. You cannot perform these 2 operations (assignment and aggregation) into 1 step. You need to split.

For example: in PROJECTEDINVENTORY KF you could add one more calculation at an aggregated planning level.PROJECTEDINVENTORY@AGG = SUM( "PROJECTEDINVENTORY@PERPRODLOC" )

Then have your calculation BEGINNINGONHAND@PERPRODLOC =  PROJECTEDINVENTORY@PROJECTEDINVENTORY@AGGAGG

Regards

Alecsandra

[Former Member]

Hi Alecsandra,

We are configuring ACTUALSQTYPRIORYR (already available) and ACTUALSQTYPRIORTOPRIORYR (configuring). In this case we are using same PL PERPRODCUST1 and I am using PERIODID1 for ACTUALSQTYPRIORTOPRIORYR calculation but does not work.

Why do we need to set the PERIODID twice, in PERIODID0 and PERIODID?

PERIODID0@PERPRODCUST1 =  "PERIODID0"  + 12

Input Key Figure : ACTUALSQTYPRIORYR@PERPRODCUST

PERIODID@PERPRODCUST1 = "PERIODID"  + 12

ACTUALSQTYPRIORYR@PERPRODCUST

Regards,

Aditya G