ibp aggregration function on different plaanning level

[giammaria-pace]

Hi experts

I am not sure how the aggregration work in case of different planning levels in input and output;as example please refer: Kf1@PerProdCustGroup=sum (KF2PerProdCustomer).

I was wondering if

1)the system has to know the customers assigned to any customer group?

1.1)does it use the MD?does it mean we must have customer group as attribute of the customer?

2)if we do not have the model defined how will work

2.1)simply aggregate the KF value by ProdPeriod (common level) and

2.2) will replicate the single value per ProdPeriod in every possible customer group under the ProdPeriod value.Are you able to confirm this?

In general I am looking for more infomration on how the calculation work in order to be able to avoid bugs as much as possible.

Cheers,

Giammaria

[AyanBishnu · Accepted solution]

Hello giammariapace

Kf1@PerProdCustGroup=sum (KF2PerProdCustomer)

The above example that you have provided will work correctly. A kf is tagged to a base PL which in turn is tagged to different MDTs that are used to create the planning level. Hence the system checks the MDT to determine which all customer belongs to a particular group and accordingly it will aggregate the values.

So in the customer MDT you need to update the customer group for each customer and then the customer group attribute should be used in the required planning level for view the aggregated values at PROD and GROUP level.

If you dont have the model defined for customer to customer group then all products will be aggregated to customer group as "none".

Hope this helps

[giammaria-pace · Accepted solution]

Hi Bishnu

let's say: I have Customer group in CustomerGroupMD and CustomerID in CustomerMD,therefore both attributes in 2 different MD not correlated but populated .

than you mean SUM(KF2) will result in aggregation at PerProd but what will be reported on PerProdCustGroup under the same PerProd but differeent Cust group?

Input is

Table : W1 W2

P1 C1 10 20

P1 C2 1 2

P1 C2 3 7

what would be the output?

table : W1 W2

P1 CG1 ? ?

P1 CG2 ? ?

[AyanBishnu · Accepted solution]

If cusotmer group and cusotmer id are in 2 separate MDT and their in no relationship between customer ID and customer group then the SUM(KF2) will aggregate all customer id under "none" customergroup. Unless you have a relationship defined that says each customer belongs to which customer group it wont work.

As you mentioned that you have 2 MDTs one for customer ID and other for customer group, either you have to create an addtional reference MDT where you define the relationship between customer id and customer group and use that MDT in the planning level to get the desired agg caluclation work, or simply you have include the attribute customer group in the MDT that has customer ID and update it.

What I am still struggling to understand is why thier is 2 separate MDT for customer ? one for customer ID and other for customer group, customer group without a refence to cutomer ID doesnt really make any business sense, unless thier is some explicit reason to do so.

[giammaria-pace · Accepted solution]

Hi Bishnu

all this is simply an example that I found on a course where the MD requirements was not defined

thanks

Cheers,

Giamma

[arvind_pabba1]

Hello giammariapace,

The Customer group would be generally a higher categorization than the customer number. Then whenever we verify the data at the aggregated level it would consider the attribute (Customer group) which could aggregate the different multiple customers may be under a single customer group and show the KF values in accordance with it.

Please find the below example on how the same KF is showing the different values by modified attribute from customer to customer group.

Please let me know if you question is answered.

Best Regards

Arvind Pabba.

[giammaria-pace]

Hi Arvind

I do not see any example reported

Cheers,

Giammaria