cancel
Showing results for 
Search instead for 
Did you mean: 

Disaggregation based on another key figure

Former Member
0 Kudos

Hello All,

We have a key figure KF1 which disaggregates based on key figure KF2. Both are stored key figures and have the same base planning level. KF1 is editable and KF2 is non editable. KF2 gets loaded into IBP from a different system and each time comes with different proportions. What we noticed is the KF1 does not does not disaggregate reflecting the  new mix unless we change the values of KF1, save and drill down. The requirement is that we will not change the KF1 values all the time. When we set this basis of disaggregation based on another key figure, we expected the KF1 proportions allways reflect the proportions of KF2 without having to change the values of KF1 and save. Is this normal how this disaggregation based on another key figure works? If not, any suggestions how to make this work. Please help.

Kind Regards

Sanjeev

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member217157
Active Participant
0 Kudos

Hi Sanjeev,

The disaggregation works only when you make changes to a Key Figure and Save/Simulate.

In your example, you say that when KF2 is loaded, then KF1 should be disaggregated. But KF1 and KF2 are at same base planning level and you are not loading KF1 data or even if you load, it will be at the base planning level of KF1. So I dont understand  the question about why KF1 should disaggregate based on KF2 when just KF2 is loaded.

Thanks,

Raghav

Irmi_Kuntze
Advisor
Advisor
0 Kudos

Dear Sanjeev

this is normal behavior and the same way than APO does work.

I understand your requirement and do have similar for my customer.

Raghav, point is that KF2 is loaded at detailed level, but people work for KF1 at aggregated level. If for example you don't want to change your value for KF1 on aggregated level butr you have KF3 = KF1 * price at base planing level, you want to see the result of the calculation at aggregated level immediately

Best would be to direct that to development and check if they can add that to their backlog list

And you cannot even work with ADVSIM because that as well only works on aggregated level

Maybe you find a workaround with a calculated KF KFcalc which exists on aggregated level (must than be a fixed defined level, otherwise it does not work which I have already tested) , and on aggregated level KFcalc = sum(KF1@BPL). Than you have a split logic logic that splits KFcalc based on KF2 (split logic works always and not only wen you change). And than you could have a ADVSIM that is triggered when KF2 is changed and copies on lowest level KFcalc to KF1

Just an idea, but it should work

Irmi