IBP Configuration: Capacity per week Key Figure

[eddyizaguirre3]

Hello IBP Experts,

We have a planning area with a planning profile that represent a fiscal Calendar. We have some demand planning KF in fiscal weeks but most of our supply planning KF are in fiscal months.

However, the customer still requires to have a Capacity per week key figure expressed in monthly buckets.

The formula is pretty straightforward: Total Capacity / # weeks in a Period

Notice that the denominator is # weeks in a period and not in a month, as we want the KF to be Dynamic, pretty much recalculated at request level. However, I am having issues getting the behavior that I want, which is the one expressed in the image below

I have tried two configurations so far:

1.- Use a time profile attribute Linked to the PERIODID4 ("Month), issue here is I cannot use the time attribute at request level

2.- Used a Key Figure "Weeks in a month" at MTHLOC. However, it doesn't work when I aggregate to resource level only for resources that are used in different locations (Yeah-we have those)

Any ideas?

Thank you!

[piyush_parekh · Accepted solution]

Hi Eddy,

Pls try below:

1. Configure a key figure KF1 at fiscal week prod loc level with aggregation mode as max. Aggregate this key figure at fiscal week loc level. Make sure this key figure always has value equals 1 in all combinations at fiscal week prod loc level.

2. Create another key figure KF2 at fiscal month resource loc level with aggregation mode as max. Aggregate this key figure at resource loc level (without time dimension)

3. Add below calculation to a new key figure KF3 defined at fiscal week resource location level -

KF3 at fiscal week resource location = KF1 at fiscal week loc x KF2 at resource loc.

This calculation will bring KF1 from loc level to resource loc level. Define aggregation mode as SUM at request level for this key figure. Aggregating KF3 at fiscal month would give weeks in fiscal month. Aggregating KF3 at fiscal qtr would give weeks in fiscal qtr. PFB sample illustration.

Hope this helps!!

Regards,

Piyush

[eddyizaguirre3 · Accepted solution]

Thank you Piyush!

I will try this today and let you know!

[piyush_parekh]

Hi,

Add a calculation at request level. Total Capacity per week at request = Total Capacity at request / Weeks in a month at request.

Make sure you have SUM defined as aggregation at request level of Total Capacity and weeks in a month key figure.

Regards,

Piyush

[eddyizaguirre3]

Hi Piyush,

Thanks for your response!

How would you define the key figure weeks in a month? At which Planning level? that's the part i'm struggling with because I don't want the key figure to add values within the Location or resource data hierarchy.

Cheers!