cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating CAPASUPPLY

neeraj_deshkar1
Active Participant

Hello Experts,

We have a requirement as below. Need help on configuration part.

Resource's available capacity is loaded in hrs. in keyfigure - ZCAPACITY (PL - WKRESLOC).

Then we have another KF (ZADJCAP) to add adjustments in hrs. at WKRESLOC level. So total capacity is calculated in Hrs. in ZTOTALCAP keyfigure at WKRESLOC level.

Thereafter we want to update CAPASUPPLY keyfigure in seconds based on ZTOTALCAP calculated in above step. This requirement is already achieved using copy operator. However we want to avoid copy operator here. We have tried with direct KF calculation for CAPASUPPLY. However it's not working. CAPASUPPLY is an input keyfigure. Can we write calculations for IBP standard input keyfigures?

Thanks,

Neeraj

Accepted Solutions (1)

Accepted Solutions (1)

piyush_parekh
Active Contributor

Hi Neeraj,

Though not recommended, below approach will work in case of heuristic based planning only.

1. Write a calculation in CAPASUPPLY key figure. Mark key figure as both stored and calculated.

CAPASUPPLY@WKRESLOC = ZTOTALCAP@WKRESLOC * 3600

2. In ZTOTALCAP and all associated key figures (ZCAPACITY and ZADJCAP), select "Indirect Input for Supply Planning" option in I/O for Supply Planning dropdown.

3. Make sure you mark CAPASUPPLY as calculated (remove Stored Value check) in UTILIZATIONPCT standard key figure calculation and also in all other custom key figures in which CAPASUPPLY is used as input.

Regards,

Piyush

neeraj_deshkar1
Active Participant

Hi Piyush,

My apology for replying very late.

The issue is cracked. For some reason we have dropped to have CAPASUPPLY in seconds. So now we need CAPASUPPLY = ZCAPACITY + ZADJCAP. Below is the calculation written for CAPASUPPLY KF.

CAPASUPPLY@WKRESLOC = "ZCAPACITY @WKRESLOC" + "ZADJCAP @WKRESLOC"

CAPASUPPLY is changed from stored to stored and calculated.

ZCAPACITY is stored, not editable & indirect input for SP.

ZADJCAP is stored, editable & indirect input for SP.

Also I have taken heuristic & optimizer run. Both are working & generating appropriate results.

Regards,

Neeraj

Answers (2)

Answers (2)

limbagiri
Explorer

Hi Neeraj,

Can you execute COPY and SCM (optimizer) operators in a sequence using one application job template ?

Without COPY operator you cannot achieve what you are expecting. If I understand your requirement correctly that you want to avoid manual execution of COPY op, then executing the same COPY op before optimizer execution using customized application job template may solve your problem. Let me know your thoughts.

Thanks

Sai Samrat

neeraj_deshkar1
Active Participant
0 Kudos

Hi Sai,

Thanks for your inputs.

Actually we want to avoid planning operator (copy, disagg etc...). So after user enters adjustments thereafter CAPASUPPLY should be populated automatically (using KF calculations).

It seems this is not possible given that we want to execute optimization based planning.

Thanks,

Neeraj

neeraj_deshkar1
Active Participant

Hi Piyush,

Thanks for your reply. I missed to state in my initial message that we are using optimizer for supply planning. Hence probably this approach will not work as optimizer would expect stored values as input from CAPASUPPLY keyfigure.

I have tried first 2 steps same as you have mentioned. However it did not return any output. I shall give try one more time today & update result.

Thanks,

Neeraj

piyush_parekh
Active Contributor

Hi Neeraj,

This configuration will show you calculated values in planning view for CAPASUPPLY keyfigure but as rightly mentioned by you, optimizer would expect stored values of constraints as input.

Please share key figure configurations including input key figures if it doesn't work.

Regards,

Piyush