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