SNP keyfigure

[Private_Member_738444]

Hi Folks,

There is a default key figure in SNP Planning book 'Supply Shortage'.

This key figure gets populated by a default macro (?! I am unable to spot this macro though ) in all SNP planning books.

Supply Shortage acquires a entry the moment Demand > Stock in Hand (this keeps happening 24X7 every instance new demand <sales orders & forecast> keeps pouring into the planning book)

The planning run (Heu/ CTM or optimization) which happens once every week, incorporates this & generates receipts & production orders. Does this has any effect on 'Supply Shortage' & 'Stock in Hand' ?

My issues is however like this :

Currently we have a product say A, maintained at 10 locations in APO.

Product A has individual supply shortages at some of these 10 locations, however when we try loading all 10 line items in one go we don't get the total value as the summation.

My hunch being it has something to do with the macro definition, its bucket definition & trigger processing (?! Is it the case )

Any pointer would be heartily appreciated.

Thanks

kumar

[former_member187488 · Accepted solution]

Hello Kumar,

As you understand, the supply shortage is calculated by macro "Stock Balance", the last step.

Since it's a default macro, it will get executed every time you load or change data, or drill down/up in the planning book.

But key figure 'supply shortage' is just an auxiliary key figure, the value of which won't be saved in liveCache. So background heuristic/CTM/optimizer run won't have any effect on this. It is only used for display purpose in the planning book when you're in interactive planning.

Generally the macro only works fine in standard SNP planning book 9ASNP94/SNP94(1) when you load single location/product. If you want to work with multiple location products, you'll need to use planning book 9ASNP94_INTERACT/SNP94(1)_INTERACT. This planning book has more complicated macros with auto drill down and drill up actions, thus the performance may be affected.

Best Regards,

Ada

[Private_Member_738444 · Accepted solution]

Hi Ada,

Appreciate your detailed explanation.

As you said 'SNP Shortage' is an auxiliary key figure, so I checked & found another key figure 'Supply Shortage (Aggregated)' found in all planning books.

Now this key figure 'Supply Shortage (Aggregated)' is aggregating the supply shortages of all locations & showing as correct summation in the TOTAL field.

And this key figure 'Supply Shortage (Aggregated)' shows the same results in all planning books.

On the other hand key figure 'Supply Shortage' had some random values in some locations, however the TOTAL field was always a blank or some random number.

My guess is key figure 'Supply Shortage(Aggregated)' must not be an auxiliary key figure then? right?!

How do one check which are auxiliary & which aren't?

Thanks

Kumar

[former_member187488 · Accepted solution]

Hello Kumar,

I suppose  key figure 'Supply Shortage(Aggregated)' is also auxiliary.

It has correct value is because there's complicated calculation macro for it, as I have said previously.

Auxiliary key figure is not defined in planning area (/sapapo/msdp_admin), instead it's defined in planning book directly (/sapapo/sdp8b).

Best Regards,

Ada