Disaggregation Expression when Aggr level is NULL

[djwyllie]

Would like to use a Disaggregation Expression that checks for the ISNULL at the aggregate level the change is being made. If the Aggregate level is NULL, then use Other Key Figure. But if any of the child combinations have a value, then use Same Key Figure. Is this possible??

So, if I make an entry at Prod Family level, if all Products within that Family are NULL, then use other key figure to know the proportionality. But if one product has a value, then use same key figure for all Products when determining the Proportionality. The Aggr level can be different depending on planner needs.

[djwyllie]

Yogananda,

Thank you for your reply.

In your example, the Aggregate Level is fixed in the Disagg Expression. But client wants flexibility to make changes at multiple levels. Can this be supported?? Is there a way to represent the Aggregate Level as dynamic in the Disagg Expression.

[Matthias_H]

Hi djwyllie,

have you found a way to solve your problem?

Kind regards

[yogananda]

djwyllie

According to SAP Community, you can use the ISNULL function in your Disaggregation Expression to check for null values at the aggregate level ¹. If the aggregate level is null, you can use another key figure to determine the proportionality. However, if any of the child combinations have a value, you can use the same key figure for all prod...¹.

Here is an example of how you can use the ISNULL function in your Disaggregation Expression:

IF(ISNULL("Aggregate Level"), "Other Key Figure", "Same Key Figure")

You can replace "Aggregate Level" with the name of your aggregate level and "Other Key Figure" and "...¹.

[Matthias_H]

Hello Yogananda,

unfortunately this solution does not work. This expression does not decide on aggregate level whether KF1 or KF2 should be used as disaggregation factor in general. It decides for each object on the base planning level. This mixes the disaggregation factor. I have the same problem as the questioner. Apparently there is currently no solution to this problem.

Kind regards