Disaggregation expression with attribute to exclude inactive products

[former_member683343]

Hi experts,

We have a requirement to not consider inactive products during disaggregation.

Let's say that I have :

1. Key Figure 'KF1' is stored and editable
2. Attribute : 'PRODINACTIVE' which is part of the base planning level of KF1
3. Product A, for which PRODINACTIVE =X
4. Product B, for which PRODINACTIVE is empty
5. Products A and B are part of the same product family

I am trying to use the disaggregation expression of KF1 like this :

IF("PRODINACTIVE" =''X'' , 0 , "KF1")

Initial situation :

KF1 for Product A = 100

KF1 for Product B = 200

Then, I make an adjustement at product family level to 600

At the base level, I get :

KF1 for Product A = 300

KF1 for Product B = 300

The expected behaviour would be that the full quantity (600) would go on Product B.

Could someone help me with this challenge please?

(I know that the same result can be achieved by applying the correct filters in the planning view, but the customer wants a double safety net)

Thanks a lot !

Pierre

[AyanBishnu · Accepted solution]

Hi macote

what you described as the requirment and the dissagg expression that you have mentioned seems to be correct from a syntax perspective.

But based on the disaag split no it looks like this expression is not getting respected for the proportion and the KF is getting disaggregated, based on the disagg mode " equal distribution".

The only reason behind such behaviour could the KF is having the previous proportion somehow. So please initialize the KF, that values for the KF gets empty and then put a value of 600 at the product family or any agg level and you will see that the KF value is getting splitted based on the disagg expression.

Let me know if that works or not.