cancel
Showing results for 
Search instead for 
Did you mean: 

aggregation mode along one dimension (product) different than along the time dimension

0 Kudos

Dear All,


In IBP S&OP, Is it possible that the aggregation mode along one dimension (product) could be different than along the time dimension?

For a demo, a customer has an input at the product family level (vehicle production) which we just “copy” for disaggregation purposes, to the product level (parts), see attached. So for aggregation we used average.

However, time-wise, we need to sum it up.

Thanks for your insight and help.

Kind Regards,

Omar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Omar,

Yes it is possible.

1. Create a new planning level (say PERPRODCUST1) which will be a copy of PERPRODCUST (you base planning level).

2. In the PER section of PERPRODCUST1, do NOT mark any period attribute as root. In other words, the roots for this PL will only be PRDID and CUSTID.

3. Now your KF calculations will be:

VEHICLEPRODUCTION@PERPRODCUST1 = SUM(VEHICLEPRODUCTION@PERPRODCUST)

VEHICLEPRODUCTION@REQUEST = AVG(VEHICLEPRODUCTION@PERPRODCUST1)

Since your KF is editable, it is worth mentioning that, following the above steps has trade-offs. Since your KF is editable, you will have issues with disaggregation when you enter the values at an aggregated level of both time and other attributes. My recommendation (for your configuration) is that this will work fine as long you enter the values at the root level of you time attribute.

Hope this helps,

Chendur

0 Kudos

Thanks a lot Chendur,

This is working as expected and as you explained.

Neat solution, highlighting the huge potentials and robustness of the inherent data model of IBP.


King Regards,

Omar

Answers (0)