I have created a material forecast planning to allow the consolidation of different material forecasts (Sales plan, repair plan, historical plan, demand plan).
Per material a "multiplier" is defined to correct planning amounts.
I have to include this in my planning cube because the customer wants it as variable planning input to calculate the consolidated forecasts.
As I have different forecast input sources I have to use exception aggregation on the multiplier key figure to avoid summation. A material that comes in via e.g. 2 different input sources will have a multiplier value x2 if no exception aggregation is defined.
It all works fine in the bex query that I have included in the Web Interface, however, the BPS interface part doesn't take notice of the exception aggregation.
What can I do to make this work?