adjustedactuals, demand planning quantities are not getting populated

[former_member356014]

We copied SAP2 and added one more planning level SPCODE which together with Customer ID, Product ID indiactes a unique combination for demand data which we uploaded in "ActualsQty".

MarketingFcstQty, SalesFcstQty are also uploaded as key figurdata.

The adjustedactuals, demand planning quantities are not getting populated.

Please note all the key figures for demand planning are at "prodcustspcode" level and also agregated to "prodcust" level.

Eg. The system correctly populates "Marketing+Promotion frcst qty" based upon our uploaded marketing and promotion forecast quantitites at the above planning levels.

Request your guidance.

Regards

Atri Kundu

[Former Member]

Hi,

Have you defined a calculation for Actualsqty@perprodcust to use it in adjustedactuals@perprodcust?

Similarly for Mktgpromotionfcstqty@perprodcust to calculate demand planning quantity.

You can also see the graph of these key figures to find any broken link(in red)

Thanks,

Rohit

[former_member356014]

Hi Rohit,

Thanks for your reply. We have defined ActualsQty@perprodcust level. Here is a screen shot of Actuals Quantity calculation and Adjusted Actuals quantity calcultion

Still Adjusted Acuals Quantity calculation is not showing up in the excel. Same is for MarketingFcstQty, SalesFcstQty. Request your inputs

Adjusted Actuals Quantity and Actuals Quantity calculations

Thanks

Atri

[Former Member]

Hi Atri,

Can you check if the input for Adjustedactuals@request is marked as stored? If possible can you post the calculation graph?

Thanks,

Rohit

[former_member356014]

Hi Rohit,

yes the Input Key Fiures for AdjustedActualsQty@request is marked as stored.

Regards

Atri

[Former Member]

Hi Atri,

Then the issue is quite obvious. The calculation graph ends at first calculation itself where Adjustedactuals@perprodcustspcode is marked as stored, however you are not uploading value for this key figure as it is coming from Actualsqty@perprodcustspcode.

Please uncheck the stored selection at request level and you should be able to see the values.

Also , since adjustedactuals can be stored and calculated both, your second calculation should be like this-

Adjustedactuals@perprodcustspcode = If(ISNULL(Adjustedactuals@perprodcustspcode), Actualsqty@perprodcustspcode , Adjustedactuals@perprodcustspcode) ----Here input can be stored for both kf.

Similarly check the request level inputs for other key figures.

Thanks,

Rohit

[yeushengteo]

Hello

The ADJUSTEDACTUALSQTY is marked with both stored and calculated. I assumed you are trying to do defaulting based on ACTUALSQTY if it is NULL?

Hence maybe you can change the definition as follow:

1. ADJUSTEDACTUALSQTY@REQUEST = SUM(ADJUSTEDACTUALSQTY@PERPRODCUSTSPCODE) <= calculated input

2. IF (ADJUSTEDACTUALSQTY@PERPRODCUSTSPCODE is NULL), ACTUALSQTY@PERPRODCUSTSPCODE <= stored input , ADJUSTEDACTUALSQTY@PERPRODCUSTSPCODE <= stored input)

3. ADJUSTEDACTUALSQTY@PERPRODCUST = SUM(ADJUSTEDACTUALSQTY@PERPRODCUSTSPCODE) <= calculated input

Pardon if there is typo since the screen shot text is simply tiny...try it.

Regards.

YS

[former_member356014]

Hi Rohit and Yeu,

Thanks for your inputs. Its working now.

Regards

Atri

[Former Member]

Thanks, Please close the discussion by marking answered.